107 articles

📰 Dev.to · Franck Pachot

Articles from Dev.to · Franck Pachot · 107 articles · Updated every 3 hours · View all reads

All ⚡ AI Lessons (10383) ArXiv cs.AIDev.to · FORUM WEBDev.to AIForbes InnovationOpenAI NewsHugging Face Blog
Which Document class is best to use in Java to read MongoDB documents?
Dev.to · Franck Pachot 3mo ago
Which Document class is best to use in Java to read MongoDB documents?
TL;DR: the answer is in the title, use Document. BSON is a serialization format, similar to...
Read article → + Playlist
3 Steps to Optimize Your Queries for Speed
Dev.to · Franck Pachot 3mo ago
3 Steps to Optimize Your Queries for Speed
When performance matters, how you store your application objects, write queries, and design indexes...
Read article → + Playlist
UPDATE...RETURNING in MongoDB: ACID and idempotency with findOneAndUpdate()
Dev.to · Franck Pachot 3mo ago
UPDATE...RETURNING in MongoDB: ACID and idempotency with findOneAndUpdate()
You can implement atomic read-write operations in a single call instead of an explicit transaction,...
Read article → + Playlist
FOR UPDATE SKIP LOCKED in MongoDB
Dev.to · Franck Pachot 3mo ago
FOR UPDATE SKIP LOCKED in MongoDB
SELECT ... FOR UPDATE SKIP LOCKED is a vendor-specific SQL feature supported by several relational...
Read article → + Playlist
Why isn't "majority" the default read concern in MongoDB?
Dev.to · Franck Pachot 3mo ago
Why isn't "majority" the default read concern in MongoDB?
TL;DR: If you’re used to traditional SQL databases and synchronous request–response flows—where you...
Read article → + Playlist
MongoDB read and write concerns compared to PostgreSQL synchronous commit
Dev.to · Franck Pachot 3mo ago
MongoDB read and write concerns compared to PostgreSQL synchronous commit
If you are used to SQL databases, MongoDB’s consistency model can be confusing. Many traditional...
Read article → + Playlist
No Foreign Keys in MongoDB: Rethinking Referential Integrity
Dev.to · Franck Pachot 3mo ago
No Foreign Keys in MongoDB: Rethinking Referential Integrity
In SQL databases, foreign keys act as immediate constraints that verify the correctness of...
Read article → + Playlist
Adaptive Join in Amazon Aurora PostgreSQL
Dev.to · Franck Pachot 3mo ago
Adaptive Join in Amazon Aurora PostgreSQL
Slow joins in PostgreSQL often result from a nested loop join chosen by the query planner, which...
Read article → + Playlist
Unnesting Scalar Subqueries into Left Outer Joins in SQL in Aurora and PostgreSQL
Dev.to · Franck Pachot 3mo ago
Unnesting Scalar Subqueries into Left Outer Joins in SQL in Aurora and PostgreSQL
Relational databases treat your query as a declarative description of the desired result and select...
Read article → + Playlist
JSONB vs. BSON: Tracing PostgreSQL and MongoDB Wire Protocols
Dev.to · Franck Pachot 3mo ago
JSONB vs. BSON: Tracing PostgreSQL and MongoDB Wire Protocols
There is an essential difference between MongoDB’s BSON and PostgreSQL’s JSONB. Both are binary JSON...
Read article → + Playlist
Atlas Search scoring calculation and why Lucene scores differ from Elasticsearch and pg_(text)search
Dev.to · Franck Pachot 3mo ago
Atlas Search scoring calculation and why Lucene scores differ from Elasticsearch and pg_(text)search
With @james_blackwoodsewell_58 we were comparing the BM25 text search scores between MongoDB Atlas...
Read article → + Playlist
Using $sql in Oracle Database instead of explain("executionStats")
Dev.to · Franck Pachot 3mo ago
Using $sql in Oracle Database instead of explain("executionStats")
As application-driven data models and document databases—made popular by MongoDB—continue to gain...
Read article → + Playlist
Many-to-One: Stronger Relationship Design with MongoDB
Dev.to · Franck Pachot 3mo ago
Many-to-One: Stronger Relationship Design with MongoDB
In a relational database, a one-to-many relationship is typically implemented with two tables. The...
Read article → + Playlist
No, MongoDB Does Not Mean Skipping Design
Dev.to · Franck Pachot 4mo ago
No, MongoDB Does Not Mean Skipping Design
With MongoDB, domain-driven design empowers developers to build robust systems by aligning the data...
Read article → + Playlist
Script to list MongoDB collection URI (to map to WiredTiger files)
Dev.to · Franck Pachot 4mo ago
Script to list MongoDB collection URI (to map to WiredTiger files)
When tracing I/O to WiredTiger files, like with strace -y, the filenames do not give the collection...
Read article → + Playlist
MongoDB Index Intersection (and PostgreSQL Bitmap-and)
Dev.to · Franck Pachot 4mo ago
MongoDB Index Intersection (and PostgreSQL Bitmap-and)
You won’t always have a perfect index for every query, but may have have single-field indexes for...
Read article → + Playlist
What writeConcern: {w: 1} Really Means: Isolation and Durability
Dev.to · Franck Pachot 4mo ago
What writeConcern: {w: 1} Really Means: Isolation and Durability
In MongoDB, a write concern of w:1 indicates that a write operation is considered successful once the...
Read article → + Playlist
Data Locality vs. Independence (NoSQL vs. SQL)
Dev.to · Franck Pachot 4mo ago
Data Locality vs. Independence (NoSQL vs. SQL)
Understand how the principle of "store together what is accessed together" is a game-changer for...
Read article → + Playlist
INNER JOIN and LEFT OUTER JOIN in MongoDB (with $lookup and $unwind)
Dev.to · Franck Pachot 4mo ago
INNER JOIN and LEFT OUTER JOIN in MongoDB (with $lookup and $unwind)
We often explain $lookup as similar to a relational JOIN, but there’s a key difference in the...
Read article → + Playlist
Nested Loop and Hash Join for MongoDB $lookup
Dev.to · Franck Pachot 4mo ago
Nested Loop and Hash Join for MongoDB $lookup
SQL databases offer several join algorithms. The query planner selects the most efficient one by...
Read article → + Playlist
Amazon DocumentDB New Query Planner (version 2)
Dev.to · Franck Pachot 4mo ago
Amazon DocumentDB New Query Planner (version 2)
In September 2025, AWS announced it will contribute to the open-source DocumentDB extension for...
Read article → + Playlist
How does it scale? A basic OLTP benchmark on MongoDB
Dev.to · Franck Pachot 5mo ago
How does it scale? A basic OLTP benchmark on MongoDB
Choosing a database requires ensuring that performance remains fast as your data grows. For example,...
Read article → + Playlist
Covering Index for $group/$sum in MongoDB Aggregation (With Hint)
Dev.to · Franck Pachot 5mo ago
Covering Index for $group/$sum in MongoDB Aggregation (With Hint)
MongoDB indexes enable quick equality and range filtering (with $match) and ordering (with $sort)....
Read article → + Playlist
Advanced Query Capabilities 👉🏻 aggregation pipelines
Dev.to · Franck Pachot 5mo ago
Advanced Query Capabilities 👉🏻 aggregation pipelines
Although MongoDB has supported ACID transactions and sophisticated aggregation features for years,...
Read article → + Playlist