I think it's unrealistic to redesign the entire web around the "proper" way to store and interact with data, but the reality is we need something that works with the way things are built now.
Discussion
well, nothing's stopping you from going and picking up a job at google building their data systems, well?
You can’t design users around systems, but you can design systems around users
The worst part is if done right the current state of Nostr can scale a lot. Not ideal (a v2 for event format is possibly needed) but possible
the most unfortunate part is lazy devs assume that large databases are not possible, but oh boy they are wrong
how do any large platform work then? nostr being decentralized does not mean they are much different (relays and the backend are effectively same)
I’m not working on implementing a complex query system or multi-level caching crap because the existing tools can scale to the fucking planet