Franck Pachot
@franckpachot.bsky.social
https://dev.to/franckpachot
🥑 Developer Advocate at 🍃 MongoDB
🔸 AWS Data Hero
🅾️ Oracle Certified Master
🐘 PostgreSQL and▝▞ YugabyteDB
🥑 Developer Advocate at 🍃 MongoDB
🔸 AWS Data Hero
🅾️ Oracle Certified Master
🐘 PostgreSQL and▝▞ YugabyteDB
My first test of CloudNativePG: dev.to/franckpachot...
CloudNativePG - Install (2.18) and First Test: Transient Failure
I'm starting a series of blog posts to explore CloudNativePG (CNPG), a Kubernetes custom operator for...
dev.to
January 27, 2026 at 9:39 PM
My first test of CloudNativePG: dev.to/franckpachot...
Once won’t hurt — I did a silly benchmark with a clickbait headline 🤣:
#PostgreSQL is faster when replacing SQL tables with MongoDB collections dev.to/franckpachot...
#PostgreSQL is faster when replacing SQL tables with MongoDB collections dev.to/franckpachot...
PgBench on MongoDB via Foreign Data Wrapper
Disclaimer: This is an experiment, not a benchmark, and not an architectural recommendation....
dev.to
January 23, 2026 at 1:14 PM
Once won’t hurt — I did a silly benchmark with a clickbait headline 🤣:
#PostgreSQL is faster when replacing SQL tables with MongoDB collections dev.to/franckpachot...
#PostgreSQL is faster when replacing SQL tables with MongoDB collections dev.to/franckpachot...
When enterprises evaluate database alternatives, Oracle MAA is the reference for high availability, as it runs many banks and hospitals. Here’s how MongoDB achieves similar HA objectives: dev.to/franckpachot...
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
January 19, 2026 at 8:30 AM
When enterprises evaluate database alternatives, Oracle MAA is the reference for high availability, as it runs many banks and hospitals. Here’s how MongoDB achieves similar HA objectives: dev.to/franckpachot...
Reposted by Franck Pachot
The 50-year quest to replace developers
❌ 1970: COBOL
❌ 1980: CASE tools
❌ 1990: Visual Basic
❌ 2000: Low/No-Code
❓ 2020: #AI
Result? We need more skilled developers than ever.
Blocker isn't the code; it's the complexity. 🧑💻💡
By Stephan Schwab
www.caimito.net/en/blog/2025...
❌ 1970: COBOL
❌ 1980: CASE tools
❌ 1990: Visual Basic
❌ 2000: Low/No-Code
❓ 2020: #AI
Result? We need more skilled developers than ever.
Blocker isn't the code; it's the complexity. 🧑💻💡
By Stephan Schwab
www.caimito.net/en/blog/2025...
January 18, 2026 at 4:30 AM
The 50-year quest to replace developers
❌ 1970: COBOL
❌ 1980: CASE tools
❌ 1990: Visual Basic
❌ 2000: Low/No-Code
❓ 2020: #AI
Result? We need more skilled developers than ever.
Blocker isn't the code; it's the complexity. 🧑💻💡
By Stephan Schwab
www.caimito.net/en/blog/2025...
❌ 1970: COBOL
❌ 1980: CASE tools
❌ 1990: Visual Basic
❌ 2000: Low/No-Code
❓ 2020: #AI
Result? We need more skilled developers than ever.
Blocker isn't the code; it's the complexity. 🧑💻💡
By Stephan Schwab
www.caimito.net/en/blog/2025...
¿PostgreSQL o MongoDB? Más allá de los mitos
YouTube video by MongoDB
youtu.be
January 16, 2026 at 8:57 PM
💡MongoDB stores objects in BSON, but from the application, you access fields with a Document object created by the driver—don't use RawBsonDocument, which is just an array of bytes. All details in a new blog post:
dev.to/franckpachot...
dev.to/franckpachot...
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...
dev.to
January 12, 2026 at 7:51 AM
💡MongoDB stores objects in BSON, but from the application, you access fields with a Document object created by the driver—don't use RawBsonDocument, which is just an array of bytes. All details in a new blog post:
dev.to/franckpachot...
dev.to/franckpachot...
Reposted by Franck Pachot
MongoDB equivalent to FOR UPDATE SKIP LOCKED SELECT ... FOR UPDATE SKIP LOCKED is a vendor-specific SQL feature available in several relational databases (e.g., PostgreSQL, Oracle, MySQL). It helps...
#mongodb #postgres #database #lock
Origin | Interest | Match
#mongodb #postgres #database #lock
Origin | Interest | Match
MongoDB equivalent to FOR UPDATE SKIP LOCKED
SELECT ... FOR UPDATE SKIP LOCKED is a vendor-specific SQL feature available in several relational...
dev.to
January 2, 2026 at 12:16 AM
MongoDB's findOneAndUpdate() returns the document updated (before or after image). Bonus: MongoDB makes it idempotent, making it resilient to failures. A new blog post:
dev.to/franckpachot...
dev.to/franckpachot...
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,...
dev.to
January 7, 2026 at 5:51 PM
MongoDB's findOneAndUpdate() returns the document updated (before or after image). Bonus: MongoDB makes it idempotent, making it resilient to failures. A new blog post:
dev.to/franckpachot...
dev.to/franckpachot...
If you’ve read my last post on read and write concerns, you might wonder why MongoDB’s default read concern isn’t "majority, so I've written a new blog post:
dev.to/franckpachot...
dev.to/franckpachot...
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...
dev.to
January 7, 2026 at 8:06 AM
If you’ve read my last post on read and write concerns, you might wonder why MongoDB’s default read concern isn’t "majority, so I've written a new blog post:
dev.to/franckpachot...
dev.to/franckpachot...
Once you understand your access patterns, you can tune your MongoDB data model, indexes, and queries.
dev.to/franckpachot...
dev.to/franckpachot...
3 Steps to Optimize Your Queries for Speed
When performance matters, how you store your application objects, write queries, and design indexes...
dev.to
January 5, 2026 at 10:12 PM
Once you understand your access patterns, you can tune your MongoDB data model, indexes, and queries.
dev.to/franckpachot...
dev.to/franckpachot...
Comparing #MongoDB Read/Write Concerns and #PostgreSQL Synchronous Commit Replication in terms of performance, durability, visibility, and isolation:
dev.to/franckpachot...
dev.to/franckpachot...
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...
dev.to
January 5, 2026 at 10:57 AM
Comparing #MongoDB Read/Write Concerns and #PostgreSQL Synchronous Commit Replication in terms of performance, durability, visibility, and isolation:
dev.to/franckpachot...
dev.to/franckpachot...
Sequence diagrams are overlooked. Here's an example of a replication sequence with w:majority in a #MongoDB PSS deployment. The horizontal axis (actors) shows the performance–durability trade-off, and the vertical axis (timeline) shows the visibility–isolation trade-off:
January 2, 2026 at 12:00 PM
Sequence diagrams are overlooked. Here's an example of a replication sequence with w:majority in a #MongoDB PSS deployment. The horizontal axis (actors) shows the performance–durability trade-off, and the vertical axis (timeline) shows the visibility–isolation trade-off:
First blog post of the year - a multi-thread pick-process-update. Avoid calling external APIs within one transaction. Manage the state in the document with short updates: dev.to/franckpachot...
MongoDB equivalent to FOR UPDATE SKIP LOCKED
SELECT ... FOR UPDATE SKIP LOCKED is a vendor-specific SQL feature available in several relational...
dev.to
January 2, 2026 at 12:10 AM
First blog post of the year - a multi-thread pick-process-update. Avoid calling external APIs within one transaction. Manage the state in the document with short updates: dev.to/franckpachot...
Reposted by Franck Pachot
MongoDB Read/Write vs. PostgreSQL Synchronous Replication dev.to/franckpachot...
MongoDB Read/Write vs. PostgreSQL Synchronous Replication
If you are used to SQL databases, MongoDB’s consistency model can be confusing. Typical SQL systems...
dev.to
December 28, 2025 at 10:20 PM
MongoDB Read/Write vs. PostgreSQL Synchronous Replication dev.to/franckpachot...
There are no Foreign Keys in MongoDB because strong one-to-many relationships are embedded, and data integrity is handled in the application via business logic. You can also validate database integrity using the aggregation pipeline and the change stream: dev.to/franckpachot...
No Foreign Keys in MongoDB: Rethinking Referential Integrity
In SQL databases, foreign keys act as immediate constraints that verify the correctness of...
dev.to
December 26, 2025 at 9:23 PM
There are no Foreign Keys in MongoDB because strong one-to-many relationships are embedded, and data integrity is handled in the application via business logic. You can also validate database integrity using the aggregation pipeline and the change stream: dev.to/franckpachot...
A new blog post about an @awscloud.bsky.social Amazon Aurora PostgreSQL feature that exists in many commercial databases but not in PostgreSQL: adaptive join methods dev.to/aws-heroes/a...
Adaptive Join in Amazon Aurora PostgreSQL
Slow joins in PostgreSQL often result from a nested loop join chosen by the query planner, which...
dev.to
December 24, 2025 at 9:37 AM
A new blog post about an @awscloud.bsky.social Amazon Aurora PostgreSQL feature that exists in many commercial databases but not in PostgreSQL: adaptive join methods dev.to/aws-heroes/a...
New blog post: examining an Amazon Aurora query planner transformation and manual methods, with notes on COUNT versus other aggregations.
dev.to/aws-heroes/u...
dev.to/aws-heroes/u...
Unnesting Scalar Subqueries into Left Outer Joins in SQL
Relational databases treat your query as a declarative description of the desired result and select...
dev.to
December 23, 2025 at 3:49 PM
New blog post: examining an Amazon Aurora query planner transformation and manual methods, with notes on COUNT versus other aggregations.
dev.to/aws-heroes/u...
dev.to/aws-heroes/u...
@MongoDB drivers do more on the application side than SQL drivers, which mainly send commands as text strings and return simple tabular results.
🍃 BSON is a storage + exchange format that maps documents to app objects. I traced it for a new blog post: dev.to/franckpachot...
🍃 BSON is a storage + exchange format that maps documents to app objects. I traced it for a new blog post: dev.to/franckpachot...
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...
dev.to
December 21, 2025 at 8:49 PM
@MongoDB drivers do more on the application side than SQL drivers, which mainly send commands as text strings and return simple tabular results.
🍃 BSON is a storage + exchange format that maps documents to app objects. I traced it for a new blog post: dev.to/franckpachot...
🍃 BSON is a storage + exchange format that maps documents to app objects. I traced it for a new blog post: dev.to/franckpachot...
The MongoDB text search (in both the Atlas and community editions) uses Lucene indexes. You can check the scoring formulas and parameters with scoreDetails:true dev.to/franckpachot...
Atlas Search score details (the BM25 calculation)
With @james_blackwoodsewell_58 we were comparing the BM25 text search scores between MongoDB Atlas...
dev.to
December 19, 2025 at 10:23 PM
The MongoDB text search (in both the Atlas and community editions) uses Lucene indexes. You can check the scoring formulas and parameters with scoreDetails:true dev.to/franckpachot...
🍃 MongoDB transactions are fully ACID, with guarantees across shards and replicas—which is stronger than many SQL databases. Still, myths have a consistent durability 🤷🏼♂️
www.linkedin.com/posts/franck...
www.linkedin.com/posts/franck...
🍃 MongoDB transactions are fully ACID, with guarantees across shards and replicas—which is stronger than many SQL databases. Still, myths have a consistent durability 🤷🏼♂️. Many RDBMS users… | Franck...
🍃 MongoDB transactions are fully ACID, with guarantees across shards and replicas—which is stronger than many SQL databases. Still, myths have a consistent durability 🤷🏼♂️. Many RDBMS users assume AC...
www.linkedin.com
December 18, 2025 at 8:45 AM
🍃 MongoDB transactions are fully ACID, with guarantees across shards and replicas—which is stronger than many SQL databases. Still, myths have a consistent durability 🤷🏼♂️
www.linkedin.com/posts/franck...
www.linkedin.com/posts/franck...
If you know your application access patterns and cardinalities, you can build a stronger data model with #MongoDB. I explore One-to-Many schemas, queries, and execution plans in a new blog post:
dev.to/franckpachot...
dev.to/franckpachot...
Many-to-One: Stronger Relationship Design with MongoDB
In a relational database, a one-to-many relationship is typically implemented with two tables. The...
dev.to
December 16, 2025 at 12:12 AM
If you know your application access patterns and cardinalities, you can build a stronger data model with #MongoDB. I explore One-to-Many schemas, queries, and execution plans in a new blog post:
dev.to/franckpachot...
dev.to/franckpachot...
Reposted by Franck Pachot
Understand how the principle of "store together what is accessed together" is a game-changer for database performance and scalability.
By @franckpachot.bsky.social, thanks to @mongodb.bsky.social
By @franckpachot.bsky.social, thanks to @mongodb.bsky.social
Why 'Store Together, Access Together' Matters for Your Database
Understand how the principle of "store together what is accessed together" is a game-changer for database performance and scalability.
bit.ly
December 4, 2025 at 2:30 PM
Understand how the principle of "store together what is accessed together" is a game-changer for database performance and scalability.
By @franckpachot.bsky.social, thanks to @mongodb.bsky.social
By @franckpachot.bsky.social, thanks to @mongodb.bsky.social
Heard of MongoDB index intersection but never seen it? My new blog post explains why.
dev.to/franckpachot...
dev.to/franckpachot...
MongoDB Index Intersection (and PostgreSQL Bitmap Scan)
You won’t always have a perfect index for every query, but may have have single-field indexes for...
dev.to
November 27, 2025 at 6:22 PM
Heard of MongoDB index intersection but never seen it? My new blog post explains why.
dev.to/franckpachot...
dev.to/franckpachot...
All replicated databases can trade some ACID guarantees for better performance. While not the default, if you perform {w:1} writes on MongoDB, you should be aware of the implications, including local reads and failure scenarios (resilience and failover): dev.to/franckpachot...
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...
dev.to
November 24, 2025 at 2:20 PM
All replicated databases can trade some ACID guarantees for better performance. While not the default, if you perform {w:1} writes on MongoDB, you should be aware of the implications, including local reads and failure scenarios (resilience and failover): dev.to/franckpachot...