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.
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
Ooh I didn’t think about that. Makes sense! Thanks.