Franck Pachot

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

Lausanne, Switzerland Joined on Nov 12, 2018 https://www.linkedin.com/in/franckpachot

Education

Master MIAGE, Université Paris-Sud, France

Work

Developer Advocate at MongoDB

Pinned

Franck Pachot for MongoDB

Aug 7

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

#mongodb #database #storage #clustered

13 min read

Franck Pachot for MongoDB

Jun 6

Isolation Level for MongoDB Multi-Document Transactions (Strong Consistency)

#mongodb #document #database #acid

11 min read

Franck Pachot for MongoDB

May 23

Intro to PostgreSQL with JSONB compared to MongoDB, a general purpose document database

#postgres #mongodb #json #document

2 min read

Franck Pachot for MongoDB

Apr 13

MongoDB With Search Indexes Queried as Kimball's Star Schema With Facts and Dimensions

#mongodb #search #index #analytics

10 min read

Franck Pachot

Sep 19

Text Search with MongoDB (BM25 TF-IDF) and PostgreSQL

#database #mongodb #postgres #elasticsearch

9 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.

Create Account

Already have an account? Sign in

Franck Pachot

Sep 18

Combine Two JSON Collections with Nested Arrays: MongoDB and PostgreSQL Aggregations

#mongodb #postgres #sql #json

8 min read

Franck Pachot

Sep 16

MongoDB Multikey Indexes and Index Bound Optimization

#database #mongodb #performance

8 min read

Franck Pachot

Sep 14

MongoDB Internals: How Collections and Indexes Are Stored in WiredTiger

#mongodb #database #wiredtiger #internals

20 min read

Franck Pachot for MongoDB

Sep 8

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

#mongodb #wiredtiger #postgres #oracle

12 min read

Franck Pachot for AWS Heroes

Sep 1

DocumentDB: Comparing Emulation Internals with MongoDB

#mongodb #postgres #documentdb #cloud

18 min read

Franck Pachot for MongoDB

Aug 28

Updates to the Same Value: MongoDB Optimization

#mongodb #postgres #database #sql

7 min read

Franck Pachot

Aug 27

PostgreSQL JSONB Size Limits to Prevent TOAST Slicing

#postgres #toast #document #jsonb

6 min read

Franck Pachot for MongoDB

Aug 24

Embedding Into JSONB Still Feels Like a JOIN for Large Documents

#postgres #mongodb #json #database

21 min read

Franck Pachot for MongoDB

Aug 18

MongoDB Arrays: Sort Order and Comparison

#mongodb #document #database #array

16 min read

Franck Pachot for MongoDB

Aug 15

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

#mongodb #oracle #index #json

15 min read

Franck Pachot for MongoDB

Aug 12

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

#postgres #json #jsonb #mongodb

8 min read

Franck Pachot for AWS Heroes

Aug 11

PostgreSQL UUID: Bulk insert with UUIDv7 vs UUIDv4

#postgres #uuid #sql #database

10 min read

Franck Pachot for MongoDB

Aug 8

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

#mongodb #document #database #postgres

5 min read

Franck Pachot for MongoDB

Aug 5

Transaction performance 👉🏻 retry with backoff

#mongodb #transaction #benchmark #performance

7 min read

Franck Pachot for MongoDB

Aug 4

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

#mongodb #document #database #index

6 min read

Franck Pachot for MongoDB

Aug 2

MongoDB High Availability: Replica Set in a Docker Lab

#mongodb #database #docker #devops

12 min read

Franck Pachot for MongoDB

Jul 23

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

#mongodb #database #transaction #consistency

9 min read

Franck Pachot for MongoDB

Jul 22

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

#mongodb #document #database #index

8 min read

Franck Pachot for MongoDB

Jul 21

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

#mongodb #database #postgres #edge

14 min read

Franck Pachot for MongoDB

Jul 20

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

4 min read

Franck Pachot for MongoDB

Jul 18

Sequences in MongoDB

#mongodb #database #sequence #sql

4 min read

Franck Pachot for MongoDB

Jul 10

Wildcard Indexes: MongoDB flexibility joins query performance

#mongodb #document #database #index

5 min read

Franck Pachot for MongoDB

Jul 8

ALTER TABLE ... ADD COLUMN

#postgres #mongodb #database #performance

12 min read

Franck Pachot for MongoDB

Jun 30

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

#mongodb #acid #consistency #database

11 min read

Franck Pachot for MongoDB

Jun 28

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

#mongodb #document #database #acid

9 min read

Franck Pachot for MongoDB

Jun 24

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

#postgres #vector #database #mongodb

12 min read

Franck Pachot for MongoDB

Jun 22

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

#mongodb #lookup #join #performance

2 min read

Franck Pachot for MongoDB

Jun 19

One million $lookup challenge (performance comparison)

#mongodb #document #database #join

6 min read

Franck Pachot for MongoDB

Jun 17

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

#mongodb #document #database #sql

5 min read

Franck Pachot for MongoDB

Jun 15

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

#mongodb #document #postgres #json

8 min read

Franck Pachot for MongoDB

Jun 13

DuckDB to query MongoDB

#postgres #mongodb #duckdb #analytics

11 min read

Franck Pachot for MongoDB

Jun 9

Comparison of JOINS 👉🏻 aggregation pipeline and CTEs

#mongodb #lookup #join #aggregation

7 min read

Franck Pachot for MongoDB

Jun 9

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

#mongodb #document #database #postgres

3 min read

Franck Pachot for MongoDB

Jun 4

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

#postgres #jsonb #document #database

5 min read

Franck Pachot for MongoDB

May 31

No HOT updates on JSONB (write amplification) performance impact

#postgres #document #database #mongodb

7 min read

Franck Pachot for MongoDB

May 29

$graphLookup (Connect By / Recursive Query)

#mongodb #document #database #index

2 min read

Franck Pachot for MongoDB

May 28

$elemMatch and Multi-Key Indexes

#mongodb #document #database #index

4 min read

Franck Pachot

May 27

Google Firestore with MongoDB compatibility - index limitations

#mongodb #database #index #firestore

6 min read

Franck Pachot for MongoDB

May 27

Sort on Array with Multi-Key Index

#mongodb #document #database #index

5 min read

Franck Pachot for MongoDB

May 26

Equality with Multiple Values, Preserving Sort for Pagination

#mongodb #database #index #performance

5 min read

Franck Pachot for MongoDB

May 24

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

#mongodb #postgres #database #index

5 min read

Franck Pachot for MongoDB

May 23

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

#mongodb #database #index #performance

3 min read

Franck Pachot for MongoDB

May 23

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

#postgres #mongodb #json #document

4 min read

Franck Pachot for MongoDB

May 22

Search Index for Reporting

#mongodb #database #index #performance

2 min read

Franck Pachot for MongoDB

May 22

Sampling Without Index

#mongodb #database #index #performance

2 min read

Franck Pachot for MongoDB

May 22

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

#mongodb #database #index #performance

3 min read

Franck Pachot for MongoDB

May 6

HTAP Using a Star Query on MongoDB Atlas Search Index

#mongodb #htap #olap #database

14 min read

Franck Pachot for AWS Heroes

May 5

Amazon DocumentDB and multi-key indexing

#mongodb #aws #documentdb #index

8 min read

Franck Pachot for AWS Heroes

May 4

Amazon DocumentDB != Microsoft DocumentDB extension for PostgreSQL

#documentdb #aws #azure #mongodb

3 min read

Franck Pachot

May 1

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

#mongodb #postgres #document #database

15 min read

Franck Pachot

Apr 30

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

#postgres #json #sql #mongodb

5 min read

Franck Pachot for AWS Heroes

Apr 28

PostgreSQL aborts the transactions on error

#postgres #sql #database #savepoint

3 min read

Franck Pachot for MongoDB

Apr 27

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

#database #index #webdev #programming

10 min read

Franck Pachot for MongoDB

Apr 15

PostgreSQL JSONB Indexing Limitations with B-Tree and GIN

#postgres #gin #btree #jsonb

8 min read

Franck Pachot

Apr 11

Oracle Multi-Value Index and ORDER BY Pagination queries

#mongodb #oracle #multivalue #oson

7 min read

Franck Pachot for MongoDB

Apr 6

Where SQL joins struggle but MongoDB documents shine

#mongodb #postgres #sql #database

9 min read

Franck Pachot for MongoDB

Apr 3

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

#mongodb #sql #database #postgres

7 min read

Franck Pachot for MongoDB

Mar 31

The World Is Too Messy for SQL to Work

#sql #database #relational #document

10 min read

Franck Pachot for MongoDB

Mar 26

MongoDB Vector Search Index, With Local Atlas and Ollama

#mongodb #vectordatabase #llm #ai

4 min read