MongoDB is the leading database for document data modeling, with its Atlas service available on AWS,... Tagged with mongodb, postgres, documentdb, cloud.

Franck Pachot

28.08.2025

PostgreSQL JSONB Size Limits to Prevent TOAST Slicing - DEV Community

In my previous post Embedding Into JSONB Still Feels Like a JOIN for Large Documents, I examined the... Tagged with postgres, toast, document, jsonb.

Franck Pachot

27.08.2025

Embedding Into JSONB Still Feels Like a JOIN for Large Documents - DEV Community

Think PostgreSQL with JSONB can replace a document database? It’s a tempting idea: Embed your related... Tagged with postgres, mongodb, json, database.

Franck Pachot

25.08.2025

Does PostgreSQL support as much "schema flexibility" as MongoDB? Not for indexing! - DEV Community

Another day, another myth. Someone on Medium claims PostgreSQL offers as much "schema flexibility" as... Tagged with postgres, json, jsonb, mongodb.

Franck Pachot

25.08.2025

Embedding into JSONB still feels like a JOIN for large documents - DEV Community

Think PostgreSQL with JSONB can replace a document database? It’s a tempting idea: embed your related... Tagged with postgres, mongodb, json, database.

Franck Pachot

25.08.2025

Why Doesn't Oracle Multi-Value Index Optimize .sort() Like MongoDB Does With its Multi-Key Index? - DEV Community

Until recently, Oracle Database offered very limited options for creating inverted indexes, primarily... Tagged with mongodb, oracle, index, json.

Franck Pachot

25.08.2025

MongoDB Arrays: Sort Order and Comparison - DEV Community

Arrays in MongoDB are ordered lists of values, and querying them can be confusing because a field... Tagged with mongodb, document, database, array.

Franck Pachot

12.08.2025

MongoDB indexing internals: .showRecordId() and .hint({$natural:1}) - DEV Community

You can understand how MongoDB stores documents internally with simple queries that rely on the... Tagged with mongodb, database, storage, clustered.

Franck Pachot

12.08.2025

PostgreSQL UUID: Bulk insert with UUIDv7 vs UUIDv4 - DEV Community

PostgreSQL 18 (currently in beta) introduces a UUID version 7 generation function that features a... Tagged with postgres, uuid, sql, database.

Franck Pachot

12.08.2025

Joining and grouping on array fields in MongoDB may require using $unwind before applying $group or $lookup - DEV Community

Working with nested data in MongoDB simplifies mapping between application objects and database... Tagged with mongodb, document, database, postgres.

Franck Pachot

09.08.2025

Joining and grouping on array fields in MongoDB may require using $unwind before applying $group or $lookup - DEV Community

Working with nested data in MongoDB simplifies mapping between application objects and database... Tagged with mongodb, document, database, postgres.

Franck Pachot

08.08.2025

MongoDB indexing internals: .showRecordId() and .hint({$natural:1}) - DEV Community

You can understand how MongoDB stores documents internally with simple queries that rely on the... Tagged with mongodb, database, storage, clustered.

Franck Pachot

08.08.2025

MongoDB High Availability: Replica Set in a Docker Lab - DEV Community

MongoDB guarantees consistent and durable write operations through write-ahead logging, which... Tagged with mongodb, database, docker, devops.

Franck Pachot

08.08.2025

Why MongoDB skips indexes when flattening or renaming sub-document fields in $project before $match aggregation pipeline - DEV Community

MongoDB is a general-purpose database that offers more than just a JSON datastore. It is recognized... Tagged with mongodb, document, database, index.

Franck Pachot

08.08.2025

Transaction performance 👉🏻 retry with backoff - DEV Community

A benchmark sponsored by EDB, a PostgreSQL company, in 2019 contributed to the myth that MongoDB... Tagged with mongodb, transaction, benchmark, performance.

Franck Pachot

03.08.2025

MongoDB High Availability: Replica Set in a Docker Lab - DEV Community

MongoDB guarantees consistent and durable write operations through write-ahead logging, which... Tagged with mongodb, database, docker, devops.

Franck Pachot

30.07.2025

Lock-Free Wait-on-Conflict and Fail-on-Conflict in MongoDB - DEV Community

Concurrency control in databases has two main modes for handling conflicts. Traditionally, these are... Tagged with mongodb, database, transaction, consistency.

Franck Pachot

30.07.2025

.hint() in MongoDB is different that SQL optimizer hints: they force indexes - DEV Community

MongoDB sits at the crossroads between SQL, where developers can write queries on a logical model... Tagged with mongodb, document, database, index.

Franck Pachot

29.07.2025

Database latency with PostgreSQL and MongoDB: it's the data model that makes it fast - DEV Community

A business transaction ideally involves a single roundtrip to the database. MongoDB allows a single... Tagged with mongodb, database, postgres, edge.

Franck Pachot

29.07.2025

Wildcard Indexes: MongoDB flexibility joins query performance - DEV Community

In SQL databases, we sometimes encounter an Entity-Attribute-Value (EAV) model to work around the... Tagged with mongodb, document, database, index.

Franck Pachot

29.07.2025

$isArray: [💬,💬,💬] ❌ - Arrays are Argument Lists in MongoDB Aggregation Pipeline - DEV Community

If you test $isArray: [42] in MongoDB, it returns false and that's the right answer. If you test...

Franck Pachot

29.07.2025

ALTER TABLE ... ADD COLUMN - DEV Community

MongoDB’s flexible schema allows each document within a collection to have a unique structure, a... Tagged with postgres, mongodb, database, performance.

Franck Pachot

29.07.2025

Lock-Free Wait-on-Conflict and Fail-on-Conflict in MongoDB - DEV Community

Concurrency control in databases has two main modes for handling conflicts. Traditionally, these are... Tagged with mongodb, database, transaction, consistency.

Franck Pachot

29.07.2025

.hint() in MongoDB is different that SQL optimizer hints: they force indexes - DEV Community

MongoDB sits at the crossroads between SQL, where developers can write queries on a logical model... Tagged with mongodb, document, database, index.

Franck Pachot

29.07.2025

Sequences in MongoDB - DEV Community

In a previous post about No-gap sequence in PostgreSQL and YugabyteDB, I mentioned that sequences in... Tagged with mongodb, database, sequence, sql.

Franck Pachot

11.07.2025

Wildcard Indexes: MongoDB flexibility joins query performance - DEV Community

In SQL databases, we sometimes encounter an Entity-Attribute-Value (EAV) model to work around the... Tagged with mongodb, document, database, index.

Franck Pachot

09.07.2025

ALTER TABLE ... ADD COLUMN - DEV Community

MongoDB’s flexible schema allows each document within a collection to have a unique structure, a... Tagged with postgres, mongodb, database, performance.

Franck Pachot

04.07.2025

Erik (author of Lucene in Action) is starting a series on search indexes - DEV Community

Introducing "Playing with Search" Series Erik Hatcher ・... Tagged with mongodb, atlas, search, regex.

Franck Pachot

01.07.2025

No pre-filtering in pgvector means reduced ANN recall - DEV Community

AI applications are expanding rapidly, and PostgreSQL is a popular choice among relational databases.... Tagged with postgres, vector, database, mongodb.

Franck Pachot

01.07.2025

faster $lookup after $group in MongoDB aggregation pipeline - DEV Community

In the previous post One million $lookup challenge I said that $lookup is efficient at the end of an... Tagged with mongodb, lookup, join, performance.

Franck Pachot

01.07.2025

Flush to disk on commit 👉🏻 MongoDB durable writes - DEV Community

A Twitter (𝕏) thread was filled with misconceptions about MongoDB, spreading fear, uncertainty, and... Tagged with mongodb, document, database, acid.

Franck Pachot

01.07.2025

$lookup: more than just a SQL join - DEV Community

When transitioning from a SQL background to MongoDB, the $lookup operation in an aggregation pipeline... Tagged with mongodb, document, database, sql.

Franck Pachot

01.07.2025

One million $lookup challenge - DEV Community

I you have read my previous post $lookup: more than just a SQL join, you understand that $lookup is... Tagged with mongodb, document, database, join.

Franck Pachot

01.07.2025

Strong consistency 👉🏻 MongoDB highly available durable writes - DEV Community

In the previous post, I used strace to display all calls to write and sync to disk from any MongoDB... Tagged with mongodb, acid, consistency, database.

Franck Pachot

29.06.2025

Flush to disk on commit 👉🏻 MongoDB durable writes - DEV Community

A Twitter (𝕏) thread was filled with misconceptions about MongoDB, spreading fear, uncertainty, and... Tagged with mongodb, document, database, acid.

Franck Pachot

25.06.2025

No pre-filtering in pgvector means reduced ANN recall - DEV Community

AI applications are expanding rapidly, and PostgreSQL is a popular choice among relational databases.... Tagged with postgres, vector, database, mongodb.

Franck Pachot

23.06.2025

faster $lookup after $group in MongoDB aggregation pipeline - DEV Community

In the previous post One million $lookup challenge I said that $lookup is efficient at the end of an... Tagged with mongodb, lookup, join, performance.

Franck Pachot

20.06.2025

One million $lookup challenge - DEV Community

I you have read my previous post $lookup: more than just a SQL join, you understand that $lookup is... Tagged with mongodb, document, database, join.

home›Franck Pachot›Software

Franck Pachot - Software

Resilience of MongoDB's WiredTiger Storage Engine to Disk Failure Compared to PostgreSQL and Oracle - DEV Community

Updates to the Same Value: MongoDB Optimization - DEV Community

DocumentDB: Comparing Emulation Internals with MongoDB - DEV Community

PostgreSQL JSONB Size Limits to Prevent TOAST Slicing - DEV Community

Embedding Into JSONB Still Feels Like a JOIN for Large Documents - DEV Community

Does PostgreSQL support as much "schema flexibility" as MongoDB? Not for indexing! - DEV Community

Embedding into JSONB still feels like a JOIN for large documents - DEV Community

Why Doesn't Oracle Multi-Value Index Optimize .sort() Like MongoDB Does With its Multi-Key Index? - DEV Community

MongoDB Arrays: Sort Order and Comparison - DEV Community

MongoDB indexing internals: .showRecordId() and .hint({$natural:1}) - DEV Community

PostgreSQL UUID: Bulk insert with UUIDv7 vs UUIDv4 - DEV Community

Joining and grouping on array fields in MongoDB may require using $unwind before applying $group or $lookup - DEV Community

Joining and grouping on array fields in MongoDB may require using $unwind before applying $group or $lookup - DEV Community

MongoDB indexing internals: .showRecordId() and .hint({$natural:1}) - DEV Community

MongoDB High Availability: Replica Set in a Docker Lab - DEV Community

Why MongoDB skips indexes when flattening or renaming sub-document fields in $project before $match aggregation pipeline - DEV Community

Transaction performance 👉🏻 retry with backoff - DEV Community

MongoDB High Availability: Replica Set in a Docker Lab - DEV Community

Lock-Free Wait-on-Conflict and Fail-on-Conflict in MongoDB - DEV Community

.hint() in MongoDB is different that SQL optimizer hints: they force indexes - DEV Community

Database latency with PostgreSQL and MongoDB: it's the data model that makes it fast - DEV Community

Wildcard Indexes: MongoDB flexibility joins query performance - DEV Community

$isArray: [💬,💬,💬] ❌ - Arrays are Argument Lists in MongoDB Aggregation Pipeline - DEV Community

ALTER TABLE ... ADD COLUMN - DEV Community

Lock-Free Wait-on-Conflict and Fail-on-Conflict in MongoDB - DEV Community

.hint() in MongoDB is different that SQL optimizer hints: they force indexes - DEV Community

Sequences in MongoDB - DEV Community

Wildcard Indexes: MongoDB flexibility joins query performance - DEV Community

ALTER TABLE ... ADD COLUMN - DEV Community

Erik (author of Lucene in Action) is starting a series on search indexes - DEV Community

No pre-filtering in pgvector means reduced ANN recall - DEV Community

faster $lookup after $group in MongoDB aggregation pipeline - DEV Community

Flush to disk on commit 👉🏻 MongoDB durable writes - DEV Community

$lookup: more than just a SQL join - DEV Community

One million $lookup challenge - DEV Community

Strong consistency 👉🏻 MongoDB highly available durable writes - DEV Community

Flush to disk on commit 👉🏻 MongoDB durable writes - DEV Community

No pre-filtering in pgvector means reduced ANN recall - DEV Community

faster $lookup after $group in MongoDB aggregation pipeline - DEV Community

One million $lookup challenge - DEV Community

home
›
Franck Pachot
›
Software