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.