4 ms·
This is how client apps use sqlite, yes. Single instance client apps. Litestream is one method of making sqlite work for server side apps. The hard part on the
by mrkurt 4y ago
This is how client apps use sqlite, yes. Single instance client apps. Litestream is one method of making sqlite work for server side apps. The hard part on the server is solving for multiple processes/vms/containers writing to one sqlite db.
- vmception 4y agointeresting, such a weird way to describe it then. but I guess some people are more familiar with that problem.
- nicoburns 4y ago> the hard part on the server is solving for multiple processes/vms/containers writing to one sqlite db. I feel like if you have multiple apps writing to the database then you shouldn't be using SQLite. That's where Postgres etc completely earn their place in the stack. Where litestream is really valuable is when you have a single writer, but you want point-in-time backups like you can get with postgres.
- mrkurt 4y agoWe disagree, a little. I feel like that if you have multiple apps writing to the DB, Litestream is pretty close to making sqlite viable for a lot more apps.