And in my own experience, I believe you don't need as much server resources to efficiently power sqlite over a chonker postgres
Discussion
It all depends on so many factors, that “benchmark” is meaningless. What was the setup, what was the schema, what was the data, what was the cardinality, what access pattern, etc… 🐶🐾🫡
Absolutely. This was just in my own experience with my own project. Only a few tables of json with high cardinality on a basic 1 vCPU and on 1gb ram NVMe vps. It's access patten was read-only as that was only what I wanted to test. I could run the same with less specs using sqlite than postgres. But again this was simply for my own project. I'm sure it might be different for another environment.
Oh yeah, your use case and HW specs are not PG candidate for sure. SQLite 💯🐶🐾🫡