Database settings
The application uses SQLite database by default, with a possibility to change it to your own PostgreSQL database.
Reset database - format local database
Create a backup - create a backup of the current state of the local database
Export database - download selected database file
Import database - upload database file to list
Restore database - restore database from selected backup
Delete backup - delete selected backup
JDBC URL - full JDBC url for postgres database (You can specify schema by adding currentSchema to url)
db.selectzero.io:5432/postgres?currentSchema=my_schemaUsername - postgres database user
Password - postgres database password
Migrating SQLite to PostgreSQL
It is possible to migrate existing SQLite database to a PostgreSQL database using pgloader (installing pgloader)
Make sure the application is version 2023.9 or later
Create backup of SQLite database and download the database file
Set up Postgres connection in Database selector
Restart the application (the application will be deployed on empty schema, creating necessary tables automatically)
Create file dqm.load with content:
LOAD DATABASE FROM sqlite:///path_to_your_backup/backup_file_name.db INTO postgres://username:password@postgres_url:5432/postgres WITH truncate, data only INCLUDING ONLY TABLE NAMES LIKE 'tt_%';Use pgloader to export data from SQLite to PostgreSQL using command and script:
pgloader dqm.load