can you use search AND other filters?
nostr:npub1l2vyh47mk2p0qlsku7hg0vn29faehy9hy34ygaclpn66ukqp3afqutajft new bluge-powered search-only eventstore backend for Khatru just dropped: https://github.com/fiatjaf/eventstore/tree/master/bluge
There is no README, no docs. I'll deploy it to custom.fiatjaf.com soon and see if it works and then I'll write that. In my local tests it was good. Not 100% accuracy, but very fast.
The idea is that for queries without "search" you go to the normal backend, for queries with "search" you only use this. And it doesn't store the events twice, only the indexes. The events are fetched from the other database backend based on id results from the search.
Discussion
Yes, but not from the user side, I think I would have to parse the user query and translate that into instructions for the library on my side, which I haven't done (yet). Do you want that?
Tbh I wrote my own relay for zapstore: ftsrelay - it does NIP-50 full text search alongside other filters. Bun + sqlite fts, it's working surprisingly well
But I haven't done any serious perf tests. I would want to have other relays with the same feature set in case something goes wrong with ftsrelay, or for the time when more users would want to run their own zapstore-compatible relays (i.e. they need to be full text indexing certain fields of certain events)