khatru looks quite interesting, I'll have a look maybe I can plug in the database as an option in there and start contributing to it instead of building a separate relay. Thanks for the pointer!

I defer to this post I wrote in 2015 about CouchDB: View article → But I don't think CouchDB is good for anything anymore since they got rid of the concept of couchapps instead of fixing it, then turned it into a boring and slow MongoDB copy.

Phasing out couchapps was a bummer indeed, it was what originally got me excited about CouchDB. But regarding querying and performance, they have come a long way, the MongoDB-like queries are as fast as the views and allow you to do things that are indeed cumbersome with views. In my attempt at a NOSTR relay storage, I'm not touching views at all at the moment, it's only these Mango queries. I find the views API helpful when you want to use the reducer functionality to easily sum/average millions of records. Recently they added a built-in full-text search engine which is really nice to have to avoid external dependencies.