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...
$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 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...
$lookup: more than just a SQL join
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...
No HOT updates on JSONB (write amplification)
PostgreSQL's Multi-Version Concurrency Control (MVCC) works around the challenge of in-place updates...
One million $lookup challenge
I you have read my previous post $lookup: more than just a SQL join, you understand that $lookup is...
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...
JSONB DeTOASTing (read amplification)
PostgreSQL limits tuple sizes to a quarter of the block size, generally capping at 2KB. In document...
Isolation Level for MongoDB Multi-Document Transactions
Many outdated or imprecise claims about transaction isolation levels in MongoDB persist. These claims...
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...
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 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...
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...
AI Legal Document Analysis: Revolutionizing the Legal Industry
The legal industry is witnessing a transformative shift, driven by the adoption of AI Legal Document...
Sort on Array with Multi-Key Index
In the previous post, we discussed how MongoDB indexes retrieve documents ordered by a specific...
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....
Queries on JSON 👉🏻 compound indexes (Equality, Sort, Range)
In a blog post titled New Benchmarks Show Postgres Dominating MongoDB in Varied Workloads, EDB claims...
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...
"Schema Later" considered harmful 👉🏻 schema validation
In a blog post titled "Schema Later" Considered Harmful on EDB's site, Michael Stonebraker...
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...
Building a .NET TWAIN Document Scanner Application for Windows and macOS using MAUI
Dynamsoft used to offer both the .NET TWAIN SDK and the Dynamic Web TWAIN SDK. However, the .NET...
MegaParse: Your One-Stop Solution for Effortless Document Parsing
Quick Summary: 📝 MegaParse is an open-source, versatile parser designed for efficient and...
Microsoft CosmosDB: RUM instead of GIN but same limitations on JSON paths
Storing documents in PostgreSQL does not transform it to a document database. Embedded documents in...
Top Intelligent Document Processing Software for 2024
In today’s digital age, Intelligent Document Processing (IDP) is crucial for enhancing business...
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,...
Smart Document Translators That Actually Keep Your Layouts Intact
If you've ever translated a document packed with formatting—think footnotes, side-by-side columns,...
Improving your Physical Document Security: A Comprehensive Guide to Document Tracking Systems
A Document Tracking System is a solution designed to monitor the location, access history, and status...
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...