4 ms·
Lowest common denominator database feature set makes a DBA sad. I love SQLite, but Postgres is just so much more feature full, it's no contest. If all you need
by ttfkam 5y ago
Lowest common denominator database feature set makes a DBA sad. I love SQLite, but Postgres is just so much more feature full, it's no contest.
If all you need is what SQLite can provide, go for it! It's lightning fast and astonishingly low overhead.
But other times you just need those event triggers and advanced indexing and range types and rollup and grouping sets and writable CTEs and lateral joins and materialized views and row-level security and…
- mekster 5y agoYes, you can't possibly write triggers and checks on columns across different databases to the point you should be doing all data checks in the app if you're going to support multiple databases. These days, there's docker, so I see less point supporting multiple databases.