From Dev.to Community
Tech Articles
Curated developer articles, tutorials, and guides — auto-updated hourly
Mohamed Aboelmagd6d ago • 8 min read
40001 is not a query error
The PostgreSQL manual is unusually direct about this: When an application receives this error...
#postgres#node#typescript#database
1 0
Kingsley Onoh2d ago • 7 min read
Why I Put Swarm Memory in PostgreSQL Instead of Zep
A completed simulation left me with a report and an ownership problem. MiroFish had built the graph,...
#postgres#pgvector#agentmemory#vectorsearch
0 0
Srdjan Popovic5d ago • 5 min read
A Shapefile Is Four Files, and the Important One Is Optional
A user clicks "upload" and picks a file. In most systems that sentence is the whole story. In a...
#python#gis#fastapi#postgres
0 0
Bashiru Bukari2d ago • 8 min read
CDC without Kafka: keeping Postgres, OpenSearch, and Redis in sync with one binary
Every time I needed to keep Postgres in sync with something else — a search index, a cache, or...
#postgres#rust#database#opensource
0 0
Srdjan PopovicAug 24, 2026 • 6 min read
One View Per Layer: Four Sharp Edges I Found in My Own Code
There is a layer in my database called 1. Somebody created it, presumably by accident, and it sat.....
#postgres#gis#django#webdev
0 0
Ahmed Mahmoud3d ago • 5 min read
Database Connections in Serverless: Field Notes on Pool Math, PgBouncer Transaction Mode, and the Singleton HMR Kept Recreating
Headline: A database connection pool in a serverless deployment is per-instance, not...
#postgres#serverless#node#webdev
1 0
Akkarapon Phikulsri3d ago • 8 min read
PostgreSQL Cheat Sheet: Investigating and Terminating Database Blocking Sessions
If you run PostgreSQL in production for a long time, you will probably see this problem at some...
#database#postgres
2 0
Mohibakhon2d ago • 5 min read
Your Supabase anon key can probably read your whole users table
Here is a Supabase row-level security policy. It was on a profiles table holding names, timezones an...
#supabase#postgres#security#webdev
0 0
Patu1d ago • 2 min read
Turn any SQL schema into an interactive ER diagram
Reading a database you did not design usually starts the same way: you open the schema, scroll...
#sql#database#postgres#tools
0 0
Guido3d ago • 3 min read
My security test was green for six weeks because it could not turn red
A Postgres operator resolution quirk meant every failure branch in my RLS test threw a type error in...
#postgres#testing#sql#security
0 0
Ehsan MahmoudiAug 24, 2026 • 4 min read
A Small Fintech Challenge, and Why I Let Postgres Hold the Money
I took a small fintech-style coding challenge — a marketplace where players buy and auction items wi...
#postgres#go#fintech#concurrency
0 0
Srdjan Popovic4d ago • 4 min read
One Gigabyte per Survey, of Which 108 KB Goes in the Database
Here is the disk layout of one mobile mapping survey — a vehicle with a LiDAR scanner and a panorami...
#gis#postgres#architecture#webdev
0 1
Jagdish Parihar4d ago • 12 min read
MVCC Explained: Build Postgres-Style Snapshots in 100 Lines of TypeScript
Open two psql sessions. Session A: BEGIN; DELETE FROM users; -- deletes all 1 million rows --.....
#postgres#database#systemdesign#typescript
0 0
Suraj Upadhyay3d ago • 4 min read
PostgreSQL Multi-Tenancy: Isolation That Survives a Growing Team
Startups building B2B products reach for multi-tenancy in PostgreSQL the same way on day one: one...
#postgres#database#backend#software
5 0
XNeuronal6d ago • 5 min read
I put reminders, contacts and recipes in the same Postgres table. Here is the SQL, and what it cost.
Every database course tells you to give each kind of thing its own table. Customers here, orders...
#postgres#database#architecture#ai
0 0
LibmeAug 24, 2026 • 7 min read
Why Your OAuth Integration Randomly Returns invalid_grant (and How to Stop Two Workers From Racing)
Concurrent workers refreshing a rotating OAuth refresh token cause invalid_grant and disconnected in...
#api#backend#security#postgres
0 0
Vivek Kumar6d ago • 7 min read
MCP vs. a Direct Database Connection: A Security and Workflow Comparison
When you connect an AI assistant to your database, you can hand it a connection string or put a brok...
#sql#database#ai#postgres
0 0
William Andrews5d ago • 8 min read
UUIDs explained — the uniqueness myth, the version you should be using, and the database mistake that slows everything down
What UUIDs actually guarantee, why v4 quietly hurts database performance at scale, the newer v7 stan...
#uuid#database#postgres#webdev
0 0
Humza Tareen6d ago • 5 min read
Building a Notification Service: Cloud Tasks Delivery, Circuit Breakers, and Webhook Dispatch
How I built a production notification service with Cloud Tasks for reliable delivery, circuit breake...
#cloudtasks#webhooks#fastapi#postgres
0 0
XNeuronal3d ago • 5 min read
We wrote a graph of edges for months and never traversed it. Here is the one-hop query, and why we stopped at one.
We had a neurons_edges table. It was filling up nicely. Every time the system noticed that two...
#postgres#database#architecture#ai
0 0
Todd Sullivan6d ago • 3 min read
The RLS Policy Was Correct. The Write Was Still Wrong.
The RLS Policy Was Correct. The Write Was Still Wrong. I spent a chunk of last week doing...
#security#supabase#postgres#devops
0 0
Arihant JainAug 24, 2026 • 5 min read
Redis Caching in NestJS: I Cut Database Calls by 60% in Production
Problem Statement On one of my freelance projects — a creative portfolio app — the...
#nextjs#redis#backend#postgres
0 0
VidhiDixit20004d ago • 3 min read
My app could read the database. pgAdmin couldn't. Both were pointing at "localhost:5432"
I was running a FastAPI app in Docker with a PostgreSQL container next to it. The app worked. It...
#docker#postgres#beginners#devops
0 0
Nur Zaman6d ago • 3 min read
Using an AST to validate AI-generated PostgreSQL before it runs
A practical approach to checking LLM-generated PostgreSQL with AST-based table, statement, and funct...
#postgres#ai#security#typescript
0 0