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
The sql for H2 and postgres are slightly different. I did the H2 thing then had to "fix" my sql to work with postgres.
Ooh I didn’t think about that. Makes sense! Thanks.