from Hacker News

Database Protocols Are Underwhelming

by faebi on 3/21/25, 9:44 PM with 1 comments

  • by Terr_ on 3/21/25, 9:49 PM

    > idempotency

    Even with the ability to detect that something is a retry, there are more wrinkles, like a query that involves NOW() which would be correct to run now-now [0], but would not accomplish the desired result if run 15 seconds later. Or uses of RAND(), unless there's some control over the seed.

    [0] https://www.youtube.com/watch?v=nRGCZh5A8T4&t=1m17s