The code is ~500 lines of javascript/sql. It was a lot of fun to make. I'm not sure how well it performs though. I suspect decently - I got really particular with indices that perform well with arrays of prefixes and compound indices where applicable.
I haven't hosted it yet. I'll probably launch a "freelay" at some point to get an idea of what the shape of traffic on nostr is like, then figure out how to financially defend it.
I can highly recommend Postgres.js as an alternative to pg. Performs great, supports pipelining and a more ergonomic way of building queries.
https://github.com/porsager/postgres
It looks excellent.
A nostr relay is pretty light on requirements query-wise, but I imagine postgres.js would be a good choice for an application with more query variety.
Not to belabor the point, but just wanted to add a link to the benchmarks: https://porsager.github.io/imdbench/sql.html
I swapped it in.
Thanks again!
Glad to help! 😊
No, you were right. Pipelining is enough reason to switch. Was planning on rewrite it with postgresjs today.
The code is ~500 lines of javascript/sql. It was a lot of fun to make. I'm not sure how well it performs though. I suspect decently - I got really particular with indices that perform well with arrays of prefixes and compound indices where applicable.
Also, I'm especially proud of my booger graphic. Woke up super early this morning and found a great photoshop tutorial.
Very artisanal
Lol I’m old enough to have forgotten there’s free AI widely available.
I thought you generated it with AI or in some way, lol
Guess that can become a compliment in the near future, haha
Very cool, wanna try this out. Also, whoa, I've never seen/heard of Cucumber before. Looks like an interesting testing framework.
Paid? Or free
I haven't hosted it yet. I'll probably launch a "freelay" at some point to get an idea of what the shape of traffic on nostr is like, then figure out how to financially defend it.
mazin of nostr.wine pulled nearly a TB in about 24hours...
kenny @ rocket-tech.net said he saw 380gb in a few days.
it seems like these things pull down a lot of disk and pipe...
the question is one of retention, it seems. this is all so new i dont think anyone has run out of disk space, just yet :)
That's my understanding. Crazy resource consumption.
Looking forward to it 👀
Who came up with such a stupid na. ...
oh hey, k00b, cool project. Great name!
lol we all autocomplete nostr to nostril. Seemed appropriate. It was also meant to encourage me to have fun while writing it.
The name booger always gets sats from me! 🤣🤣🤣
I am sick, reading this in bed, and seeing the logo just almost made me vomit.
Great job!
Yooo 🔥⚡️