The Write Last, Read First Rule

(tigerbeetle.com)

60 points | by vismit2000 7 hours ago ago

3 comments

  • lintfordpickle 31 minutes ago ago

    I found the article interesting, but I don't think I understand what is meant by 'Write Last, Read first' rule - even after reading it a few times. It seems to be too ambiguous a statement to be helpful.

    Under the section 'Order of Operations':

    > "Since the system of reference doesn’t determine existence, we can safely write to it first without committing anything. [...]"

    Then the next paragraph

    > "This principle—Write Last, Read First—ensures that we maintain application level consistency."

    What I think it means is, 'writing-last to the system-of-record' and 'a read-first from the system of record' yields authoritative results, but I don't get that just from the title. Is my understanding correct?

  • jorangreef 3 hours ago ago

    Joran from TigerBeetle!

    Happy to answer any questions. And thanks to Dominik Tornow of Resonate for writing this up as a guest post! It was a little rule we had coined, to help people remember how to preserve consistency across different DBMS's, and I think Dominik gave (beautiful) voice to it.

  • VeritySage07 3 hours ago ago

    This post clearly shows how separating the system of record from the reference, with strict ordering, helps ensure consistency without transactions. The focus on idempotent operations and correct sequencing is practical and vital for reliable distributed systems. Using checkpointing to guarantee eventual correctness even during failures is a smart approach.