From Dev.to Community
Tech Articles
Curated developer articles, tutorials, and guides � auto-updated hourly
Franck Pachot3d ago • 6 min read
The Autovacuum Scale Factor Problem at Scale - Know Your Defaults
In PostgreSQL, autovacuum and autoanalyze exist to clean up dead tuples (old versions of...
#postgres#sql#database#performane
1 2
Sireesha Chavvakula4d ago • 6 min read
I built a local Postgres triage co-pilot because HIPAA says I can't paste plans into ChatGPT or Claude
This is a submission for the Gemma 4 Challenge: Build with Gemma 4 What I Built I am a.....
#devchallenge#gemmachallenge#postgres#ai
1 2
Vadym Arnaut1d ago • 6 min read
There is no source language: a manifesto for symmetric multilingual content
Three weeks ago I shipped a bilingual LMS. The architecture modeled one language as source and the.....
#architecture#i18n#webdev#postgres
2 1
Vadym Arnaut1d ago • 2 min read
The auth_rls_initplan linter has a blind spot: SECURITY DEFINER bodies
If you've ever migrated a Supabase project to the wrapped (SELECT auth.uid()) pattern, you know the....
#supabase#postgres#webdev#database
3 0
ndmt1at213d ago • 7 min read
A Go outbox library that runs inside your own DB transaction
tickr is a Postgres-backed outbox + worker pool for Go. You enqueue messages in the same transaction...
#go#postgres#microservices#opensource
1 0
Pedro Santos3d ago • 4 min read
Similarity Search for Failure Diagnosis
Similarity Search for Failure Diagnosis In the previous post, I showed how every saga...
#java#ai#langchain4j#postgres
1 1
Jijo Bose3d ago • 11 min read
Building an Error Monitoring Tool Without Pricing Overages
The bill that arrives after the incident Picture the worst version of a Tuesday. You ship...
#postgres#rails#saas#monitoring
2 0
Do Pham Dinh5d ago • 7 min read
The race condition a stress test found in my double-entry ledger — and how I fixed it
A concurrency bug that lost 85% of balance updates under load, and the optimistic-locking + bounded-...
#java#springboot#postgres#concurrency
1 0
Ugur Aslim6d ago • 5 min read
Testing FastAPI + SQLAlchemy with Real PostgreSQL Fixtures: No More Mocking Misery
Use Docker and pytest fixtures to spin up isolated PostgreSQL databases for each test run, catching ...
#fastapi#sqlalchemy#postgres#testing
0 0
Dmitry Maranik3d ago • 4 min read
I Lint-Ran 4 Public Supabase Apps. They All Leak Rows.
I ran pgrls — an open-source Postgres Row-Level Security linter I maintain — against four...
#supabase#postgres#security#opensource
0 2
Eugene1d ago • 4 min read
🚀 I Built UUIDs That Look Random But Sort Like Timestamps (50% Smaller Indexes!)
How steganography solved the eternal UUID performance vs privacy dilemma in PostgreSQL
#postgres#uuid#database#performance
0 0
Yury3d ago • 7 min read
Transaction Hooks: A General Primitive for Post-Commit Side Effects (Case Study: Queuert)
The previous two posts in this series walked through how Queuert keeps job state atomic with your...
#node#opensource#prisma#postgres
0 0
JoongHyuk Shin4d ago • 9 min read
1.3.4 RETURNING Mapping and View-Target DML Transformation
The previous section (1.3.3) looked at the work the rewriter does to fill empty slots with values an...
#postgres#database#internals#views
0 0
Carlos Oliva Pascual3d ago • 2 min read
Zero-Downtime Database Migrations in Production (2026)
The expand-contract pattern, safe vs dangerous operations, and how to rename a column without breaki...
#postgres#database#nextjs#webdev
1 2
Chris23h ago • 4 min read
Your Team Doesn’t Need a Better AI Model This Week
The real upgrade is your workflow contract: permissions, durability, and handoffs. The...
#ai#workflows#agents#postgres
0 0
Harsh Kushwaha3d ago • 11 min read
Prisma-7 A Complete Beginners Guide (With Free Cloud Database!)
No prior database experience needed. This guide walks you through everything — what Prisma is, how.....
#ai#webdev#prisma#postgres
0 0
Rabinarayan Patra1d ago • 10 min read
How to Set Up an SSH Tunnel for Local Database Access
The single fastest way to wake up to a ransom note is to expose your Postgres port directly to the.....
#database#postgres#security#tutorial
0 0
Ashwin Sridhar11h ago • 4 min read
Does Postgres RLS actually ruin performance? Let’s look at the data.
There's a particular kind of conundrum that has derailed more architectural decisions than I care to...
#database#performance#postgres#rls
0 0
Jayanth5d ago • 2 min read
Multi-tenant PostgreSQL: row-level security vs schema-per-tenant & when to use which
If you're building a multi-tenant SaaS, this is the first real architecture decision that will haun...
#postgres#backend#sass#distributedsystems
0 0
MihaiBuilds1d ago • 7 min read
I built the memory, now I'm building the brain
Originally published on mihaibuilds.com. Cross-posting here because dev.to is where I read a lot of....
#opensource#python#postgres#showdev
0 0
The Hive Collective3d ago • 4 min read
Concurrent writes to a shared agent memory: what we shipped, what we punted on
A reader asked how a collective knowledge layer handles two agents writing the same key in the same ...
#ai#agents#opensource#postgres
0 1
SPANLENS2d ago • 7 min read
5 gotchas I hit moving LLM logs from Postgres to ClickHouse
The problem I am building Spanlens, an open-source LLM observability platform. Every call...
#clickhouse#opensource#typescript#postgres
0 0
JoongHyuk Shin8h ago • 3 min read
1.4 Planner: Which Path to Take
By the time 1.3 ends, the rewriter has let the Query tree through. Views have been expanded, RLS...
#postgres#database#internals#planner
0 0
Sysemperor1d ago • 4 min read
How to Correctly Read a PostgreSQL EXPLAIN ANALYZE Output
A slow query lands in your lap. You run EXPLAIN ANALYZE and get back a wall of indented text that...
#postgres#database#sql#performance
0 0