5 ms·
If you turn on WAL mode in SQLite, then a single writer does not block concurrent readers. There are good reasons to shard SQLite databases if you want multipl
by mappu 4y ago
If you turn on WAL mode in SQLite, then a single writer does not block concurrent readers.
There are good reasons to shard SQLite databases if you want multiple concurrent writers, but i think this particular use case is fine without sharding,
- harryvederci 4y agoI haven't looked into WAL mode too much, thanks for mentioning it. 2 justifications for (probably) keeping my current approach are: - I can do per-user migrations, with zero downtime for other users. - I only sync data with the global read-only DB file that is intended to be public. The name, picture, email address, etc of the user is never part of the global db file, so it's less likely to leak in case something would go wrong.