Optimistic concurrency is the whole design: event sourcing on Aurora DSQL
Quorum is an incident command plane built on Amazon Aurora DSQL. The failover story lives in another post. This one is about a narrower question that …
DevOps
⚑ Report a ProblemLatest DevOps news from Tech News
All topics
agents
ai
api
architecture
automation
aws
beginners
career
cloud
database
devchallenge
devops
docker
gemma
javascript
kubernetes
llm
machinelearning
mcp
opensource
performance
productivity
programming
python
security
showdev
softwareengineering
tutorial
typescript
webdev
The Deep Mechanics of Online Bulk Deletion in PostgreSQL
MVCC, WAL, vacuum, and replication slots under sustained delete load - and how to delete billions of rows without your database noticing Most "how to …
Three PostgreSQL Master/Replica Discovery Problems — and How to Solve Them
When an application starts using multiple PostgreSQL hosts, the headaches begin: you need to dynamically find the master after a failover, pick a repl…
PostgreSQL 22P01 Error: Causes and Solutions Complete Guide
PostgreSQL Error 22P01: Floating Point Exception PostgreSQL error code 22P01 is raised when a floating-point operation produces an exceptional result …
I Built a Search Engine That Understands Meaning — in ~150 Lines, Zero API Keys
Type "animals that live in the ocean" into a normal search box and it hunts for the words animals , live , ocean . An article titled "Blue whale" that…
"Confluence Docs Lie. Tie Your Documentation to Code Instead."
Every team has that Confluence page. The one that was carefully written to explain what the service does, what the API looks like, what each DB column…
Why my first RAG layer starts in Postgres, not in a standalone vector database
When people say they are "adding RAG" to a workflow, the conversation often jumps too quickly to infrastructure choices. Should this use a vector data…
How I built a flash-sale engine that can't oversell
I created this piece of content for the purpose of entering the H0: Hack the Zero Stack hackathon. #H0Hackathon The problem (that's harder than it sou…
Designing an Expiring-Points System on an RDBMS (with Benchmarks)
This is an English rewrite of an article I originally published in Japanese. I've run the design on PostgreSQL 17 in Docker and folded the measured nu…
Linux Fundamentals for Data Engineering
Introduction As a data engineer, most of your work will happen on Linux servers. Whether you are managing databases, running data pipelines, or proces…
PostgreSQL 2200G Error: Causes and Solutions Complete Guide
PostgreSQL Error 2200G: Most Specific Type Mismatch PostgreSQL error code 2200G ( most_specific_type_mismatch ) is a SQL-standard data exception that …
Securing PostgreSQL, in the order an attacker would try things
Postgres has a well-earned reputation for security. Roles, privileges, host-based authentication, SCRAM. The primitives are all there, and they're goo…
Using TimescaleDB and Collectd for observability
I have used many timescale databases over the years and have found most to be wanting. Often over complicated and under performant. PostgreSQL with Ti…
Build a URL shortener with Fitz: HTTP + Postgres + auth in 30 minutes
A step-by-step tutorial through Fitz. We start from fitz new , finish with a native binary running in Docker. No external dependencies. No pip install…
Self-Host Postgres or Use Supabase? Here's How to Decide
Short answer first: use Supabase if you want Postgres plus auth, realtime, storage, and a dashboard as one managed bundle. Self-host Postgres – or use…
RAG with Postgres pgvector in 2026: the full TypeScript pipeline.
RAG with Postgres pgvector in 2026: the full TypeScript pipeline. I spent a week evaluating dedicated vector databases before deciding to just use the…
Extended RUM in DocumentDB extension for PostgreSQL: Efficient ESR (Equality, Sort, Range) Queries
Last year, I examined RUM indexes within this series on multi-key indexing, demonstrating that they cannot substitute MongoDB's compound indexes for s…
Database Index Anatomy: Performance and Resource Management
Database Index Anatomy: Performance and Resource Management While developing a production ERP, when I saw query times suddenly double, I realized that…
Supabase basics with Node.js
Supabase is an open-source backend platform built around managed PostgreSQL. You get a database, auto-generated REST APIs (via PostgREST ), Auth, file…
How to Choose Database Indexes in 3 Steps
Database index selection, in my nearly 20 years of experience, has often been a critical topic that is either overlooked or misunderstood. Many develo…
ParadeDB NPM Package Seeks Feedback on Simplifying Postgres Integration with JavaScript via Drizzle ORM
Introduction: Bridging the Gap Between Postgres and JavaScript with ParadeDB The ParadeDB NPM package emerges as a targeted solution to a growing pain…
I got tired of writing the same history table boilerplate, so I built a Postgres extension
There's this problem I kept running into - first during my internship, then again on a freelance project I picked up afterward. Both of them used Post…
Getting Started with pg_durable: Durable Workflows Inside PostgreSQL
Modern applications demand long‑lasting workflows that can withstand crashes, restarts, and failures, often relying on external platforms. pg_durable …
Durable Workflows on Postgres: What "You Don't Need Temporal" Actually Buys You
A DBOS blog post titled "Postgres is all you need for durable execution" reached the Hacker News front page this week (306 points, 132 comments). The …
How I Cut 769 Database Queries With One Window Function
From Grafana to Real Performance Gains I noticed in the Grafana dashboard that GET /api/v1/dokter/public/jadwal-dokter was on average taking 1 second …
PostgreSQL Connection Pooling in FastAPI: PgBouncer vs. SQLAlchemy QueuePool vs. Render's Native Pools
PostgreSQL Connection Pooling in FastAPI: PgBouncer vs. SQLAlchemy QueuePool vs. Render's Native Pools Connection pooling sounds boring until your Saa…
Building LifeFast: A Solo Founder's Deep Dive into Fasting App Architecture
There's a specific kind of frustration that comes from using a health app that feels like it was built by engineers who've never actually used it. The…
PostgreSQL Connection Pooling Explained: How It Works and Why It Matters
Opening a new database connection for every query is one of the most expensive things your backend can do. Connection pooling is how you stop doing th…
PostgreSQL for Data Engineers: Indexes, Bulk Loads, and the Patterns That Actually Matter
The LedgerSync pipeline was inserting 1.5 million rows into PostgreSQL using pandas.to_sql() . It took four minutes per run. I switched to psycopg2's …
I built DBeast: a PostgreSQL MCP server that gives AI assistants DBA-level tools
AI assistants can write SQL. But writing SQL is only a small part of working with a real database. Most database work is investigation: What tables ex…