4 ms·
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
by dewey 1y 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 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.