Database Support

The supported database types are:

  • PostgreSQL

  • MySQL/MariaDB.

Character Encoding

For proper operation, ensure that databases created for GovReady use UTF-8 encoding.

For convenience, we summarize database settings here. Consult your database documentation to ensure you properly set up your database with UTF-8 encoding.

PostgreSQL

CREATE DATABASE "govready_q"
ENCODING 'UTF8'
LC_COLLATE = 'en_US.UTF-8' LC_CTYPE = 'en_US.UTF-8';

MySQL/MariaDB

CREATE DATABASE govready_q
CHARACTER SET utf8mb4
COLLATE utf8mb4_0900_ai_ci;

Connect webapp server to the database

Next, let your development installation of GovReady-Q know that you want to use the custom branding package.

Note

You may configure the database to use ssl certificates. An example connection string would look like:

  • postgresql://govready_q@dbserver.example.com/govready_q?sslmode=verify-full&sslrootcert=/usr/src/app/govready-q/pgsql.crt"