feat(database): migrate to postgresql 12
To replace H2 which is very complicated, has special syntax and doesn't respect SQL standard,
I choose to migrate to Postgresql (12 at the current time) to use a real good database and be able to extend the system and run better queries.
Task to realize:
-
Migrate the liquibase setup for PostgreSQL -
Adapt queries to use specific operator available in postgresql (on date for example) -
Study a migration task to move data from H2 1.4.199 to PostgreSQL 12 -
Add the tooling associated to database operation like backup in K8S -
Modify the dev.sh
file to allow startup with an embedded postgresql -
Modify the CI to use a Postgresql service for database testing and jooq code generation
Edited by Davin Kevin