News for hackers. Stuff that matters.

A comment on In Praise of PostgreSQL. Parent comment

Re:In Praise of PostgreSQL by chungy on Thursday August 05, 2021 @10:07PM (#28082511)
SQLite isn't just for datasets that are tiny. There are a few multi-TB-sized SQLite databases around the world.

The main consideration is typically about how the database is used. "Probably only one will be a writer" is a strong argument in favor of SQLite, which doesn't really have much of a concurrency story for writes (multiple processes can open the same SQLite database for writing, but they implement a block so only one at a time can actually write).

The file locks can be tricky to get working over NFS/CIFS with multiple computers, but it's still possible.

[ Parent | on HN ]
Re:In Praise of PostgreSQL by quietbritishjim on Friday August 06, 2021 @02:14AM (#28083868)
But there are a couple of "probably"s in my comment above doing a lot of work. There is probably only one writer, and it's probably all running on one machine - but occasionally one or both of those isn't true, and suddenly SQLite starts to look less attractive.
[ Parent | on HN ]