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 t

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.