Why schema drift goes undetected
Here is a scenario from a project in its third year of operation. Migrations are managed properly. CI is green. validate passes. Then an error shows u…
Latest Web news from Tech News
All topics
AI
agents
ai
api
architecture
automation
beginners
career
claude
database
devchallenge
devops
discuss
javascript
linux
llm
machinelearning
mcp
opensource
performance
productivity
programming
python
react
security
showdev
testing
tutorial
typescript
webdev
A database failover can preserve uptime and break the answer
A PostgreSQL MCP server can remain available during failover and still return the wrong answer. The connection retries against a replica. The replica …
Why I Kept Search Scope Inside a Single Supabase RPC
A retrieval system returned the right embedding, the right similarity score, and a completely wrong answer. The chunk it surfaced shared vocabulary, n…
How Routing Reads to Replicas Took Our Primary From 90% CPU to 20%
For most of a year, every query our application made — reads and writes alike — went to the same primary Postgres instance. It worked fine until it di…
Following ROWIDs Through an Oracle Unique Index Update
I've always been amazed by how Oracle Database handles updates to a unique column—performing set-based operations that don't violate the unique constr…
Designing an Idempotent Transaction API: Preventing Duplicate Financial Operations
In financial backend systems, network retries represent a classic race-condition vector. If a client attempts to post a transaction, suffers a TCP tim…
Postgres RLS multi-tenancy: two traps that silently disable your policies
Most multi-tenant applications keep tenants apart with one line of code, repeated forever: SELECT * FROM documents WHERE organization_id = $ 1 That li…
Defeating the Multi-Tenant SaaS Concurrency Trap in PostgreSQL
Most backend engineers implement multi-tenant quota checks using a standard "read-then-write" pattern. In production, this pattern is highly unsafe: S…
A Practical Guide to Azure PostgreSQL: Migration, Replicas, and Tuning ☁️🐘
In this post, I summarize my hands-on experience completing the Microsoft Applied Skills: Configure and migrate to Azure Database for PostgreSQL asses…
Running Postgres at Scale: Lessons Learned
We run Postgres for a product with millions of users. Along the way I've broken it in every possible way. Here are the lessons I wish I'd known on day…
You Might Not Need Kafka: Building a Job Queue with PostgreSQL
It's easy to reach for the popular tool before asking what your system actually needs. For job queueing, the usual advice is to use RabbitMQ or Kafka.…
How I Built a Free AI Prompt Library With Node.js and PostgreSQL — From Zero to Live in 30 Days
If you have been following my Dev.to articles, you know I built Chatzyo — a real-time video chat platform using WebRTC. That project taught me a lot a…
[Перевод] Натуральные ключи в БД. Последний раз объясняю
Всем привет! На связи Михаил Поливаха, технический лидер проекта Axelix . Я уже выпускал статью по мотивам вопросов в рамках Spring Айо Академии. Так …
Audit Logs You Can Trust
In Structured Logging for Node.js , I covered how to turn scattered console.log calls into structured, queryable events. That solves the "what happene…
Disaster Recovery and Backups
In the last article , I walked through what changes when a SaaS grows past a single server: load balancers, stateless app instances, a database that s…
Multi-Tenancy Architecture for SaaS
In Organizations, Teams, and Invitations we got people into the right organization: memberships, roles, invite flows, all the plumbing that decides wh…
Organizations, Teams, and Invitations
In Subscription Billing and Plans we wired up the part of the product that collects money. This article covers the part that gets people into the prod…
Performance Tuning Before Launch
In A Production Security Checklist , I walked through what to lock down before opening the doors to real users. Security is a pass/fail gate: you eith…
Introducing tinbase — local Supabase without Docker (one process, real Postgres)
Supabase local dev = a 12-container, 2.3 GB Docker stack. tinbase serves the same APIs from one 58 MB process . No Docker. It's real Postgres 17 — RLS…
The Postgres migration that locks your table at 3am, and how to catch it in review
-- looks fine in review, locks your busiest table in prod: ALTER TABLE users ALTER COLUMN email SET NOT NULL ; -- same result, no outage: ALTER TABLE …
Comparing Staging and Production Database Schemas Side by Side
Disclosure: I build Schemity , a desktop ERD tool - this post is from our blog and uses it for the examples. TL;DR: Every environment runs a slightly …
Build a Feedback Channel That Does Not Become Another Abandoned Inbox
A feedback button is easy to ship. A feedback system is harder. The difference is not the input form. It is what happens after someone presses Send : …
NocoBase and the mystery of the shifted timestamps: MySQL vs PostgreSQL, measured
There's a class of bug reports that keeps coming back in the NocoBase community, especially in the Chinese-language forum: "all my times are off by 8 …
SQL for Beginners: Building a Mini School Database from Scratch!
SQL for Beginners: Building a Mini School Database from Scratch If you're learning SQL, the fastest way to make it stick is to build something real no…
From Joins to Graph Edges: SQL/PGQ in PostgreSQL 19
In the previous post, Cypher graph queries on PostgreSQL with Apache AGE , I showed how to model and query a property graph in PostgreSQL using Apache…
Catch the dangerous Postgres migration at the CI step
-- looks routine in review, locks your table in production: CREATE INDEX idx_orders_customer ON orders ( customer_id ); ALTER TABLE users ALTER COLUMN…
Read-only Postgres access can still take down your application
An MCP server for Postgres can be read-only and still hurt production. Exploratory joins, wide aggregates, synchronized schedules, and concurrent retr…
Running PostgreSQL with Docker
Installing Postgres directly on your machine works, but it gets messy fast once you're juggling multiple projects that each want different versions, e…
GORM: Dev's Guide to Go's Most Popular ORM
If you're working with Go services that talk to a relational database, chances are you've bumped into GORM . It's the most widely used ORM in the Go e…
How to Check Supabase Row Level Security Holes (Free SQL Audit)
Row level security in Supabase fails quietly. There is no crash, no red error banner, nothing in your logs that says "this table is wide open." The ap…