Thanks for the reply. I left the fediverse for nostr full time. I want to see it thrive. Redis caching and postgres backends would help a lot. Hopefully we see s3 support soon for uploads so anyone can host a media server easily like witj minio.
Discussion
It’s already kind of possible with nip96, but as you can guess s3 object storage is not a great solution to the problem. Postgres is also not the best choice for this, cost of scaling is too high even if caching is there. I think more solid approach would be a KV storage backend for events. 🐶🐾🫡🫂