Replying to Avatar Alex Gleason

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.

Avatar
frphank 1y ago

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

CARE not CRUD

Reply to this note

Please Login to reply.

Discussion

Avatar
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.

Avatar
frphank 1y ago

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

Thread collapsed
Thread collapsed
Avatar
tf 1y ago

What is CARE?

Avatar
frphank 1y ago

Create, Append, Read, Expire

Avatar
tf 1y ago

Thanks

Thread collapsed
Thread collapsed
Thread collapsed