| ▲ | TekMol an hour ago | |
SQLite has so many advantages over PostgreSQL. No deamon. Single file per DB. Less configuration overhead. | ||
| ▲ | BowBun an hour ago | parent | next [-] | |
Postgres 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). | ||
| ▲ | pstuart an hour ago | parent | prev [-] | |
It'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. | ||