DuckDB is a high-performance analytical database, but it is single-process, so it cannot replace an... Tagged with postgres, mongodb, duckdb, analytics.

Franck Pachot

13.06.2025

Isolation Level for MongoDB Multi-Document Transactions - DEV Community

Many outdated or imprecise claims about transaction isolation levels in MongoDB persist. These claims... Tagged with mongodb, document, database, acid.

Franck Pachot

13.06.2025

"Schema Later" considered harmful 👉🏻 schema validation - DEV Community

In a blog post titled "Schema Later" Considered Harmful on EDB's site, Michael Stonebraker... Tagged with mongodb, document, database, postgres.

Franck Pachot

13.06.2025

Comparison of JOINS 👉🏻 aggregation pipeline and CTEs - DEV Community

In a blog post titled Comparison of JOINS: MongoDB vs. PostgreSQL on EDB's site, Michael Stonebraker... Tagged with mongodb, lookup, join, aggregation.

Franck Pachot

10.06.2025

"Schema Later" considered harmful 👉🏻 schema validation - DEV Community

In a blog post titled "Schema Later" Considered Harmful on EDB's site, Michael Stonebraker... Tagged with mongodb, document, database, postgres.

Franck Pachot

10.06.2025

Comparison of JOINS 👉🏻 aggregation pipeline and CTEs - DEV Community

In a blog post titled Comparison of JOINS: MongoDB vs. PostgreSQL on EDB's site, Michael Stonebraker... Tagged with mongodb, lookup, join, aggregation.

Franck Pachot

07.06.2025

Isolation Level for MongoDB Multi-Document Transactions - DEV Community

Many outdated or imprecise claims about transaction isolation levels in MongoDB persist. These claims... Tagged with mongodb, document, database, acid.

Franck Pachot

05.06.2025

JSONB DeTOASTing (read amplification) - DEV Community

PostgreSQL limits tuple sizes to a quarter of the block size, generally capping at 2KB. In document... Tagged with postgres, jsonb, document, database.

Franck Pachot

02.06.2025

No HOT updates on JSONB (write amplification) - DEV Community

PostgreSQL's Multi-Version Concurrency Control (MVCC) works around the challenge of in-place updates... Tagged with postgres, document, database, mongodb.

Franck Pachot

01.06.2025

No HOT updates on JSONB (write amplification) - DEV Community

PostgreSQL's Multi-Version Concurrency Control (MVCC) works around the challenge of in-place updates... Tagged with postgres, document, database, mongodb.

Franck Pachot

30.05.2025

PostgreSQL (with JSONB) and MongoDB (with schema) - DEV Community

In recent years, MongoDB and PostgreSQL have gained popularity, representing the NoSQL and SQL camps,... Tagged with postgres, mongodb, json, document.

Franck Pachot

30.05.2025

$graphLookup (Connect By / Recursive Query) - DEV Community

In this series, I present various access patterns for a specific document model. These patterns are... Tagged with mongodb, document, database, index.

Franck Pachot

29.05.2025

Equality with Multiple Values, Preserving Sort for Pagination - DEV Community

In the previous post, I've created the following index to quickly find the last videos in one... Tagged with mongodb, database, index, performance.

Franck Pachot

29.05.2025

Sampling Without Index - DEV Community

I won't create any indexes for this post yet, but I can still filter efficiently to run a query in... Tagged with mongodb, database, index, performance.

Franck Pachot

29.05.2025

No Index Only Scan on JSONB Fields (and with even scalar) - DEV Community

On reddit, a PostgreSQL user was trying to use the SQL database as a document database, with all data... Tagged with postgres, mongodb, json, document.

Franck Pachot

29.05.2025

B-Tree for Equality, Sort, Range - DEV Community

When creating an index, you don't need the full details of the queries it will serve, but the... Tagged with mongodb, database, index, performance.

Franck Pachot

29.05.2025

Search Index for Reporting - DEV Community

In the first post of this series, I've imported a sample dataset, and I'll show how adding a few... Tagged with mongodb, database, index, performance.

Franck Pachot

29.05.2025

No Index for LIKE on JSONB with Array in the Path - DEV Community

Here is an example where using PostgreSQL as a document database will quickly fail: indexing. Either... Tagged with mongodb, postgres, database, index.

Franck Pachot

29.05.2025

$elemMatch and Multi-Key Indexes - DEV Community

In the previous post, I used the following index on the daily views data, which is an array of... Tagged with mongodb, document, database, index.

Franck Pachot

29.05.2025

Sort on Array with Multi-Key Index - DEV Community

In the previous post, we discussed how MongoDB indexes retrieve documents ordered by a specific... Tagged with mongodb, document, database, index.

Franck Pachot

29.05.2025

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

When designing a schema for MongoDB, it’s crucial to understand your domain access patterns. The... Tagged with mongodb, database, index, performance.

Franck Pachot

28.05.2025

Google Firestore with MongoDB compatibility - DEV Community

In this series, I tested multiple MongoDB emulations on top of SQL databases, and all failed to be... Tagged with mongodb, database, index, firestore.

Franck Pachot

27.05.2025

Sort on Array with Multi-Key Index - DEV Community

In the previous post, we discussed how MongoDB indexes retrieve documents ordered by a specific... Tagged with mongodb, document, database, index.

Franck Pachot

26.05.2025

Equality with Multiple Values, Preserving Sort for Pagination - DEV Community

In the previous post, I've created the following index to quickly find the last videos in one... Tagged with mongodb, database, index, performance.

Franck Pachot

25.05.2025

No Index for LIKE on JSONB with Array in the Path - DEV Community

Here is an example where using PostgreSQL as a document database will quickly fail: indexing. Either... Tagged with mongodb, postgres, database, index.

Franck Pachot

24.05.2025

B-Tree for Equality, Sort, Range - DEV Community

When creating an index, you don't need the full details of the queries it will serve, but the... Tagged with mongodb, database, index, performance.

Franck Pachot

23.05.2025

PostgreSQL (with JSONB) and MongoDB (with schema) - DEV Community

In recent years, MongoDB and PostgreSQL have gained popularity, representing the NoSQL and SQL camps,... Tagged with postgres, mongodb, json, document.

Franck Pachot

23.05.2025

Sampling Without Index - DEV Community

I won't create any indexes for this post yet, but I can still filter efficiently to run a query in... Tagged with mongodb, database, index, performance.

Franck Pachot

23.05.2025

Search Index for Reporting - DEV Community

In the first post of this series, I've imported a sample dataset, and I'll show how adding a few... Tagged with mongodb, database, index, performance.

Franck Pachot

23.05.2025

No Index Only Scan on JSONB Fields (and with even scalar) - DEV Community

On reddit, a PostgreSQL user was trying to use the SQL database as a document database, with all data... Tagged with postgres, mongodb, json, document.

Franck Pachot

23.05.2025

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

When designing a schema for MongoDB, it’s crucial to understand your access patterns. The document... Tagged with mongodb, database, index, performance.

Franck Pachot

07.05.2025

HTAP Using a Star Query on MongoDB Atlas Search Index - DEV Community

MongoDB is used for its strength in managing online transaction processing (OLTP) with a document... Tagged with mongodb, htap, olap, database.

Franck Pachot

06.05.2025

Amazon DocumentDB and multi-key indexing - DEV Community

In previous posts, I discussed the limitations of MongoDB emulations on databases like Oracle and... Tagged with mongodb, aws, documentdb, index.

Franck Pachot

05.05.2025

Amazon DocumentDB != Microsoft DocumentDB extension for PostgreSQL - DEV Community

My next post will be about Amazon DocumentDB and how it compares to MongoDB in terms of indexing a... Tagged with documentdb, aws, azure, mongodb.

Franck Pachot

02.05.2025

Microsoft DocumentDB: RUM instead of GIN but same limitations on JSON paths - DEV Community

Storing documents in PostgreSQL does not transform it to a document database. Embedded documents in... Tagged with mongodb, postgres, document, database.

Franck Pachot

01.05.2025

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

When working with document-based data structures, the fields at the root can be indexed using simple... Tagged with postgres, json, sql, mongodb.

Franck Pachot

30.04.2025

Where SQL joins struggle but MongoDB documents shine - DEV Community

Claims such as "Joins are slow" or "Joins don't scale" often prompt me to showcase how efficiently... Tagged with mongodb, postgres, sql, database.

Franck Pachot

30.04.2025

Index Only Scan on JSON Documents, with Covering and Multi-Key Indexes in MongoDB - DEV Community

Storing JSON documents in a SQL database does not make it a document database. The strength of any... Tagged with mongodb, document, database, index.

Franck Pachot

30.04.2025

MongoDB with Search Indexes Queried as Kimball's Star Schema with Facts and Dimensions - DEV Community

Export From SQL to CSV Import to MongoDB Indexing the Star Schema Querying the Star Schema - Star... Tagged with mongodb, search, index, analytics.

Franck Pachot

30.04.2025

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

In relational SQL databases, foreign keys are essential for guaranteeing referential integrity. There... Tagged with mongodb, sql, database, postgres.

home›Franck Pachot›Software

Franck Pachot - Software

DuckDB to query MongoDB - DEV Community

Isolation Level for MongoDB Multi-Document Transactions - DEV Community

"Schema Later" considered harmful 👉🏻 schema validation - DEV Community

Comparison of JOINS 👉🏻 aggregation pipeline and CTEs - DEV Community

"Schema Later" considered harmful 👉🏻 schema validation - DEV Community

Comparison of JOINS 👉🏻 aggregation pipeline and CTEs - DEV Community

Isolation Level for MongoDB Multi-Document Transactions - DEV Community

JSONB DeTOASTing (read amplification) - DEV Community

No HOT updates on JSONB (write amplification) - DEV Community

No HOT updates on JSONB (write amplification) - DEV Community

PostgreSQL (with JSONB) and MongoDB (with schema) - DEV Community

$graphLookup (Connect By / Recursive Query) - DEV Community

Equality with Multiple Values, Preserving Sort for Pagination - DEV Community

Sampling Without Index - DEV Community

No Index Only Scan on JSONB Fields (and with even scalar) - DEV Community

B-Tree for Equality, Sort, Range - DEV Community

Search Index for Reporting - DEV Community

No Index for LIKE on JSONB with Array in the Path - DEV Community

$elemMatch and Multi-Key Indexes - DEV Community

Sort on Array with Multi-Key Index - DEV Community

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

Google Firestore with MongoDB compatibility - DEV Community

Sort on Array with Multi-Key Index - DEV Community

Equality with Multiple Values, Preserving Sort for Pagination - DEV Community

No Index for LIKE on JSONB with Array in the Path - DEV Community

B-Tree for Equality, Sort, Range - DEV Community

PostgreSQL (with JSONB) and MongoDB (with schema) - DEV Community

Sampling Without Index - DEV Community

Search Index for Reporting - DEV Community

No Index Only Scan on JSONB Fields (and with even scalar) - DEV Community

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

HTAP Using a Star Query on MongoDB Atlas Search Index - DEV Community

Amazon DocumentDB and multi-key indexing - DEV Community

Amazon DocumentDB != Microsoft DocumentDB extension for PostgreSQL - DEV Community

Microsoft DocumentDB: RUM instead of GIN but same limitations on JSON paths - DEV Community

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

Where SQL joins struggle but MongoDB documents shine - DEV Community

Index Only Scan on JSON Documents, with Covering and Multi-Key Indexes in MongoDB - DEV Community

MongoDB with Search Indexes Queried as Kimball's Star Schema with Facts and Dimensions - DEV Community

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

home
›
Franck Pachot
›
Software