107 articles

📰 Dev.to · Franck Pachot

Articles from Dev.to · Franck Pachot · 107 articles · Updated every 3 hours · View all reads

All ⚡ AI Lessons (10812) ArXiv cs.AIDev.to · FORUM WEBDev.to AIForbes InnovationOpenAI NewsHugging Face Blog
First/Last per Group: PostgreSQL DISTINCT ON and MongoDB DISTINCT_SCAN Performance
Dev.to · Franck Pachot 6mo ago
First/Last per Group: PostgreSQL DISTINCT ON and MongoDB DISTINCT_SCAN Performance
On Stack Overflow, the most frequent question for PostgreSQL is: "Select first row in each GROUP BY...
Read article → + Playlist
WiredTigerHS.wt: MongoDB MVCC Durable History Store
Dev.to · Franck Pachot 6mo ago
WiredTigerHS.wt: MongoDB MVCC Durable History Store
MongoDB uses the WiredTiger storage engine, which implements Multi‑Version Concurrency Control (MVCC)...
Read article → + Playlist
MongoDB Search Index Internals With Luke (Lucene Toolbox GUI Tool)
Dev.to · Franck Pachot 6mo ago
MongoDB Search Index Internals With Luke (Lucene Toolbox GUI Tool)
Previously, I demonstrated MongoDB text search scoring with a simple example, creating a dynamic...
Read article → + Playlist
Text Search With MongoDB (BM25 TF-IDF) and PostgreSQL
Dev.to · Franck Pachot 6mo ago
Text Search With MongoDB (BM25 TF-IDF) and PostgreSQL
MongoDB search indexes provide full‑text search capabilities directly within MongoDB, allowing...
Read article → + Playlist
Combine Two JSON Collections with Nested Arrays: MongoDB and PostgreSQL Aggregations
Dev.to · Franck Pachot 6mo ago
Combine Two JSON Collections with Nested Arrays: MongoDB and PostgreSQL Aggregations
Suppose you need to merge two sources of data—both JSON documents containing nested arrays. This was...
Read article → + Playlist
MongoDB Multikey Indexes and Index Bound Optimization
Dev.to · Franck Pachot 6mo ago
MongoDB Multikey Indexes and Index Bound Optimization
Previously, I discussed how MongoDB keeps track of whether indexed fields contain arrays. This...
Read article → + Playlist
MongoDB Internals: How Collections and Indexes Are Stored in WiredTiger
Dev.to · Franck Pachot 7mo ago
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...
Read article → + Playlist
Resilience of MongoDB's WiredTiger Storage Engine to Disk Failure Compared to PostgreSQL and Oracle
Dev.to · Franck Pachot 7mo ago
Resilience of MongoDB's WiredTiger Storage Engine to Disk Failure Compared to PostgreSQL and Oracle
There have been jokes that have contributed to persistent myths about MongoDB's durability. The...
Read article → + Playlist
DocumentDB: Comparing Emulation Internals with MongoDB
Dev.to · Franck Pachot 7mo ago
DocumentDB: Comparing Emulation Internals with MongoDB
MongoDB is the leading database for document data modeling, with its Atlas service available on AWS,...
Read article → + Playlist
Updates to the Same Value: MongoDB Optimization
Dev.to · Franck Pachot 7mo ago
Updates to the Same Value: MongoDB Optimization
In MongoDB, when you update a field to the same value it already holds, the database optimizes the...
Read article → + Playlist
Embedding Into JSONB Still Feels Like a JOIN for Large Documents
Dev.to · Franck Pachot 7mo ago
Embedding Into JSONB Still Feels Like a JOIN for Large Documents
Think PostgreSQL with JSONB can replace a document database? It’s a tempting idea: Embed your related...
Read article → + Playlist
Does PostgreSQL support as much "schema flexibility" as MongoDB? Not for indexing!
Dev.to · Franck Pachot 8mo ago
Does PostgreSQL support as much "schema flexibility" as MongoDB? Not for indexing!
Another day, another myth. Someone on Medium claims PostgreSQL offers as much "schema flexibility" as...
Read article → + Playlist
MongoDB indexing internals: .showRecordId() and .hint({$natural:1})
Dev.to · Franck Pachot 8mo ago
MongoDB indexing internals: .showRecordId() and .hint({$natural:1})
You can understand how MongoDB stores documents internally with simple queries that rely on the...
Read article → + Playlist
Transaction performance 👉🏻 retry with backoff
Dev.to · Franck Pachot 8mo ago
Transaction performance 👉🏻 retry with backoff
A benchmark sponsored by EDB, a PostgreSQL company, in 2019 contributed to the myth that MongoDB...
Read article → + Playlist
Lock-Free Wait-on-Conflict and Fail-on-Conflict in MongoDB
Dev.to · Franck Pachot 8mo ago
Lock-Free Wait-on-Conflict and Fail-on-Conflict in MongoDB
Concurrency control in databases has two main modes for handling conflicts. Traditionally, these are...
Read article → + Playlist
.hint() in MongoDB is different that SQL optimizer hints: they force indexes
Dev.to · Franck Pachot 8mo ago
.hint() in MongoDB is different that SQL optimizer hints: they force indexes
MongoDB sits at the crossroads between SQL, where developers can write queries on a logical model...
Read article → + Playlist
Database latency with PostgreSQL and MongoDB: it's the data model that makes it fast
Dev.to · Franck Pachot 8mo ago
Database latency with PostgreSQL and MongoDB: it's the data model that makes it fast
A business transaction ideally involves a single roundtrip to the database. MongoDB allows a single...
Read article → + Playlist
Sequences in MongoDB
Dev.to · Franck Pachot 8mo ago
Sequences in MongoDB
In a previous post about No-gap sequence in PostgreSQL and YugabyteDB, I mentioned that sequences in...
Read article → + Playlist
ALTER TABLE ... ADD COLUMN
Dev.to · Franck Pachot 9mo ago
ALTER TABLE ... ADD COLUMN
MongoDB’s flexible schema allows each document within a collection to have a unique structure, a...
Read article → + Playlist
Strong consistency 👉🏻 MongoDB highly available durable writes (Replication)
Dev.to · Franck Pachot 9mo ago
Strong consistency 👉🏻 MongoDB highly available durable writes (Replication)
In the previous post, I used strace to display all calls to write and sync to disk from any MongoDB...
Read article → + Playlist
Flush to disk on commit 👉🏻 MongoDB durable writes (ACID)
Dev.to · Franck Pachot 9mo ago
Flush to disk on commit 👉🏻 MongoDB durable writes (ACID)
A Twitter (𝕏) thread was filled with misconceptions about MongoDB, spreading fear, uncertainty, and...
Read article → + Playlist
No pre-filtering in pgvector means reduced ANN recall ( impact on Vector Search accuracy)
Dev.to · Franck Pachot 9mo ago
No pre-filtering in pgvector means reduced ANN recall ( impact on Vector Search accuracy)
AI applications are expanding rapidly, and PostgreSQL is a popular choice among relational databases....
Read article → + Playlist
faster $lookup after $group in MongoDB aggregation pipeline (Performance Optimization Tips)
Dev.to · Franck Pachot 9mo ago
faster $lookup after $group in MongoDB aggregation pipeline (Performance Optimization Tips)
In the previous post One million $lookup challenge I said that $lookup is efficient at the end of an...
Read article → + Playlist
One million $lookup challenge (performance comparison)
Dev.to · Franck Pachot 9mo ago
One million $lookup challenge (performance comparison)
I you have read my previous post $lookup: more than just a SQL join, you understand that $lookup is...
Read article → + Playlist