[Svoka]

I wonder, what amount of PG deployments can be replaced with SQLite. I bet most of them.

[odie5533]

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]

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.