📰 Dev.to · Franck Pachot
Articles from Dev.to · Franck Pachot · 107 articles · Updated every 3 hours · View all reads
All
⚡ AI Lessons (9050)
ArXiv cs.AIDev.to · FORUM WEBForbes InnovationOpenAI NewsDev.to AIHugging Face Blog
Dev.to · Franck Pachot
4d ago
The origins of MongoDB
The Internet Archive holds some real gems. Let’s trace the origins of MongoDB with links to its...
Dev.to · Franck Pachot
4d ago
MongoDB Query Planner
SQL databases use query planners (often cost-based optimizers) so developers don’t worry about...
Dev.to · Franck Pachot
1w ago
Single-Cluster Duality View 🃏
In DynamoDB, a single-table design stores one-to-many relationships in a single physical block while...
Dev.to · Franck Pachot
1w ago
Read Concern "snapshot" for snapshot isolation outside explicit transactions
TL;DR: I a previous post I explained Why isn't "majority" the default read concern in MongoDB. If...
Dev.to · Franck Pachot
1w ago
SQL Assertions, ANSI join, and ORA-08697
In the previous post on consistency boundaries, we saw that an updatable join view can hide a...
Dev.to · Franck Pachot
1w ago
Consistency boundaries in SQL databases vs. MongoDB
Two common myths surround database consistency: Myth 1: Only SQL databases provide strong...
Dev.to · Franck Pachot
2w ago
Non-First Normal Forms and MongoDB: an alternative to 4NF to address 3NF anomalies
SQL databases are grounded in relational algebra, but they are not the only databases with a strong...
Dev.to · Franck Pachot
2w ago
MongoDB Transaction Performance
In MongoDB, all data manipulation operations are transactional and ACID. Single-document operations...
Dev.to · Franck Pachot
1mo ago
Updating "denormalized" aggregates with "duplicates": MongoDB vs. PostgreSQL
TL;DR: In database-centric development, duplication is dangerous because, in shared, normalized...
Dev.to · Franck Pachot
1mo ago
PostgreSQL global statistics on partitionned table require a manual ANALYZE
PostgreSQL auto-analyze collects statistics on tables with rows. For partitioned tables, it excludes...
Dev.to · Franck Pachot
1mo ago
From Relational Algebra to Document Semantics
The relational model was designed not to mirror application structures, but to optimize reasoning...
Dev.to · Franck Pachot
1mo ago
Read‑your‑writes on replicas: PostgreSQL WAIT FOR LSN and MongoDB Causal Consistency
In databases designed for high availability and scalability, secondary nodes can fall behind the...
Dev.to · Franck Pachot
1mo ago
Top-K queries with MongoDB search indexes (BM25)
A document database is more than a JSON datastore. It must also support efficient storage and...
Dev.to · Franck Pachot
1mo ago
Relational composition and Codd's "connection trap" in PostgreSQL and MongoDB
Relational composition is to joins what the cartesian product is to tables: it produces every result...
Dev.to · Franck Pachot
1mo ago
Cartesian product (CROSS JOIN) in MongoDB
Relational database joins are, conceptually, a cartesian product followed by a filter (the join...
Dev.to · Franck Pachot
1mo ago
Prisma + MongoDB “Hello World”
Prisma is an ORM (Object-Relational Mapper). With MongoDB, it acts as an Object Document Mapper,...
Dev.to · Franck Pachot
2mo ago
{ w: 1 } Asynchronous Writes and Conflict Resolution in MongoDB
MongoDB guarantees durability—the D in ACID—over the network with strong consistency—the C in the CAP...
Dev.to · Franck Pachot
2mo ago
Normal Forms and MongoDB
I learned about normal forms when databases were designed before the applications that used them. At...
Dev.to · Franck Pachot
2mo ago
Serializable Transactions in MongoDB: The Doctor's On-Call Shift example
In this series, we explored several ways to solve the "Doctor's On-Call Shift" problem (Cahill, Röhm,...
Dev.to · Franck Pachot
2mo ago
The Doctor's On-Call Shift solved with SQL Assertions
In a previous article, I explained that enforcing application-level rules, such as “each shift must...
Dev.to · Franck Pachot
2mo ago
CloudNativePG (CNPG) - install (2.18) and first test: simulate transient failure
I'm starting a series of blog posts to explore CloudNativePG (CNPG), a Kubernetes operator for...
Dev.to · Franck Pachot
2mo ago
PgBench on MongoDB via Foreign Data Wrapper
Disclaimer: This is an experiment, not a benchmark, and not an architectural recommendation....
Dev.to · Franck Pachot
2mo ago
MongoDB compared to Oracle Database Maximum Availability Architecture
Users looking at Oracle alternatives see the limitations of PostgreSQL in terms of high availability...
Dev.to · Franck Pachot
2mo ago
BSON vs OSON: Different design goals
There was a discussion on LinkedIn comparing OSON (the binary JSON in Oracle Database) and BSON (the...
DeepCamp AI