3 ms·
SQLite doesn't really have concepts like replication (HA) or concurrent writers. Notably, the SQLite website is (as far as I can see) read-only. So it's great
by ryanianian 8y ago
SQLite doesn't really have concepts like replication (HA) or concurrent writers.
Notably, the SQLite website is (as far as I can see) read-only. So it's great if all you need is a SQL read API atop your structured data (and 100k hits/day is probably only limited by the filesystem/os since SQLite isn't a server). But you're setting yourself up for headaches by using SQLite if you need simultaneous read/writes combined with HA.