PinnedFranck PachotThe Log Is (not) The DatabaseThere is a common saying “The Log Is The Database”, to explain some database innovations in cloud-native environments. For example, Kafka…Jun 5Jun 5
PinnedFranck PachotOracle Sharding methods compared to YugabyteDBOracle has long been a leader in partitioning, distributing, and replicating databases. They offer shared-storage RAC for High Availability…Feb 201Feb 201
PinnedFranck PachotYugabyteDB: Achieving High Availability and Disaster Recovery with Two Data CentersSynchronous replication in the Raft groups, which requires the majority of replicas for each tablet, is crucial to YugabyteDB’s cluster…Apr 20, 2023Apr 20, 2023
Franck PachotIsolation Levels — part XII: To go furtherSQL isolation levels are typically characterized by their effects, such as anomalies or phenomena, or by their implementation, such as…Dec 18, 2023Dec 18, 2023
Franck PachotIsolation Levels — part XI: Read UncommittedThe Read Uncommitted isolation level is designed to prevent dirty reads, which are changes made by other transactions that have not yet…Dec 13, 2023Dec 13, 2023
Franck PachotIsolation Levels — part X: Non-Transactional WritesPrevious isolation levels described in this series were focused on ensuring consistency of read operations and maintaining the read state…Dec 13, 2023Dec 13, 2023
Franck PachotIsolation Levels — part IX: Read CommittedThe lowest level of MVCC databases is Read Committed, which is commonly used as the default setting. However, it is also possibly the…Dec 10, 2023Dec 10, 2023
Franck PachotThe Most Annoying Optimizer Fail in Postgres ✅ Best index solved it.This blog post is based on a question asked on the PostgreSQL Slack channel (you can join via this invite link…Dec 8, 2023Dec 8, 2023
Franck PachotIsolation Levels — part VIII: Cursor StabilityCursor Stability is not defined in SQL Standard, and I’ve seen it only in DB2. The Cursor Stability isolation level prevents lost updates…Dec 8, 2023Dec 8, 2023
Franck PachotIsolation Levels — part VII: Repeatable ReadThe Repeatable Read isolation level allows changes on what you have scanned, except for rows returned after all filtering conditions. This…Dec 5, 2023Dec 5, 2023