Articles by Tag #document
Browse our collection of articles on various topics related to IT technologies. Dive in and explore something new!
The World Is Too Messy for SQL to Work
Satya Nadella, Microsoft's CEO, discusses AI agents and quantum technology in an interview on the...
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...
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,...
Flush to disk on commit 👉🏻 MongoDB durable writes (ACID)
A Twitter (𝕏) thread was filled with misconceptions about MongoDB, spreading fear, uncertainty, and...
$lookup: more than just a SQL join (understand performance)
When transitioning from a SQL background to MongoDB, the $lookup operation in an aggregation pipeline...
$elemMatch and Multi-Key Indexes
In the previous post, I used the following index on the daily views data, which is an array of...
No HOT updates on JSONB (write amplification) performance impact
PostgreSQL's Multi-Version Concurrency Control (MVCC) works around the challenge of in-place updates...
AI vs Human: Which Is Better for Translating Technical Documents?
In 2025, with document translation tools evolving rapidly, the debate has sharpened—are AI...
JSONB DeTOASTing (read amplification) when using PostgreSQL as a Document Database
PostgreSQL limits tuple sizes to a quarter of the block size, generally capping at 2KB. In document...
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...
K-shot training with LLMs
I built a tool for teaching LLMs how to extract structured data from documents by annotating, not...
Isolation Level for MongoDB Multi-Document Transactions (Strong Consistency)
Many outdated or imprecise claims about transaction isolation levels in MongoDB persist. These claims...
$graphLookup (Connect By / Recursive Query)
In this series, I present various access patterns for a specific document model. These patterns are...
MongoDB equivalent for PostgreSQL JSONB operations
This article examines PostgreSQL operations that benefit from GIN indexes, as listed in Built-in GIN...
Translate Documents Without Losing Formatting: Popular Tools That Get It Right
When translating documents, it's easy to overlook something critical: formatting It’s one thing to...
Which AI Is Best for Document Translation in 2025? (Complete Breakdown for Real-World Use)
In 2025, translating documents and content across languages isn’t just a matter of accuracy — it’s...
MongoDB Arrays: Sort Order and Comparison
Arrays in MongoDB are ordered lists of values, and querying them can be confusing because a field...
What’s Actually Hard About Translating a Multilingual PDF? Let’s Break It Down
If you’ve ever tried translating a multilingual PDF using AI, CAT tools, or custom pipelines, you...
Why Translating Documents with AI Tools Is Now Better Than Ever (2025 Update)
In 2025, translating documents isn’t just faster — it’s smarter, cleaner, and layout-perfect. From...
Kreuzberg: Revolutionizing Document Intelligence in Python
Quick Summary: 📝 Kreuzberg is a Python document intelligence framework designed to extract...
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...
Sort on Array with Multi-Key Index
In the previous post, we discussed how MongoDB indexes retrieve documents ordered by a specific...
How I Use AI to Translate Multi-Language Docs: Tools, Steps & My Results
Multilingual documents are a reality in today's globalized workflows — from legal contracts in...
"Schema Later" considered harmful 👉🏻 schema validation (enforced data consistency)
In a blog post titled "Schema Later" Considered Harmful on EDB's site, Michael Stonebraker...
Dolphin: Effortlessly Parse Document Images!
Quick Summary: 📝 The Dolphin repository provides code and pre-trained models for document...
AI Legal Document Analysis: Revolutionizing the Legal Industry
The legal industry is witnessing a transformative shift, driven by the adoption of AI Legal Document...
Using Apple's Virtual Scanner to Test Document Scanning Apps and SDKs on macOS
Apple provided a sample project demonstrating how to create a virtual scanner device a long time ago....
How to Build a PWA Document Scanner: Capture, Edit and Upload as PDF
In many industries, a document scanner app is essential for capturing, editing, and uploading...
.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...
Kreuzberg: The Python Document Intelligence Framework That Will Blow Your Mind!
Quick Summary: 📝 Kreuzberg is a Python document intelligence framework designed to extract...