Comment by dewey

Comment by dewey a day ago

2 replies

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.