Just about to start a luminous project and in production we’ll probably use heroku postgres. Should I use postgres in development as well or is H2 recommended?

yes, you should! otherwise you might have weird issues in production that you can't reproduce locally from choosing different dbs

@jayzawrotny H2 is not supported on heroku.

Fair point @rymndhng. I’m aware of that @llsouder sorry if I didn’t communicate what I was asking more clearly.

The sql for H2 and postgres are slightly different. I did the H2 thing then had to "fix" my sql to work with postgres.

Specifically the if exists