Browsing Tag
database
244 posts
Announcing General availability of the Azure Cosmos DB vNext emulator
Originally posted on https://devblogs.microsoft.com/cosmosdb/announcing-general-availability-of-the-azure-cosmos-db-vnext-emulator/ The Azure Cosmos DB vNext emulator is generally available today. It ships as a…
Vector Databases: Search by Meaning, at Scale
Embeddings turn meaning into vectors (last post). But if you have a million of them, how do you…
1.4.10 Planner Hook: When It Fires, How to Use It
Everything from 1.4.1 through 1.4.9 happened inside a single function, standard_planner(). Building paths, costing them, searching for a…
An Engineer’s Guide to DuckDB and Modern OLAP Databases
TL;DR Cloud warehouses are built for petabyte-scale enterprise needs, and for teams working with a few terabytes, they…
PostgreSQL 22036 Error: Causes and Solutions Complete Guide
PostgreSQL Error 22036: non numeric sql json item PostgreSQL error code 22036 (non numeric sql json item) occurs…
PostgreSQL 22027 Error: Causes and Solutions Complete Guide
PostgreSQL Error 22027: Trim Error — Causes, Fixes, and Prevention PostgreSQL error code 22027 (trim_error) occurs when the…
RUM—Storing More in the Index
This series of posts traces the evolution from GIN to RUM to Extended RUM, showing how a single…
I built a free SQL practice game where you work at a fictional Singapore bank
I’ve been frustrated with SQL learning resources for a while. Most are either: Dry reference docs Toy exercises…
Debugging PostgreSQL Performance
Let’s chat about performance, optimization, and debugging a PostgreSQL database. Can you read EXPLAIN ANALYZE output fluently? Do…
How to Evaluate Vector Databases in 2026
In 2026, a synthetic performance crisis challenges the vector database market. A GitHub search for “vector database benchmark”…