Subnostr

Been feeling frustrated by the lack of high quality database libraries in TypeScript.

Then I discovered that Postgres ITSELF does not support query cancellation properly:

"Query cancellation works by opening a new connection [...] That means there is no guarantee that the query will be canceled, and due to the possible race conditions it might even result in canceling another query."

You cannot actually cancel a query. You can only cancel a connection. 🤦 Race conditions are inherent to the design.

Wow! Postgres sucks. How is it so popular? MySQL is looking better and better. It's like the bell curve meme with Postgres in the middle and MySQL on the outside. Nothing is ever easy, everything is hard.

Reply to this note

Please Login to reply.

Discussion

frphank 1y ago

SQL databases are 20th century legacy tech. Append only event logs rule.

CARE not CRUD

Alex Gleason 1y ago

I've very tired of everything being cutting edge. I need to use at least one old thing or I'm going to lose it.

frphank 1y ago

I've got one on my desk to calm the nerves every now and then. They're like $5 on AliExpress.

tf 1y ago

What is CARE?

frphank 1y ago

Create, Append, Read, Expire

tf 1y ago

Thanks

H 1y ago

Like 1 month ago "Wow postgres sucks sqlite is the way". What happened with that?

cloud fodder 1y ago

mysql is most excellent, i was surprised you went w postgres cause it seemed like you have experience running stuff at scale.. but also, i get wanting to try new things if that's why. ive seen postgres fail so much i cant take it serious anymore.