Relay devs sleeping on Redis's json document store feature. It's absolutely blazing fast, highly queryable and still open source via Redis Community Edition.

I took some time yesterday to do some testing on it and wow. It's really quite amazing. Simply create an index on all the needed fields and you have powerful querying capabilities. Even tags!

As part of my work on Seer and Nip29 Im also writing a Nip29 focused relay that's easy to run and it will use redisJSON as its db.

Very excited about this.

You can read more about it here. https://redis.io/docs/latest/operate/oss_and_stack/