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
Sequences in MongoDB

Sequences in MongoDB

Comments
4 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
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

5
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

11
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)

2
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)

11
Comments 1
4 min read
Search Index for Reporting

Search Index for Reporting

8
Comments
2 min read
Sampling Without Index

Sampling Without Index

7
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

Comments
6 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
Order-preserving or-expansion in MongoDB and $in:[,,] treated as a range skip scan, or exploded to an equality for the ESR rule

Order-preserving or-expansion in MongoDB and $in:[,,] treated as a range skip scan, or exploded to an equality for the ESR rule

9
Comments
5 min read
Skip Scan in MongoDB with Range, Equality (RE) index as an alternative to Equality, Sort, Range (ESR)

Skip Scan in MongoDB with Range, Equality (RE) index as an alternative to Equality, Sort, Range (ESR)

2
Comments
4 min read
MongoDB Equality, Sort, Range (ESR) without Equality (SR): add an unbounded range predicate on the indexed sort field

MongoDB Equality, Sort, Range (ESR) without Equality (SR): add an unbounded range predicate on the indexed sort field

6
Comments 2
5 min read
Aurora DSQL is different than Aurora, but Aurora DSQL belongs to Aurora (which belongs to RDS)

Aurora DSQL is different than Aurora, but Aurora DSQL belongs to Aurora (which belongs to RDS)

1
Comments
3 min read
Document Expiration with TTL Indexes in MongoDB

Document Expiration with TTL Indexes in MongoDB

9
Comments 9
8 min read
My Journey to NoSQL and Document Databases

My Journey to NoSQL and Document Databases

Comments
1 min read
UUIDv7 in YugabyteDB

UUIDv7 in YugabyteDB

1
Comments
2 min read
โ›” ORDER BY in Subquery

โ›” ORDER BY in Subquery

3
Comments 2
7 min read
set parameter if exists

set parameter if exists

Comments
1 min read
ESR (Equality, Sort, Range) rule applied to YugabyteDB and PostgreSQL indexes

ESR (Equality, Sort, Range) rule applied to YugabyteDB and PostgreSQL indexes

7
Comments 1
11 min read
Indexing for NOT EQUAL (<>,!=) in YugabyteDB, PostgreSQL, Oracle Database, SQL Server, and MongoDB

Indexing for NOT EQUAL (<>,!=) in YugabyteDB, PostgreSQL, Oracle Database, SQL Server, and MongoDB

4
Comments
13 min read
PostgreSQL 15 Compatibility in YugabyteDB 2.25: Top 15 Features!

PostgreSQL 15 Compatibility in YugabyteDB 2.25: Top 15 Features!

Comments
8 min read
PostgreSQL Synchronized Sequential Scans and LIMIT without an ORDER BY

PostgreSQL Synchronized Sequential Scans and LIMIT without an ORDER BY

1
Comments
3 min read
Aggregates with NULL: count(), min(), max(), sum()

Aggregates with NULL: count(), min(), max(), sum()

Comments
3 min read
What does NULL mean in an OUTER JOIN? ("unknown" vs. "not exists")

What does NULL mean in an OUTER JOIN? ("unknown" vs. "not exists")

2
Comments
4 min read
PostgreSQL plan_cache_mode

PostgreSQL plan_cache_mode

2
Comments
6 min read
loading...