Serializable Transactions In Databases: Workarounds And Best Practices
Serializable isolation level isn't always necessary, use explicit locking or partial indexes for reliable transactions in various databases.
In my previous post, I provided an example of a serializable transaction. I discussed how Oracle Database, PostgreSQL, and YugabyteDB handle it when the transaction's Serializable isolation level is set. In a reply to comments, I mentioned that it is perfectly fine to run such a use case with a database that doesn't provide a serializable isolation level. Before presenting an example, let's clarify that, even if Oracle does not fully implement the ANSI/ISO isolation level, it is not an issue as long as the developers know it. Oracle Database powers critical OLTP applications in hospitals and...