Or you could just say that relays are for relaying messages, and everything else goes in the DB. There is no serious site on the internet that operates on a one-table one-column string database, and with a limited query lanaguage, at that. It's quite amazing what has been done with such a primitive, toylike, tool. But ultimately anything serious will need proper infrastructure.
Discussion
Well, yeah, but most Nostr stuff isn't serious. The Serious People have all at least looked into adding databases.
Scriptkiddies aren't going to bother worrying about query optimization, complex filters, persistent versioning, and etc.
They're just like:
1) Use AI and NDK to make a buggy javascript client
2) Post note to internet over domain only paid through for 3 months
3)
