Recommendations on setting up a workflow with h2 embedded in dev environment and postgresql in prod

Hi everyone,

Can anyone maybe point me in the right direction for this question? I’d like to keep using H2 embedded in my dev environment but use postgresql when pushing my app to the cloud. Are there any handy workflow tips for this or is this even possible without having to alter the property file constantly?

Basically, what you need to do is pass in the database parameters as environment variables and include the postgresql dependency in the production profile in your build file

That said, it might be better to stick to the same database in both development and production as there can be subtle differences in how they do things and you don’t want to run into those only when you go into production