From Dev.to Community
Tech Articles
Curated developer articles, tutorials, and guides — auto-updated hourly
GDS K S1d ago • 10 min read
The 8 tables behind a real auth system (Postgres schema, explained column by column)
Day 2 of the auth from scratch series. The full Postgres schema for users, sessions, OAuth, reset to...
#postgres#authentication#database#webdev
3 0
Rohith Gilla6d ago • 5 min read
Debugging Postgres LISTEN/NOTIFY Is Finally Pleasant
I have written the same 40-line Node script to debug a Postgres LISTEN channel at least six times......
#postgres#realtime#node#tutorial
0 0
Rohith Gilla5d ago • 6 min read
Stop Pasting \timing — Run Your SQL 100 Times and Get p99
Here is a trap I have fallen into more times than I can count. I write a query. I run it. It takes....
#postgres#performance#sql#database
0 0
Kalio Princewill3d ago • 24 min read
PostgreSQL Read Replicas with Docker: A Step-by-Step Guide
As your application scales, your database becomes the first bottleneck. Every dashboard query, every...
#postgres#distributedsystems#database
6 0
Juan Torchia3d ago • 8 min read
TigerFS: A Full Filesystem Inside PostgreSQL (And Why This Obsession Feels Like a Symptom)
Someone built a complete filesystem inside PostgreSQL. Last year I shoved Linux's entire git history...
#english#experiments#experimentos#postgres
0 0
Nikita Volkov6d ago • 4 min read
My 14-Year Journey Away from ORMs - How I Built pGenie, the SQL-First Postgres Code Generator
Story about how I went from shipping a popular ORM in 2012… to throwing it all away… to realizing th...
#postgres#java#rust#haskell
2 0
Olamilekan Lamidi4d ago • 9 min read
Database Optimization Strategies That Cut Query Execution Time by 60%: A Practical Guide
If your web application is slow, the database is almost certainly the bottleneck. Not the frontend.....
#database#postgres#mysql#performance
1 0
Pedro Parker3d ago • 4 min read
Busca fuzzy em 55 milhões de registros: como pg_trgm salvou meu projeto
Como implementei busca por nome em 55M+ empresas brasileiras com PostgreSQL pg_trgm, ILIKE e indexes...
#postgres#search#performance#database
2 0
Darryl Ruggles1d ago • 25 min read
Amazon Aurora DSQL: A Practical Guide to AWS's Distributed SQL Database
Architecture, features, Terraform setup, and real application code - April 2026 When AWS...
#aws#aurora#postgres#database
1 0
ayoabass7771d ago • 6 min read
# Building a Streaming Session Analytics Pipeline with Kafka, Postgres, and dbt
How I built an end-to-end clickstream pipeline with exactly-once delivery guarantees When I set....
#dataengineering#kafka#dbt#postgres
2 0
c-premus5d ago • 8 min read
Rewriting My MCP Server from PHP to Go
Why I rewrote a Laravel MCP server in Go: dropping Meilisearch for PostgreSQL FTS, hand-rolling OAut...
#go#mcp#architecture#postgres
1 0
Faizan Firdousi3d ago • 5 min read
I Tested PostgreSQL on 5 Million Rows, Here’s What Actually Makes Queries Fast
when you run a query on a large table in postgres, the performance difference is rarely about the...
#database#postgres#sql#distributedsystems
1 0
Alan West1d ago • 5 min read
How to Stop Nuking Your Postgres Data When Testing Schema Changes
Learn how copy-on-write database branching solves the pain of testing Postgres schema migrations, wi...
#postgres#database#devops#opensource
0 0
kanta13jp11d ago • 3 min read
6 Supabase RLS Patterns for Solo SaaS — auth.uid() and Beyond
6 Supabase RLS Patterns for Solo SaaS Why You Can't Skip RLS Supabase exposes...
#supabase#postgres#buildinpublic#security
0 0
VelkApr 13, 2026 • 5 min read
16GB of RAM, 12GB of JSON, and One Very Loud Fan
This is Part 1 of a 5-part series documenting the build of velktrails.com — a programmatic outdoor.....
#python#postgres#dataengineering#seo
0 0
Ahmad Fauzan Alghifari6d ago • 2 min read
How I Fixed a Correlated Subquery That Was Behaving Like an N+1 Problem in Production
What Happened A user reported seeing no data after an absurdly long loading time in one of...
#laravel#backend#sql#postgres
0 0
Daniel Popoola6d ago • 9 min read
Why Redis Cannot Share the Truth with Postgres - The architecture mistake that will oversell your tickets
There is a moment, somewhere in the design of almost every backend system that mixes Redis and...
#distributedsystems#softwareengineering#go#postgres
0 0
Marcc Atayde6d ago • 5 min read
Semantic Search in Laravel: Building a Vector-Powered Product Discovery Engine
If you've ever typed "cozy winter boots" into a search bar and gotten results for "thermal hiking...
#laravel#php#ai#postgres
0 0
Yanis Schweizer7h ago • 4 min read
Stop Benchmarking Embedding Models. 90% of Your Search Quality Lives Upstream.
Brief intro on context. I'm CTO at Vaultt (formerly StudentVenture), a recruitment marketplace for.....
#architecture#llm#postgres#rag
0 0
Peter Radilov6d ago • 9 min read
Why PostgreSQL Ignores Your Index
EXPLAIN costs demystified, bitmap scans, data correlation, covering indexes, GiST, GIN — all on 4 mi...
#postgres#database#sql#backend
0 0
Juan Torchia3d ago • 9 min read
I Dumped Linux's Entire Git History Into a Database — and What I Found Felt Like Archaeology
What happens when you stop treating your commit history like logs and start treating it like data. I...
#english#experiments#postgres#devtools
0 0
Meg528Apr 13, 2026 • 9 min read
Patterns for Postgres Traffic Control
By Josh Brown Last month we introduced Database Traffic Control™. Traffic Control lets you attach.....
#planetscale#postgres#webdev#programming
0 0
Asaduzzaman Pavel2d ago • 5 min read
TimescaleDB Continuous Aggregates: What I Got Wrong (and How to Fix It)
Continuous aggregates in TimescaleDB looked like a silver bullet for my crypto data performance prob...
#timescaledb#postgres#timeseries#database
0 0
Mateusz Woźniak9h ago • 3 min read
I built a self-hosted PostgreSQL Control Plane that runs on single Docker container
I built NeonD — an open-source, self-hosted control plane for PostgreSQL inspired by Neon. It gives ...
#database#postgres#selfhosted
0 0