DEV Community

Franck Pachot profile picture

Franck Pachot

🥑 Developer Advocate at 🍃 MongoDB, 🔶 AWS Data Hero, 🐘 PostgreSQL fan,▝▞ YugabyteDB expert, 🅾️ Oracle Certified Master, and 💚 loving all databases 🛢️

Education

Master MIAGE, Université Paris-Sud, France

Work

Developer Advocate at MongoDB

4 Week Community Wellness Streak
Top 7
Six Year Club
Writing Debut
2 Week Community Wellness Streak
Five Year Club
Four Year Club
1 Week Community Wellness Streak
16 Week Writing Streak
Three Year Club
8 Week Writing Streak
4 Week Writing Streak
DocumentDB: Comparing Emulation Internals with MongoDB

DocumentDB: Comparing Emulation Internals with MongoDB

5
Comments
18 min read

Want to connect with Franck Pachot?

Create an account to connect with Franck Pachot. You can also sign in below to proceed if you already have an account.

Already have an account? Sign in
Updates to the Same Value: MongoDB Optimization

Updates to the Same Value: MongoDB Optimization

2
Comments 1
7 min read
PostgreSQL JSONB Size Limits to Prevent TOAST Slicing

PostgreSQL JSONB Size Limits to Prevent TOAST Slicing

4
Comments
6 min read
Embedding Into JSONB Still Feels Like a JOIN for Large Documents

Embedding Into JSONB Still Feels Like a JOIN for Large Documents

4
Comments
21 min read
MongoDB Arrays: Sort Order and Comparison

MongoDB Arrays: Sort Order and Comparison

2
Comments
16 min read
Why Doesn't Oracle Multi-Value Index Optimize .sort() Like MongoDB Does With its Multi-Key Index?

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

Comments
15 min read
Does PostgreSQL support as much "schema flexibility" as MongoDB? Not for indexing!

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

2
Comments
8 min read
PostgreSQL UUID: Bulk insert with UUIDv7 vs UUIDv4

PostgreSQL UUID: Bulk insert with UUIDv7 vs UUIDv4

3
Comments 1
10 min read
Joining and grouping on array fields in MongoDB may require using $unwind before applying $group or $lookup

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

Comments
5 min read
Transaction performance 👉🏻 retry with backoff

Transaction performance 👉🏻 retry with backoff

1
Comments
7 min read
Why MongoDB skips indexes when flattening or renaming sub-document fields in $project before $match aggregation pipeline

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

Comments
6 min read
MongoDB High Availability: Replica Set in a Docker Lab

MongoDB High Availability: Replica Set in a Docker Lab

Comments
12 min read
Lock-Free Wait-on-Conflict and Fail-on-Conflict in MongoDB

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

2
Comments
9 min read
.hint() in MongoDB is different that SQL optimizer hints: they force indexes

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

1
Comments
8 min read
Database latency with PostgreSQL and MongoDB: it's the data model that makes it fast

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

2
Comments
14 min read
$isArray: [💬,💬,💬] ❌ - Arrays are Argument Lists in MongoDB Aggregation Pipeline

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

1
Comments
4 min read
Sequences in MongoDB

Sequences in MongoDB

Comments
4 min read
Wildcard Indexes: MongoDB flexibility joins query performance

Wildcard Indexes: MongoDB flexibility joins query performance

Comments
5 min read
ALTER TABLE ... ADD COLUMN

ALTER TABLE ... ADD COLUMN

5
Comments
12 min read
Strong consistency 👉🏻 MongoDB highly available durable writes (Replication)

Strong consistency 👉🏻 MongoDB highly available durable writes (Replication)

5
Comments
11 min read
Flush to disk on commit 👉🏻 MongoDB durable writes (ACID)

Flush to disk on commit 👉🏻 MongoDB durable writes (ACID)

9
Comments 4
9 min read
No pre-filtering in pgvector means reduced ANN recall ( impact on Vector Search accuracy)

No pre-filtering in pgvector means reduced ANN recall ( impact on Vector Search accuracy)

Comments
12 min read
faster $lookup after $group in MongoDB aggregation pipeline (Performance Optimization Tips)

faster $lookup after $group in MongoDB aggregation pipeline (Performance Optimization Tips)

1
Comments
2 min read
One million $lookup challenge (performance comparison)

One million $lookup challenge (performance comparison)

6
Comments
6 min read
$lookup: more than just a SQL join (understand performance)

$lookup: more than just a SQL join (understand performance)

8
Comments 1
5 min read
Queries on JSON 👉🏻 compound indexes (Equality, Sort, Range) in MongoDB

Queries on JSON 👉🏻 compound indexes (Equality, Sort, Range) in MongoDB

1
Comments
8 min read
DuckDB to query MongoDB

DuckDB to query MongoDB

1
Comments
11 min read
Comparison of JOINS 👉🏻 aggregation pipeline and CTEs

Comparison of JOINS 👉🏻 aggregation pipeline and CTEs

Comments
7 min read
"Schema Later" considered harmful 👉🏻 schema validation (enforced data consistency)

"Schema Later" considered harmful 👉🏻 schema validation (enforced data consistency)

1
Comments 2
3 min read
JSONB DeTOASTing (read amplification) when using PostgreSQL as a Document Database

JSONB DeTOASTing (read amplification) when using PostgreSQL as a Document Database

7
Comments 1
5 min read
No HOT updates on JSONB (write amplification) performance impact

No HOT updates on JSONB (write amplification) performance impact

8
Comments 2
7 min read
$graphLookup (Connect By / Recursive Query)

$graphLookup (Connect By / Recursive Query)

4
Comments
2 min read
$elemMatch and Multi-Key Indexes

$elemMatch and Multi-Key Indexes

8
Comments 1
4 min read
Google Firestore with MongoDB compatibility - index limitations

Google Firestore with MongoDB compatibility - index limitations

4
Comments
6 min read
Sort on Array with Multi-Key Index

Sort on Array with Multi-Key Index

1
Comments
5 min read
Equality with Multiple Values, Preserving Sort for Pagination

Equality with Multiple Values, Preserving Sort for Pagination

1
Comments
5 min read
No Index for LIKE on JSONB with Array in the Path (GIN limitation)

No Index for LIKE on JSONB with Array in the Path (GIN limitation)

3
Comments
5 min read
B-Tree for Equality, Sort, Range (indexing strategies in MongoDB)

B-Tree for Equality, Sort, Range (indexing strategies in MongoDB)

11
Comments 2
3 min read
No Index Only Scan on JSONB Fields (even on scalar)

No Index Only Scan on JSONB Fields (even on scalar)

12
Comments 1
4 min read
Search Index for Reporting

Search Index for Reporting

5
Comments
2 min read
Sampling Without Index

Sampling Without Index

5
Comments
2 min read
Indexing for New Use Cases Within the MongoDB Document Model (tutorial)

Indexing for New Use Cases Within the MongoDB Document Model (tutorial)

9
Comments
3 min read
HTAP Using a Star Query on MongoDB Atlas Search Index

HTAP Using a Star Query on MongoDB Atlas Search Index

1
Comments
14 min read
Amazon DocumentDB and multi-key indexing

Amazon DocumentDB and multi-key indexing

2
Comments
8 min read
Amazon DocumentDB != Microsoft DocumentDB extension for PostgreSQL

Amazon DocumentDB != Microsoft DocumentDB extension for PostgreSQL

2
Comments
3 min read
Microsoft CosmosDB: RUM instead of GIN but same limitations on JSON paths

Microsoft CosmosDB: RUM instead of GIN but same limitations on JSON paths

Comments
15 min read
Querying embedded arrays in JSON (PostgreSQL JSONB and MongoDB documents)

Querying embedded arrays in JSON (PostgreSQL JSONB and MongoDB documents)

2
Comments
5 min read
PostgreSQL aborts the transactions on error

PostgreSQL aborts the transactions on error

1
Comments
3 min read
Index Only Scan on JSON Documents in MongoDB, with covering and multi-key indexes

Index Only Scan on JSON Documents in MongoDB, with covering and multi-key indexes

7
Comments
10 min read
PostgreSQL JSONB Indexing Limitations with B-Tree and GIN

PostgreSQL JSONB Indexing Limitations with B-Tree and GIN

17
Comments 2
8 min read
Oracle Multi-Value Index and ORDER BY Pagination queries

Oracle Multi-Value Index and ORDER BY Pagination queries

1
Comments
7 min read
Where SQL joins struggle but MongoDB documents shine

Where SQL joins struggle but MongoDB documents shine

5
Comments 7
9 min read
Foreign Keys: A must in SQL, but not in a Document Database?

Foreign Keys: A must in SQL, but not in a Document Database?

20
Comments
7 min read
The World Is Too Messy for SQL to Work

The World Is Too Messy for SQL to Work

21
Comments 15
10 min read
MongoDB Vector Search Index, With Local Atlas and Ollama

MongoDB Vector Search Index, With Local Atlas and Ollama

6
Comments
4 min read
MongoDB TTL and Disk Storage

MongoDB TTL and Disk Storage

9
Comments 4
4 min read
MongoDB equivalent for PostgreSQL JSONB operations

MongoDB equivalent for PostgreSQL JSONB operations

5
Comments
12 min read
Normalization and Relational Division in SQL and MongoDB

Normalization and Relational Division in SQL and MongoDB

4
Comments
7 min read
MongoDB Multi-Planner Optimizer and Plan Cache

MongoDB Multi-Planner Optimizer and Plan Cache

12
Comments
13 min read
Comparing Execution Plans: MongoDB vs. Compatible APIs

Comparing Execution Plans: MongoDB vs. Compatible APIs

10
Comments
6 min read
loading...