📰 Dev.to · Franck Pachot
Articles from Dev.to · Franck Pachot · 107 articles · Updated every 3 hours · View all reads
All
⚡ AI Lessons (10600)
ArXiv cs.AIDev.to · FORUM WEBDev.to AIForbes InnovationOpenAI NewsHugging Face Blog
Dev.to · Franck Pachot
10mo ago
$lookup: more than just a SQL join (understand performance)
When transitioning from a SQL background to MongoDB, the $lookup operation in an aggregation pipeline...
Dev.to · Franck Pachot
10mo ago
Queries on JSON 👉🏻 compound indexes (Equality, Sort, Range) in MongoDB
In a blog post titled New Benchmarks Show Postgres Dominating MongoDB in Varied Workloads, EDB claims...
Dev.to · Franck Pachot
10mo ago
DuckDB to query MongoDB
DuckDB is a high-performance analytical database, but it is single-process, so it cannot replace an...
Dev.to · Franck Pachot
10mo ago
Isolation Level for MongoDB Multi-Document Transactions (Strong Consistency)
Many outdated or imprecise claims about transaction isolation levels in MongoDB persist. These claims...
Dev.to · Franck Pachot
10mo ago
No HOT updates on JSONB (write amplification) performance impact
PostgreSQL's Multi-Version Concurrency Control (MVCC) works around the challenge of in-place updates...
Dev.to · Franck Pachot
10mo ago
$graphLookup (Connect By / Recursive Query)
In this series, I present various access patterns for a specific document model. These patterns are...
Dev.to · Franck Pachot
10mo ago
$elemMatch and Multi-Key Indexes
In the previous post, I used the following index on the daily views data, which is an array of...
Dev.to · Franck Pachot
10mo ago
Google Firestore with MongoDB compatibility - index limitations
In this series, I tested multiple MongoDB emulations on top of SQL databases, and all failed to be...
Dev.to · Franck Pachot
10mo ago
No Index for LIKE on JSONB with Array in the Path (GIN limitation)
Here is an example where using PostgreSQL as a document database will quickly fail: indexing. Either...
Dev.to · Franck Pachot
10mo ago
B-Tree for Equality, Sort, Range (indexing strategies in MongoDB)
When creating an index, you don't need the full details of the queries it will serve, but the...
Dev.to · Franck Pachot
10mo ago
No Index Only Scan on JSONB Fields (even on scalar)
On reddit, a PostgreSQL user was trying to use the SQL database as a document database, with all data...
Dev.to · Franck Pachot
10mo ago
Intro to PostgreSQL with JSONB compared to MongoDB, a general purpose document database
In recent years, MongoDB and PostgreSQL have gained popularity, representing the NoSQL and SQL camps,...
Dev.to · Franck Pachot
10mo ago
Search Index for Reporting
In the first post of this series, I've imported a sample dataset, and I'll show how adding a few...
Dev.to · Franck Pachot
10mo ago
Sampling Without Index
I won't create any indexes for this post yet, but I can still filter efficiently to run a query in...
Dev.to · Franck Pachot
10mo ago
Indexing for New Use Cases Within the MongoDB Document Model (tutorial)
When designing a schema for MongoDB, it’s crucial to understand your domain access patterns. The...
Dev.to · Franck Pachot
11mo 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...
Dev.to · Franck Pachot
11mo ago
Amazon DocumentDB and multi-key indexing
In previous posts, I discussed the limitations of MongoDB emulations on databases like Oracle and...
Dev.to · Franck Pachot
11mo ago
Amazon DocumentDB != Microsoft DocumentDB extension for PostgreSQL
My next post will be about Amazon DocumentDB and how it compares to MongoDB in terms of indexing a...
Dev.to · Franck Pachot
11mo ago
Querying embedded arrays in JSON (PostgreSQL JSONB and MongoDB documents)
When working with document-based data structures, the fields at the root can be indexed using simple...
Dev.to · Franck Pachot
1y ago
MongoDB With Search Indexes Queried as Kimball's Star Schema With Facts and Dimensions
Export From SQL to CSV Import to MongoDB Indexing the Star Schema Querying the Star Schema - Star...
Dev.to · Franck Pachot
1y ago
Oracle Multi-Value Index and ORDER BY Pagination queries
In the previous post, I highlighted a case where relational SQL databases struggle with optimizing...
Dev.to · Franck Pachot
1y ago
Where SQL joins struggle but MongoDB documents shine
Claims such as "Joins are slow" or "Joins don't scale" often prompt me to showcase how efficiently...
Dev.to · Franck Pachot
1y ago
Foreign Keys: A must in SQL, but not in a Document Database?
In relational SQL databases, foreign keys are essential for guaranteeing referential integrity. There...
Dev.to · Franck Pachot
1y ago
MongoDB Vector Search Index, With Local Atlas and Ollama
For this demo, I'm using the Eurovision songs available at Kaggle, which contain lyrics in their...
DeepCamp AI