It's not really a database.  Developers think it is, and that's the problem.  Nostr is a relay system.  If you let nostr be nostr, you have a  very powerful tool.  If you try and use nostr for things it wasnt designed to do, you will have an inferior solution.  This is basic computer science.