Browsing Tag
postgres
74 posts
How I Put PgCache in Front of a 16-Million-Row Postgres Database
Disclaimer: This is a side project, not a production story. The slow-query problem is real, but the database…
Buying a phone number is a distributed transaction
The API makes it look trivial. const number = await carrier.numbers.buy({ phone_number: "+1..." }); await db.insert("rented_numbers", { user_id,…
Change Data Capture in 2026: Supabase Webhooks, Prisma Pulse, and the “Thundering Herd” Problem
async database processing background job processing bulk update webhooks cdc webhooks change data capture database automation database cdc…
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…
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…
Debugging PostgreSQL Performance
Let’s chat about performance, optimization, and debugging a PostgreSQL database. Can you read EXPLAIN ANALYZE output fluently? Do…
Alter Queries
In this assignment, I worked on modifying existing tables using ALTER TABLE. This helped me understand how to…
How I Structured User Data for My AI SaaS
Most developers building their first SaaS make the same mistake I almost made — they reach for sessionStorage…
