Nostr is a relay sytem.  Its not a storage system.  Its not a database.  It is ephemeral by design.  It is not designed for complex queries.  Almost all of nostr's probems can be solved by realizing this simple reality.  Simply let nostr be nostr, and you are golden.   

 🎯 

 Are you shipping a self hosting solution that bundles solid with nostr? 

 yes 

 I've been coming around to this same recognition.

Permanent storage should be off Nostr, whether it's on user personal devices or somewhere in the cloud. 

 💯