Intro to ACID Database Transactions | Systems Design Interview: 0 to 1 with Google Software Engineer

Implementing isolation in databases both takes a long time and is hard - only days ago I heard the exact opposite about my chode

[firoufirou]

According to wikipedia, consistency is more about keeping the DB always in a state that respects the rules:

Consistency ensures that a transaction can only bring the database from one consistent state to another, preserving database invariants: any data written to the database must be valid according to all defined rules, including constraints, cascades, triggers, and any combination thereof. This prevents database corruption by an illegal transaction. Referential integrity guarantees the primary key–foreign key relationship

[quanghoang]

wow, congratzz, you survived the first wave

[ethanwcheatham]

Feels like a fever dream watching this now getting hit with the bath water

[TwoiChai]

okay. I was under my table after the foot picture transaction

[chrisrectenwald]

You should provide the readings that helped you come up with this vidya