Use hibernate database initialization or not ?

[Nolife999]

Hello,

The schema-postgresql.sql from src/main/ressources had been removed in a previous commit. We made this file in toulouse so that hibernate could initialize automatically the database on startup
when the following properties are set :
spring.datasource.initialization-mode=always
spring.datasource.initialize=true
spring.jpa.hibernate.ddl-auto=update

This autoinitialization works well with postgres as the script won't do anything if the database is already created. That was very handy when we deployed the application on the cloud or if we want to patch the application.

The other and current option is that the user builds itself the database with the script is2_postgres.sql found in db . Also the current docker compose uses this file and it should works well.
Will our deployements on the cloud use docker image or do we have to add a call to this external script for database initialization ?

Note also that the schema-postgresql.sql is more complicated to update than the is2_postgres.sql

What option do we want ?

[francescoamato]

Hi @Nolife999,
we usually use the scripts contained in the db folder, for the different databases.
The is2_postgres.sql file is also used for building the docker image in the db.Dockerfile file.