2 ms·
> And, finally: SQLite wants a single writer per database. But there's no rule that says your entire app has to land in a single .db file. I like finding hints
by bob1029 4y ago
> And, finally: SQLite wants a single writer per database. But there's no rule that says your entire app has to land in a single .db file.
I like finding hints of our architecture scattered across these SQLite threads :D
It's very sketchy trying to slam all users into a single physical database. If you can slice up the users along unit of work, session, customer, account, etc., you can go horizontal very quickly.