3 ms·
SQLite has so many advantages over PostgreSQL. No deamon. Single file per DB. Less configuration overhead.
by TekMol 1mo ago
SQLite has so many advantages over PostgreSQL.
No deamon. Single file per DB. Less configuration overhead.
- pstuart 1mo agoIt's probably perfect for a majority of work (and DuckDB takes that even further). But for big, multi-writer work PG is the way to go.
- BowBun 1mo agoPostgres also has many advantages over SQLite. Supporting more than 1 writer per process. Strict typing. Access controls. Replication at scale is more effecient than copy-pasting files (seems SQLite has improved on this one).