As described in #25, we want to introduce a managed database running on PostgreSQL instead of the current self-hosted SQLite database. This pull request implements #25. List of changes:
Changes to the app configuration to use a postgresql adapter
Tweaks the schema to be more appropriate for the new database
Changes Makefile to generate and drop a database instead of copying
Changes pipeline to no longer mount a database volume but instead inject the database URL from github secrets
Adds a migration script to import data from the SQLite db
Probably something else i have forgotten
OBS: We will need to run the migrate script more or less immediately after merging this and successfully deploying
As described in #25, we want to introduce a managed database running on PostgreSQL instead of the current self-hosted SQLite database. This pull request implements #25. List of changes:
OBS: We will need to run the migrate script more or less immediately after merging this and successfully deploying