Doug has already done all of the hard work! The design is genius and simple. The clustered key design combined with LMDB lexicographical key sorting means that pulling data out isn’t as hard as you might think.
Another benefit is compact event storage and 0 serialization overhead when getting data in and out. Damus has already switched to this flatbuffers-style format and it has fixed crashing when pulling my follower list.
The goal is that it will slowly become the engine to my native microapps, so i can have caching, querying, profile processing/lookups, negentropy syncing, parsing(?). All the stuff you need in nostr apps, but contained in a C lib i can use on desktop, android, etc.
So while its called nostrdb now, may expand into libnostr