✕ Clear all filters
22 articles
▶ Videos →

📰 Dev.to · Franck Pachot

22 articles · Updated every 3 hours · View all reads

All Articles 133,220Blog Posts 137,666Tech Tutorials 34,544Research Papers 25,940News 18,846 ⚡ AI Lessons
Updating "denormalized" aggregates with "duplicates": MongoDB vs. PostgreSQL
Dev.to · Franck Pachot 🔧 Backend Engineering 4mo ago
Updating "denormalized" aggregates with "duplicates": MongoDB vs. PostgreSQL
TL;DR: In database-centric development, duplication is dangerous because, in shared, normalized...
Read article → + Playlist
PgBench on MongoDB via Foreign Data Wrapper
Dev.to · Franck Pachot 🔧 Backend Engineering 6mo ago
PgBench on MongoDB via Foreign Data Wrapper
Disclaimer: This is an experiment, not a benchmark, and not an architectural recommendation....
Read article → + Playlist
Which Document class is best to use in Java to read MongoDB documents?
Dev.to · Franck Pachot 🔧 Backend Engineering 6mo ago
Which Document class is best to use in Java to read MongoDB documents?
TL;DR: the answer is in the title, use Document. BSON is a serialization format, similar to...
Read article → + Playlist
MongoDB read and write concerns compared to PostgreSQL synchronous commit
Dev.to · Franck Pachot 🔧 Backend Engineering 6mo ago
MongoDB read and write concerns compared to PostgreSQL synchronous commit
If you are used to SQL databases, MongoDB’s consistency model can be confusing. Many traditional...
Read article → + Playlist
Adaptive Join in Amazon Aurora PostgreSQL
Dev.to · Franck Pachot 🔧 Backend Engineering 7mo ago
Adaptive Join in Amazon Aurora PostgreSQL
Slow joins in PostgreSQL often result from a nested loop join chosen by the query planner, which...
Read article → + Playlist
JSONB vs. BSON: Tracing PostgreSQL and MongoDB Wire Protocols
Dev.to · Franck Pachot 🔧 Backend Engineering 7mo ago
JSONB vs. BSON: Tracing PostgreSQL and MongoDB Wire Protocols
There is an essential difference between MongoDB’s BSON and PostgreSQL’s JSONB. Both are binary JSON...
Read article → + Playlist
Atlas Search scoring calculation and why Lucene scores differ from Elasticsearch and pg_(text)search
Dev.to · Franck Pachot 🔧 Backend Engineering 7mo ago
Atlas Search scoring calculation and why Lucene scores differ from Elasticsearch and pg_(text)search
With @james_blackwoodsewell_58 we were comparing the BM25 text search scores between MongoDB Atlas...
Read article → + Playlist
Many-to-One: Stronger Relationship Design with MongoDB
Dev.to · Franck Pachot 🔧 Backend Engineering 7mo ago
Many-to-One: Stronger Relationship Design with MongoDB
In a relational database, a one-to-many relationship is typically implemented with two tables. The...
Read article → + Playlist
No, MongoDB Does Not Mean Skipping Design
Dev.to · Franck Pachot 🔧 Backend Engineering 7mo ago
No, MongoDB Does Not Mean Skipping Design
With MongoDB, domain-driven design empowers developers to build robust systems by aligning the data...
Read article → + Playlist
Script to list MongoDB collection URI (to map to WiredTiger files)
Dev.to · Franck Pachot 🔧 Backend Engineering 7mo ago
Script to list MongoDB collection URI (to map to WiredTiger files)
When tracing I/O to WiredTiger files, like with strace -y, the filenames do not give the collection...
Read article → + Playlist
MongoDB Index Intersection (and PostgreSQL Bitmap-and)
Dev.to · Franck Pachot 🔧 Backend Engineering 7mo ago
MongoDB Index Intersection (and PostgreSQL Bitmap-and)
You won’t always have a perfect index for every query, but may have have single-field indexes for...
Read article → + Playlist
What writeConcern: {w: 1} Really Means: Isolation and Durability
Dev.to · Franck Pachot 🔧 Backend Engineering 8mo ago
What writeConcern: {w: 1} Really Means: Isolation and Durability
In MongoDB, a write concern of w:1 indicates that a write operation is considered successful once the...
Read article → + Playlist
INNER JOIN and LEFT OUTER JOIN in MongoDB (with $lookup and $unwind)
Dev.to · Franck Pachot 🔧 Backend Engineering 8mo ago
INNER JOIN and LEFT OUTER JOIN in MongoDB (with $lookup and $unwind)
We often explain $lookup as similar to a relational JOIN, but there’s a key difference in the...
Read article → + Playlist
How does it scale? A basic OLTP benchmark on MongoDB
Dev.to · Franck Pachot 🔧 Backend Engineering 8mo ago
How does it scale? A basic OLTP benchmark on MongoDB
Choosing a database requires ensuring that performance remains fast as your data grows. For example,...
Read article → + Playlist
Covering Index for $group/$sum in MongoDB Aggregation (With Hint)
Dev.to · Franck Pachot 🔧 Backend Engineering 8mo ago
Covering Index for $group/$sum in MongoDB Aggregation (With Hint)
MongoDB indexes enable quick equality and range filtering (with $match) and ordering (with $sort)....
Read article → + Playlist
Advanced Query Capabilities 👉🏻 aggregation pipelines
Dev.to · Franck Pachot 🔧 Backend Engineering 9mo ago
Advanced Query Capabilities 👉🏻 aggregation pipelines
Although MongoDB has supported ACID transactions and sophisticated aggregation features for years,...
Read article → + Playlist
First/Last per Group: PostgreSQL DISTINCT ON and MongoDB DISTINCT_SCAN Performance
Dev.to · Franck Pachot 🔧 Backend Engineering 9mo 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
Text Search With MongoDB (BM25 TF-IDF) and PostgreSQL
Dev.to · Franck Pachot 🔧 Backend Engineering 10mo 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
ALTER TABLE ... ADD COLUMN
Dev.to · Franck Pachot 🔧 Backend Engineering 1y ago
ALTER TABLE ... ADD COLUMN
MongoDB’s flexible schema allows each document within a collection to have a unique structure, a...
Read article → + Playlist
No pre-filtering in pgvector means reduced ANN recall ( impact on Vector Search accuracy)
Dev.to · Franck Pachot 🔧 Backend Engineering 1y 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
DuckDB to query MongoDB
Dev.to · Franck Pachot 🔧 Backend Engineering 1y ago
DuckDB to query MongoDB
DuckDB is a high-performance analytical database, but it is single-process, so it cannot replace an...
Read article → + Playlist
Using a Star Query on MongoDB Atlas Search Index
Dev.to · Franck Pachot 🔧 Backend Engineering 1y ago
Using a Star Query on MongoDB Atlas Search Index
MongoDB is used for its strength in managing online transaction processing (OLTP) with a document...
Read article → + Playlist