Replying to Avatar scsibug

No plans to support other DBs.  Would be open if someone wanted to do the work to make it pluggable; but I am partial to it being the best SQLite relay out there, not necessarily the best for all DB's.
Avatar
Nordlys 3y ago

Fair enough. But if relays store all historical data then it’s going to be a pain to be a mega relay with a SQLite based backend. SQLite isn’t exactly built for scale.

Reply to this note

Please Login to reply.

Discussion

Avatar
scsibug 3y ago

I figure it can scale "big enough" for a decent sized community to use, and hopefully will be more than usable on a $5/month tiny VPS.  But I'm also eager for first-hand knowledge of how far SQLite /can/ scale.

Avatar
Leo Wandersleb 3y ago

Ok, good to know. I'm shopping for options what to put on my beefy server (8vCPU, 32GB RAM) and assumed sqlite might not be the solution. On the other hand, all nostr events still fit comfortably into RAM :D

Avatar
chris 3y ago

I’m running it on a tiny ~$6/month VPS and it works great. Thank you!!

Avatar
Leo Wandersleb 3y ago

But what are you doing with it? If it's one of the big, Astral default relays: hat off! If it's your backup of everything, yeah, not so interesting.