• 0 posts
  • 42 comments
Joined 3 years ago
Cake day: June 12th, 2023
  • Atomicity: either all parts of the transaction complete, or all parts of the transaction don’t complete; there’s no “partly complete” state

    Consistency: the state of the database after a transaction is stable; all “downstream” effects (e.g. triggers) of the query are complete before the transaction is confirmed.

    Isolation: concurrent transactions behave the same as sequential transactions

    Durability: a power failure or crash won’t lose any transactions

    Traditionally, ACID is where relational databases shine.

  • A /8 subnet is basically everything after the first of the four segments, e.g. 127.*.*.*. marine_mustang was saying that loopback (what you think of as only 127.0.0.1) is actually an entire subnet, so any address that starts with 127 will hit the loopback interface. TIL, never thought about it much before.