Stay safe from ACID rains
- Hi! Could you briefly introduce yourself?
- I’m a freelance software engineer working with databases in general since 25 years, and with PostgreSQL as a premium choice since version 7.4.
- How do you engage with the PostgreSQL community?
- By participating in some discussions on the hackers or general mailing-lists, reviewing or submitting patches in commitfests, sharing bits in blog posts, writing extension code released under the PostgreSQL license.
- Have you enjoyed previous pgDay Paris or other PostgreSQL Europe conferences, either as attendee or as speaker?
- I attended several pgDay Paris in previous years, and it will be my first time as a speaker.
- What will your talk be about, exactly? Why this topic?
It’s about how concurrent transactions in SQL can be unsafe at lower isolation levels, and how serializable transactions solve that problem since PostgreSQL 9.1.
Most people know that we must use transactions to benefit from atomicity (the A in ACID), but more people should be aware that proper isolation (the I in ACID) is a choice that needs to be exercised.
- What is the audience for your talk?
- Anyone who writes SQL code for production use might be interested in this topic.
- What existing knowledge should the attendee have in order to follow your talk?
- A very basic knowledge of the SQL language is sufficient.
- Which missing feature would you most like to see in PostgreSQL?
- At the moment, Global Temporary Tables.
- Thank you!