Comment by Svoka 6 days ago I wonder, what amount of PG deployments can be replaced with SQLite. I bet most of them. 2 comments Svoka Reply odie5533 6 days ago If AWS starts supporting SQLite I'd consider it. I need managed services, PITR backups, read replicas, and failover. My needs are simple like a web app talks to database in us-east-1. It doesn't seem like SQLite is built for that. faangguyindia 6 days ago I used sqlite when app is writing only a few records per secondIf it has to write lots of stuff concurrently I use postgres.And if I have even higher concurrency needs I write to redis and write an aggregator loop which writes to postgres every few seconds.
odie5533 6 days ago If AWS starts supporting SQLite I'd consider it. I need managed services, PITR backups, read replicas, and failover. My needs are simple like a web app talks to database in us-east-1. It doesn't seem like SQLite is built for that.
faangguyindia 6 days ago I used sqlite when app is writing only a few records per secondIf it has to write lots of stuff concurrently I use postgres.And if I have even higher concurrency needs I write to redis and write an aggregator loop which writes to postgres every few seconds.
If AWS starts supporting SQLite I'd consider it. I need managed services, PITR backups, read replicas, and failover. My needs are simple like a web app talks to database in us-east-1. It doesn't seem like SQLite is built for that.
I used sqlite when app is writing only a few records per second
If it has to write lots of stuff concurrently I use postgres.
And if I have even higher concurrency needs I write to redis and write an aggregator loop which writes to postgres every few seconds.