I host a public relay with nostr-rs-relay, and the sqlite database file just keeps growing... there has to be a better way.

I want to believe

I think that would quickly endup in an 60gb index file 🤔 I use this scheme for years (kappa architecture): stream - kafka - indexers (like opensearch or adhoc/specialies processors) - kafka - apps subscribed to "processed" topics...

You mean like a flat filesystem, with no db? Like Nostr version of Hugo?

Trust the engineers :)

The filesystem is itself a single file.

It sounds like a job for Hadoop HDFS. But i don't think it works well on Android.

if we agree on a format, we could use ostree to distribute