related posts
10.2k sats \ 5 replies \ @tamstrup 21 Feb 2023 freebie
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
reply
0 sats \ 4 replies \ @k00b OP 21 Feb 2023
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.
reply
10.4k sats \ 3 replies \ @tamstrup 23 Feb 2023
Not to belabor the point, but just wanted to add a link to the benchmarks: https://porsager.github.io/imdbench/sql.html
reply
10 sats \ 1 reply \ @k00b OP 23 Feb 2023
I swapped it in.
- 30% faster performance in my integration tests alone
- the code is more concise
- I got rid of a handful of deps
Thanks again!
reply
1 sat \ 0 replies \ @tamstrup 24 Feb 2023
Glad to help! 😊
reply
0 sats \ 0 replies \ @k00b OP 23 Feb 2023
No, you were right. Pipelining is enough reason to switch. Was planning on rewrite it with postgresjs today.
reply
434 sats \ 5 replies \ @k00b OP 21 Feb 2023
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.
reply
307 sats \ 0 replies \ @rheedi0 21 Feb 2023
Very cool, wanna try this out. Also, whoa, I've never seen/heard of Cucumber before. Looks like an interesting testing framework.
reply
22 sats \ 3 replies \ @k00b OP 21 Feb 2023
Also, I'm especially proud of my booger graphic. Woke up super early this morning and found a great photoshop tutorial.
reply
705 sats \ 1 reply \ @rheedi0 21 Feb 2023
Very artisanal
reply
26 sats \ 0 replies \ @k00b OP 22 Feb 2023
Lol I’m old enough to have forgotten there’s free AI widely available.
reply
695 sats \ 0 replies \ @ek 22 Feb 2023
I thought you generated it with AI or in some way, lol
Guess that can become a compliment in the near future, haha
reply
193 sats \ 1 reply \ @cryptocoin 21 Feb 2023
Who came up with such a stupid na. ...
oh hey, k00b, cool project. Great name!
reply
74 sats \ 0 replies \ @k00b OP 21 Feb 2023
lol we all autocomplete nostr to nostril. Seemed appropriate. It was also meant to encourage me to have fun while writing it.
reply
10 sats \ 0 replies \ @TNStacker 22 Feb 2023
The name booger always gets sats from me! 🤣🤣🤣
reply
10 sats \ 0 replies \ @022fbc9cef 22 Feb 2023
I am sick, reading this in bed, and seeing the logo just almost made me vomit.
Great job!
reply
0 sats \ 4 replies \ @BlokchainB 21 Feb 2023
Paid? Or free
reply
394 sats \ 3 replies \ @k00b OP 21 Feb 2023
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.
reply
732 sats \ 1 reply \ @JohnRawlins 21 Feb 2023
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 :)
reply
20 sats \ 0 replies \ @k00b OP 21 Feb 2023
That's my understanding. Crazy resource consumption.
reply
0 sats \ 0 replies \ @Busybe3z 21 Feb 2023
Looking forward to it 👀
reply
0 sats \ 0 replies \ @ski 21 Feb 2023
Yooo 🔥⚡️
reply