Very true. I think that rs relay for nostr should get more love. 🐶🐾🫡
Discussion
Reads are faster than writes with sqlite at least
That’s applicable to almost any DB, almost 🐶🐾🫡
Benchmarked against pgsql, for a read-heavy prod you'd want to use sqlite though
Unless something has changed in the last year or two? 😅
And in my own experience, I believe you don't need as much server resources to efficiently power sqlite over a chonker postgres
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 💯🐶🐾🫡