Database Protocols Are Underwhelming

2 points by faebi 3 months ago | 1 comment
  • Terr_ 3 months ago
    > 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