ProgrammerDude
https://blog.lawrencejones.dev/isolation-levels/
#developers #find #surprising #Postgres #transactions
What developers find surprising about Postgres transactions
One Comment
Leave a ReplyLeave a Reply
You must be logged in to post a comment.
https://blog.lawrencejones.dev/isolation-levels/
#developers #find #surprising #Postgres #transactions
You must be logged in to post a comment.
Enter your account data and we will send you a link to reset your password.
To use social login you have to agree with the storage and handling of your data by this website.
AcceptHere you'll find all collections you've created before.
Author here!
Postgres runs at a different isolation level than similar databases like MySQL, which means transactions behave subtly differently.
This means experienced engineers can assume their past experience carries to Postgres, and may be working with an incorrect mental model. The same goes for people who learned transactions theoretically, who may assume Postgres gives you greater guarantees than it actually does.
This explanation has always surprised people- I hope people find it interesting!