PinnedUnique Index on NULL Values in SQL & NoSQL databases — an exampleYou can create a unique index explicitly or implicitly with a unique constraint to ensure that a group of columns has no duplicates…Jan 15Jan 15
PinnedThe 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 5, 2024Jun 5, 2024
I would argue the opposite: Consensus for Data is necessary for OLTP systems of records.>> CfM is better for most OLTP applicationsOct 15, 20241Oct 15, 20241
Oracle 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 20, 20241Feb 20, 20241
Isolation 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
Isolation 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
Isolation 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
Isolation 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
The 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
Isolation 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
