Comment by 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.