/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.
You are here

 postgresql.verite.pro
Isolation Repeatable Read in PostgreSQL versus MySQL
| | siddharthsabron.in
Understanding Isolation in Database - Siddharth Sabron
2.5 parsecs away

Travel
| | A comprehensive guide to ACID transaction isolation levels. Understand how modern database systems handle concurrent transactions without data interference.
| | sookocheff.com
Paper Review: Generalized Isolation Level Definitions | Kevin Sookocheff
1.9 parsecs away

Travel
| | Title and Author of Paper Generalized Isolation Level Definitions, Adya et al. Summary The ANSI SQL standard defines isolation levels allowing database users to trade off between performance and consistency when running transactions. Unfortunately, the wording in the SQL standard is geared towards locking as the sole supported concurrency method. This paper presents alternative definitions to the isolation levels specified in the ANSI SQL standard that are general enough to allow for any concurrency method (multi-version, optimistic, etc.) to be used.
| | pgdba.org
Time and relative dimension in space - PostgreSQL DBA
0.8 parsecs away

Travel
| | [AI summary] This technical article explains the Multi-Version Concurrency Control (MVCC) and transaction isolation levels in PostgreSQL, including how XIDs work and common concurrency issues.
| | www.adamconrad.dev
Storage and retrieval - Adam C. Conrad
23.8 parsecs away

Travel
| Ch 3 of my book club review of Designing Data-Intensive Applications by Martin Kleppmann.