Fork me on GitHub
eccentric J00:11:50

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.

eccentric J03:11:24

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

eccentric J23:11:47

Ooh I didn’t think about that. Makes sense! Thanks.