cameri / nostream

A Nostr Relay written in TypeScript
MIT License
733 stars 189 forks source link

Feature Request: alternative storage adapters #147

Open mikestaub opened 1 year ago

mikestaub commented 1 year ago

have you considered using another SQL engine like cockroach db?

I worry that postgres may have trouble scaling to millions of users without significant devops effort

https://github.com/cockroachdb/cockroach/blob/master/docs/design.md

cameri commented 1 year ago

@mikestaub yes, I've considered it and like the idea. I was actually thinking about this recently

kevinsmith commented 1 year ago

Would be great to make it easy for relay operators to plug into serverless offerings like Neon (postgres) and PlanetScale (mysql) too. They can both handle tremendous volume but have excellent free tiers. Should be relatively easy with Neon once it's generally-available since it's postgres.