Franck Pachot
banner
franckpachot.bsky.social
Franck Pachot
@franckpachot.bsky.social
1.1K followers 320 following 330 posts
https://dev.to/franckpachot 🥑 Developer Advocate at 🍃 MongoDB 🔸 AWS Data Hero 🅾️ Oracle Certified Master 🐘 PostgreSQL and▝▞ Yugabyte​DB
Posts Media Videos Starter Packs
I believe those looking to time-partition by UUID are working with databases that lack global indexes to enforce unique constraints beyond the partition key. Or sharding those partitions
I enjoy staying connected with multiple database communities. Even if I share more about one today 🌱🐅, I'm happy to have feedback from others 🅾️🔸️🐘🐬 on what I share
Sad times where tech giant billionaires fire people to build datacenters in a giant game of Monopoly
From an Amazon Employees for Climate Justice statement:

“They’re pushing this narrative that AI is transformative and that’s why they’re making these cuts. But leadership is spending 100 billion this year alone on the new data centers; they have to find that money elsewhere,” said one AWS engineer.
A migration tool vendor suggests that migration is necessary for improved consistency, reliability, and advanced query capabilities. Yet, success often comes from first understanding your current database. Questioning these claims is the occasion to learn:
dev.to/franckpachot...
Advanced Query Capabilities 👉🏻 aggregation pipelines
Although MongoDB has supported ACID transactions and sophisticated aggregation features for years,...
dev.to
I'm curious to find out whether Oracle still uses DerbyDB in their Oracle Database Appliances to store the metadata, and what they will replace it with
If the banner has AI in lower and upper case, it must be great
Was just trying to be funny 😭 AI and vibe coding, resulting in too many buffer pins
I can think of 100s of reasons but you said 23ai, so... vibe pinning?
Reposted by Franck Pachot
Trust me I was so against it when I arrived at spark I’ve used it in the past and hated it.
but the lack of relations is actually amazing for backfill. it just makes it so simple and painless that I’m willing to live with the mongo of it all
and store the buffer in aifiedt.buf to be more AI friendly
Reposted by Franck Pachot
Blog post for September 2025

SQL Developer isn't entirely CBO-friendly.
jonathanlewis.wordpress.com/2025/09/24/s...
A closer look at MongoDB Text Search: which terms are indexed for a string, how they're stored, and what formula is used to calculate the query's matching score. Since it's based on Lucene, let's use Lucene tools. dev.to/franckpachot...
MongoDB Search Index Internals with Luke (Lucene Toolbox GUI tool)
Previously, I demonstrated MongoDB text search scoring with a simple example, creating a dynamic...
dev.to
A flexible schema permits arrays in fields without upfront declaration, and filters and indexes (multiple keys per document) use it automatically. MongoDB tracks multikey paths in indexed fields to optimize index scans:

dev.to/franckpachot...
MongoDB Multikey Indexes and Index Bound Optimization
Previously, I discussed how MongoDB keeps track of whether indexed fields contain arrays. This...
dev.to
MongoDB’s strength is not only in its flexible, document-oriented API, but also in its ability to store documents to disk without random I/O slicing or vacuuming later. Here's how MongoDB persists collections and indexes in WiredTiger:

dev.to/franckpachot...
MongoDB Internals: How Collections and Indexes Are Stored in WiredTiger
WiredTiger is MongoDB’s default storage engine, but what really occurs behind the scenes when...
dev.to
Encryption is not yet there in PostgreSQL
As that's on disk and malicious users with host access may access memory, the only full protection is encryption from the client. MongoDB has such queryable encryption:
www.mongodb.com/docs/manual/...
Queryable Encryption - Database Manual - MongoDB Docs
www.mongodb.com
Yes, more difficult as you have to calculate checksum and propagate to parent. Encryption protects from reading/changing block content
MongoDB is popular, inspiring databases to mimic its features on top of RDBMS. Examining execution plans can provide insight into how things work—such as how to simulate multi-key indexes in a database engine designed for single-key indexes on normalized schemas
dev.to/aws-heroes/d...
DocumentDB: Comparing Emulation Internals with MongoDB
MongoDB is the leading database for document data modeling, with its Atlas service available on AWS,...
dev.to