Replying to Avatar jleger2023

I don't know why I didn't think of it from the beginning. Nostr is a simple, single-document protocol. Mongo is perfect for it. I expanded the event structure so the tags are indexable in Mongo. The performance is jaw-dropping.
Avatar
Sirius 2y ago

Nostr events follow a predefined schema (structured), so I wonder if MongoDB has an advantage there? Especially when it comes to more complex filtering queries. Horizontal scaling sounds good though.

Reply to this note

Please Login to reply.

Discussion

Avatar
jleger2023 2y ago

I didn't expect Mongo's BSON storage format to be so much more efficient than MySQL (which I've been using up 'til now). It's about 1/3rd the size on disk for the same number of records. That naturally makes the indexes much more efficient, and Mongo allows multikey indexes that makes querying the tags lightning fast. I'm very impressed with its performance for this use case.