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 concur

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.