Serializable Transactions
Written
- Author: Brandur Leach
- Source: https://brandur.org/http-transactions
- Serializable transactions can catch all sorts of race conditions that normal transactions might not. They allow concurrent transactions to run as if they are running in serial.
- When transactions interfere, one will fail, so you need to have some retry logic or other handling for this.
- SQL:
Start transaction isolation level serializable
Thanks for reading! If you have any questions or comments, please send me a note on Twitter. And if you enjoyed this, I also have a newsletter where I send out interesting things I read and the occasional nature photo.