PinnedFranck Pachot·Nov 23, 2025Data Locality vs. Independence: Which Should Your Database Prioritize?When your application needs several pieces of data at once, the fastest approach is to read them from a single location in a single call…
PinnedFranck Pachot·Aug 2, 2025MongoDB High Availability: Replica Set in a Docker LabOriginally published on: https://dev.to/franckpachot/mongodb-high-availability-replicaset-in-a-docker-lab-4jlc
PinnedFranck Pachot·Jan 15, 2025Unique 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…
PinnedFranck Pachot·Jun 5, 2024The 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…
Franck Pachot·Dec 21, 2025JSONB vs. BSON: Tracing PostgreSQL and MongoDB Wire ProtocolsThere is an essential difference between MongoDB’s BSON and PostgreSQL’s JSONB. Both are binary JSON formats, but they serve different…
Franck Pachot·Oct 15, 2024I would argue the opposite: Consensus for Data is necessary for OLTP systems of records.>> CfM is better for most OLTP applicationsA response icon1A response icon1
Franck Pachot·Feb 20, 2024Oracle Sharding methods compared to YugabyteDBOracle has long been a leader in partitioning, distributing, and replicating databases. They offer shared-storage RAC for High Availability…A response icon1A response icon1
Franck Pachot·Dec 18, 2023Isolation 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…
Franck Pachot·Dec 13, 2023Isolation 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…
Franck Pachot·Dec 13, 2023Isolation 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…
