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 YugabyteDB

Jun 7 '24

Comparing DB engines by CPU instructions for simple DML

#linux #cpu #distributed #sql

22 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

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

Apr 11

Oracle Multi-Value Index and ORDER BY Pagination queries

#mongodb #oracle #multivalue #oson

6 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

6 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

Franck Pachot for MongoDB

Mar 24

MongoDB TTL and Disk Storage

#mongodb #ttl #index #database

4 min read

Franck Pachot for MongoDB

Mar 19

MongoDB equivalent for PostgreSQL JSONB operations

#postgres #mongodb #document #database

12 min read

Franck Pachot for MongoDB

Mar 17

Normalization and Relational Division in SQL and MongoDB

#mongodb #sql #relational #database

7 min read

Franck Pachot for MongoDB

Mar 13

MongoDB Multi-Planner Optimizer and Plan Cache

#mongodb #database #optimizer #planner

13 min read

Franck Pachot for MongoDB

Mar 9

Comparing Execution Plans: MongoDB vs. Compatible APIs

#mongodb #oracle #database #index

6 min read

Franck Pachot for MongoDB

Feb 27

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

#postgres #index #sort #webdev

5 min read

Franck Pachot for MongoDB

Feb 27

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

#mongodb #database #indexing #webdev

4 min read

Franck Pachot for MongoDB

Feb 11

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

#mongodb #indexing #database #webdev

5 min read

Franck Pachot for AWS Heroes

Feb 9

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

#aws #rds #aurora #postgres

3 min read

Franck Pachot

Feb 8

Document Expiration with TTL Indexes in MongoDB

#mongodb #ttl #index #metrics

8 min read

Franck Pachot

Feb 6

My Journey to NoSQL and Document Databases

#mongodb

1 min read

Franck Pachot for YugabyteDB

Feb 5

UUIDv7 in YugabyteDB

#yugabytedb #distributed #postgres #sql

2 min read

Franck Pachot for YugabyteDB

Jan 30

⛔ ORDER BY in Subquery

#yugabytedb #distributed #postgres #sql

7 min read

Franck Pachot for YugabyteDB

Jan 29

set parameter if exists

#yugabytedb #postgres #distributed #database

1 min read

Franck Pachot for YugabyteDB

Jan 26

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

#yugabytedb #postgres #index #mongodb

11 min read

Franck Pachot for AWS Heroes

Jan 24

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

#mongodb #oracle #postgres #yugabytedb

13 min read

Franck Pachot for YugabyteDB

Jan 22

PostgreSQL 15 Compatibility in YugabyteDB 2.25: Top 15 Features!

#yugabytedb #postgres #distributed #sql

8 min read

Franck Pachot

Jan 20

PostgreSQL Synchronized Sequential Scans and LIMIT without an ORDER BY

#postgres #sql #database #fullscan

3 min read

Franck Pachot for YugabyteDB

Jan 17

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

#postgres #sql #database #yugabytedb

3 min read

Franck Pachot for YugabyteDB

Jan 16

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

#yugabytedb #distributed #postgres #sql

4 min read

Franck Pachot for YugabyteDB

Jan 14

PostgreSQL plan_cache_mode

#yugabytedb #postgres #distributed #sql

6 min read

Franck Pachot for YugabyteDB

Jan 14

could not serialize access due to concurrent update

4 min read

Franck Pachot for AWS Heroes

Jan 12

Unique Index on NULL Values in SQL & NoSQL

#postgres #oracle #mongodb #yugabytedb

14 min read

Franck Pachot for YugabyteDB

Jan 8

Large IntentsDB MemTable with Many Small SST Files

#yugabytedb #distributed #postgres #database

5 min read

Franck Pachot for YugabyteDB

Jan 3

Index Filtering in PostgreSQL and YugabyteDB (Index Scan instead of Index Only Scan)

#yugabytedb #postgres #distributed #database

12 min read

Franck Pachot

Jan 2

Aurora DSQL: How it Compares to YugabyteDB

#yugabytedb #postgres #distributed #database

9 min read

Franck Pachot for YugabyteDB

Dec 29 '24

More details in pg_locks for YugabyteDB

#yugabytedb #distributed #postgres #database

4 min read

Franck Pachot for YugabyteDB

Dec 28 '24

Document data modeling to avoid write skew anomalies

#yugabytedb #distributed #postgres #json

4 min read

Franck Pachot for YugabyteDB

Dec 25 '24

When to replace IN() with EXISTS() - correlated and uncorrelated subqueries

#yugabytedb #distributed #postgres #database

8 min read

Franck Pachot for AWS Heroes

Dec 19 '24

Referential integrity In The Absence Of Foreign Key

#aws #aurora #dsql #database

5 min read

Franck Pachot for YugabyteDB

Dec 17 '24

2024.2: Faster with Shared Memory Between PostgreSQL and TServer Layers

#yugabytedb #distributed #sql #database

4 min read

Franck Pachot for AWS Heroes

Dec 16 '24

Multi-Region Distributed SQL Transaction Latency

#aws #aurora #dsql #database

13 min read

Franck Pachot for AWS Heroes

Dec 15 '24

Global Secondary Indexes in Distributed SQL

7 min read

Franck Pachot for AWS Heroes

Dec 13 '24

Optimistic Concurrency Control: Alice and Bob Couldn't Sit Together 🙁

7 min read

Franck Pachot for AWS Heroes

Dec 11 '24

Joins, Scale, and Denormalization

#aws #postgres #aurora #dsql

13 min read

Franck Pachot for AWS Heroes

Dec 11 '24

DynamoDB-style Limits for Predictable SQL Performance?

#aws #postgres #distributed #database

6 min read

Franck Pachot for AWS Heroes

Dec 9 '24

Aurora DSQL - Simple Inserts Workload from an AWS CloudShell

#aws #aurora #dsql #yugabytedb

17 min read

Franck Pachot for AWS Heroes

Dec 7 '24

Aurora DSQL: Create a Serverless Cluster and Connect with PostgreSQL Client

#aws #postgres #distributed #sql

5 min read

Franck Pachot for AWS Heroes

Dec 3 '24

Amazon Aurora DSQL: Which PostgreSQL Service Should I Use on AWS ?

#aws #distributed #database #yugabytedb

6 min read

Franck Pachot for YugabyteDB

Dec 1 '24

YugabyteDB MVCC and Updates: columns vs. JSON

#yugabytedb #distributed #postgres #database

8 min read

Franck Pachot for AWS Heroes

Nov 30 '24

Aurora Limitless - Sequences

#aws #postgres #sharded #database

4 min read

Franck Pachot for AWS Heroes

Nov 29 '24

Aurora Limitless - Global Consistency (ACID)

#aws #postgres #sharded #database

2 min read

Franck Pachot for AWS Heroes

Nov 28 '24

Aurora Limitless - Collocation (and porting PgBench)

#aws #postgres #sharded #database

8 min read

Franck Pachot for AWS Heroes

Nov 27 '24

Aurora Limitless - Reference Tables

#aws #postgres #sharded #database

6 min read

Franck Pachot for AWS Heroes

Nov 26 '24

Aurora Limitless - Resharding

#aws #postgres #sharded #database

8 min read

Franck Pachot for AWS Heroes

Nov 26 '24

Aurora Limitless - SQL Limitations

#aws #postgres #sharded #database

6 min read