News for hackers. Stuff that matters.

A comment on I Migrated from a Postgres Cluster to Distributed SQLite with LiteFS. Parent comment

Re:I Migrated from a Postgres Cluster to Distributed SQLite ... by kgeist on Friday January 06, 2023 @08:11AM (#34274215)
Interestingly, our SRE people specifically have a rule "never share the DB and the app on the same server", because apparently a high load on the DB can decrease the overall performance of the server. It also allows them to freely add new DB servers (sharding) without touching the app server
[ Parent | on HN ]
Re:I Migrated from a Postgres Cluster to Distributed SQLite ... by chillfox on Friday January 06, 2023 @10:30PM (#34284842)
That makes sense with client/server databases and if you are trying to separately manage database resources from app resources. When you use SQLite you have basically decided that the database and the app is one integrated unit that you will manage as a whole.
[ Parent | on HN ]