All
Articles 111,212Blog Posts 121,362Tech Tutorials 28,339Research Papers 22,452News 16,641
⚡ AI Lessons
Dev.to · Franck Pachot
⚡ AI Lesson
1d ago
PostgreSQL query planner parameters and prepared statements
PostgreSQL provides several planner configuration parameters, such as enable_seqscan and...
Dev.to · Franck Pachot
3d ago
Extended RUM in DocumentDB: B-tree-like ordered scans for flexible BSON in PostgreSQL
The main challenge in document database indexing is the flexibility of fields: the same path can be a...
Dev.to · Franck Pachot
⚡ AI Lesson
1w ago
$lookup join strategies: understanding the trade-offs with flexible documents
In a previous post, I explored how MongoDB chooses between nested loop, indexed loop, and hash join...
Dev.to · Franck Pachot
📣 Digital Marketing & Growth
⚡ AI Lesson
3w ago
HorizonDB preview: automate a reproducible lab with ARM
Azure HorizonDB is a new database service on Azure. It is PostgreSQL-compatible from a developer...
Dev.to · Franck Pachot
3w ago
RUM—Storing More in the Index
This series of posts traces the evolution from GIN to RUM to Extended RUM, showing how a single...
Dev.to · Franck Pachot
3w ago
GIN: Understanding PostgreSQL's Inverted Index and Its Limitations
This series of posts traces the evolution from GIN to RUM to Extended RUM, showing how a single...
Dev.to · Franck Pachot
⚡ AI Lesson
4w ago
Extended RUM in DocumentDB extension for PostgreSQL: Efficient ESR (Equality, Sort, Range) Queries
Last year, I examined RUM indexes within this series on multi-key indexing, demonstrating that they...
Dev.to · Franck Pachot
⚡ AI Lesson
1mo ago
Filter on Children, Sort by Parent: One-to-Many Compound Index Strategies in PostgreSQL
Before looking at PostgreSQL, I'll first introduce the problem by showing how MongoDB's document...
Dev.to · Franck Pachot
1mo ago
$exists and non-sparse indexes in MongoDB and in other DocumentDB
In SQL databases, NULL represents an unknown value — not the absence of a value. When a value is...
Dev.to · Franck Pachot
⚡ AI Lesson
1mo ago
The Autovacuum Scale Factor Problem at Scale - Know Your Defaults
In PostgreSQL, autovacuum and autoanalyze exist to clean up dead tuples (old versions of...
Dev.to · Franck Pachot
1mo ago
PostgreSQL EXCLUDE constraints for better concurrency than serializable
> Two groups of friends try to book seats ranges 5–8 and 7–9 in the same row, for the same show,...
Dev.to · Franck Pachot
⚡ AI Lesson
1mo ago
You need foreign keys and surrogate keys because you broke your relationships
Many developers believe they need a relational database because their data has relationships. The...
Dev.to · Franck Pachot
2mo ago
Codd's Connection Trap and Oracle's JOIN TO ONE
In a previous post, I explored Codd's connection trap in PostgreSQL and MongoDB — the classic pitfall...
Dev.to · Franck Pachot
2mo ago
Anti-Join in MongoDB
SQL databases implement anti-joins—finding rows with no match—through NOT EXISTS. Although anti-join...
Dev.to · Franck Pachot
2mo ago
Mutable BSON and Oracle OSON
AskTom Live is a great source of information from Oracle developer advocates and product managers,...
Dev.to · Franck Pachot
⚡ AI Lesson
3mo 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
⚡ AI Lesson
3mo ago
MongoDB Query Planner
SQL databases use query planners (often cost-based optimizers) so developers don’t worry about...
Dev.to · Franck Pachot
⚡ AI Lesson
3mo 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
3mo 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
📊 Data Analytics & Business Intelligence
⚡ AI Lesson
3mo 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
⚡ AI Lesson
3mo 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
⚡ AI Lesson
3mo 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
⚡ AI Lesson
3mo ago
MongoDB Transaction Performance
In MongoDB, all data manipulation operations are transactional and ACID. Single-document operations...
Dev.to · Franck Pachot
🔧 Backend Engineering
4mo ago
Updating "denormalized" aggregates with "duplicates": MongoDB vs. PostgreSQL
TL;DR: In database-centric development, duplication is dangerous because, in shared, normalized...
DeepCamp AI