Conference Schedule - PGConf NYC 2022

The I in ACID

Date: 2022-09-22
Time: 15:45 - 16:35
Room: Room 3
Level: Advanced

Why talk about old things like ACID properties? We all know everything we need to know about that, right? Well, I found out that even though these properties were old, well known, and beautifully documented, it didn't mean people actually understood them. I found myself repeatedly explaining how it works, what tradeoffs were made, and why.

Particularly, transaction isolation and its anomalies were not commonly known and I found out developers adding extra layers in their applications instead of simply adjusting their database isolation level for that particular query.

After explaining globally ACID properties, we'll focus on transaction isolation, transaction isolation anomalies and in what case a developer should care about transaction isolation.

Speaker

Lætitia Avrot