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...
$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...
$lookup: more than just a SQL join (understand performance)
When transitioning from a SQL background to MongoDB, the $lookup operation in an aggregation pipeline...
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...
Isolation Level for MongoDB Multi-Document Transactions (Strong Consistency)
Many outdated or imprecise claims about transaction isolation levels in MongoDB persist. These claims...
MongoDB equivalent for PostgreSQL JSONB operations
This article examines PostgreSQL operations that benefit from GIN indexes, as listed in Built-in GIN...
$graphLookup (Connect By / Recursive Query)
In this series, I present various access patterns for a specific document model. These patterns are...
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...
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...
How to Implement Document Detection in Python Using Dynamsoft Capture Vision SDK
Document detection is a key feature in many modern desktop, mobile and web applications. Recently,...
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...
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...
"Schema Later" considered harmful 👉🏻 schema validation (enforced data consistency)
In a blog post titled "Schema Later" Considered Harmful on EDB's site, Michael Stonebraker...
Sort on Array with Multi-Key Index
In the previous post, we discussed how MongoDB indexes retrieve documents ordered by a specific...
Embracing Documentation as Code with GitLab: A Modern Approach to Team Collaboration
In the evolving world of software development, teams are constantly seeking more efficient ways to...
AI Legal Document Analysis: Revolutionizing the Legal Industry
The legal industry is witnessing a transformative shift, driven by the adoption of AI Legal Document...
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...
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...
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....
.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...
Top Intelligent Document Processing Software for 2024
In today’s digital age, Intelligent Document Processing (IDP) is crucial for enhancing business...
Wildcard Indexes: MongoDB flexibility joins query performance
In SQL databases, we sometimes encounter an Entity-Attribute-Value (EAV) model to work around the...
Joining and grouping on array fields in MongoDB may require using $unwind before applying $group or $lookup
Working with nested data in MongoDB simplifies mapping between application objects and database...