Explores how AI agent write patterns stress Apache Iceberg tables and offers patterns like partition isolation and commit queues to maintain performance.
Explores server-side commit deconflicting in REST catalogs for high-concurrency lakehouse writes, focusing on architecture, specs, and operational patterns.
Explains concurrency control in databases, covering 2PL, MVCC, isolation levels, and OCC for handling simultaneous reads/writes.
Explains how Kubernetes API server concurrency controls like --max-requests-inflight work to manage performance and prevent overload.
A tutorial on building a simple database with MVCC to implement and understand the five major SQL transaction isolation levels in 400 lines of code.
Explains the pitfalls of optimistic locking in JPA/Hibernate and how to properly implement it to prevent data overwrites.
Explains how to implement a queue processing system in SQL Server using table hints like UPDLOCK and READPAST to ensure reliable, concurrent processing.
