3 ms·
> This will create a config file for local and prod databases using sqlite for local and postgres for prod. Hold on, people actually do that? I thought it's tr
by whilenot-dev 1y ago
> This will create a config file for local and prod databases using sqlite for local and postgres for prod.
Hold on, people actually do that? I thought it's trivial to run your database in a container locally.
- dewey 1y agoEspecially if you use any of the features that make Postgres nice to work with (For example good jsonb handling) these are immediately different than on sqlite and then won't work for development. Don't think there's a good reason for not running the same DB in both environments.
- aforwardslash 1y agoYou dont even need to look into advanced features; sqlite does not support ILIKE.
- evanelias 1y agoTo be fair, most databases don't, since ILIKE is not in the SQL standard.