4 ms·
Use Postgres. Or if you insist on this type of architecture use CouchDB. I shudder thinking about a SQLite schema migration across clients with potentially unkn
by endisneigh 3y ago
Use Postgres. Or if you insist on this type of architecture use CouchDB. I shudder thinking about a SQLite schema migration across clients with potentially unknown versions.
Seems like a disaster waiting to happen unless you have a bunch of logic centralized somewhere to keep track of last know schemas per user client database. And if you’re going to do all that, unless you desperately need low latency (in which case you could use a multi region database like cockroach), why not just centralize?
- simonw 3y ago"unless you have a bunch of logic centralized somewhere to keep track of last know schemas per user client database" I've been building exactly that here: https://github.com/simonw/sqlite-migrate https://github.com/simonw/sqlite-migrate