I'd like to learn how to migrate a relay database. Say I want to move my private relay from umbrel to Start9. Maybe a relay migration tool? Maybe a "broadcast all to [relay x]" or something...
Nostr seems good for uncensorable, recent information.
But suppose the year is now 2033.
How many relays will still store this note? And who will be making queries for it?
If you're gonna use nostr for something that needs long term storage like maybe highlighter.com by nostr:npub1l2vyh47mk2p0qlsku7hg0vn29faehy9hy34ygaclpn66ukqp3afqutajft (fucking amazing), you'll want a private relay or some kind of relay as a service.
It's still on you to take responsibility for your data if you want to truly own it!
Discussion
Many of them all use sql should be pretty easy to build, I expect over time devs will build these tools