Comment by whilenot-dev

Comment by whilenot-dev a day ago

3 replies

> 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 a day ago

Especially 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 a day ago

    You dont even need to look into advanced features; sqlite does not support ILIKE.

    • evanelias a day ago

      To be fair, most databases don't, since ILIKE is not in the SQL standard.