From Dev.to Community
Tech Articles
Curated developer articles, tutorials, and guides — auto-updated hourly
Franck PachotSep 16, 2026 • 16 min read
Learn PostgreSQL extensibility through a gloriously bad idea: MM/DD/YYYY native datatype and GiST index
This project teaches four of PostgreSQL's most powerful features by building something no sane perso...
#postgres#sql#database#extensions
2 0
Franck PachotSep 21, 2026 • 5 min read
EXPLAIN (ANALYZE, IO) in PostgreSQL 19
I'll be showcasing some exciting PostgreSQL work, featuring contributions from Microsoft engineers a...
#postgres#sql#database#storage
1 0
Sameer KhareSep 17, 2026 • 8 min read
Idempotent APIs Without Idempotency Tokens
A few years into working on a utility billing SaaS platform, I ended up owning a feature that sounds...
#java#database#api#sql
1 2
Ashish sinhaSep 23, 2026 • 2 min read
Same question, same database, two callers
Most text-to-SQL stacks send the model the whole schema and put the access check after the query is....
#ai#database#llm#sql
1 0
晖莫Sep 18, 2026 • 3 min read
SELECT * and INSERT ... SELECT Broke Production at 3am
A backfill migration used SELECT * and INSERT ... SELECT, so a column added six months later silentl...
#sql#migrations#ci#postgres
0 0
Mahmut GündüzalpSep 16, 2026 • 6 min read
Six Rows Deleted. Three Decrements Applied. No Error.
A multi-table UPDATE ... JOIN visits each target row at most once, no matter how many joined rows ma...
#mysql#sql#database#webdev
0 0
Ashish sinhaSep 23, 2026 • 5 min read
38% of an analyst's questions get "no records found" when the data is right there
Your text-to-SQL agent has a failure mode that logs nothing, alerts nothing, and returns a...
#sql#ai#database#security
0 0
RahmanSep 17, 2026 • 5 min read
Why I Put PostgreSQL in WebAssembly to Fix SQL Interview Prep
Most SQL practice platforms either suffer from 4-second container cold starts or fake Postgres with ...
#postgres#sql#webassembly#webdev
0 0
晖莫Sep 17, 2026 • 4 min read
Read Replicas Do Not Fix a Bad Query Plan
We added three read replicas to spread the load and made it worse. The same sequential scan now ran ...
#postgres#database#performance#sql
0 0
晖莫Sep 19, 2026 • 4 min read
A Nullable Column Cost Me Five Years of Branches
One nullable column, added to dodge a migration, ended up as a null check in every query, API respon...
#sql#schema#postgres#nulls
0 2
Thiago Longo MoraesSep 21, 2026 • 4 min read
Grading a wrong answer by how wrong it is: ICD-10 proximity scoring in Postgres
Most quiz apps have one bit of output: right or wrong. For a medical diagnosis game, one bit throws....
#postgres#sql#healthcare#supabase
0 0
hidetzuSep 17, 2026 • 6 min read
The Same Row Twice: Four Things Keyset Pagination Needs
Speed is OFFSET's second problem. The first is that page 2 can hand you a row you already read on...
#postgres#sql#api#database
0 0
DevUnionXSep 16, 2026 • 5 min read
5 Things AI Cannot Do at PostgreSQL
AI has become surprisingly good at PostgreSQL. Give it a schema and it can write a query in seconds....
#postgressql#sql#sqlserver#ai
6 0
zoro maSep 20, 2026 • 26 min read
When the Dialect IS the API: Reading Army and jOOQ Side by Side, Through PostgreSQL Source
Army (the subject of this article): https://github.com/PillArmy/army jOOQ (the comparison target):.....
#backend#database#java#sql
0 0
VishwamSep 19, 2026 • 9 min read
The Postgres job-claim query that silently claims the same job twice
The Postgres job-claim query that silently claims the same job twice A common way to claim...
#postgres#backend#database#sql
0 0
David MwandairoSep 21, 2026 • 8 min read
Subqueries and CTEs: Asking a Question Inside a Question
Some questions can't be answered in one pass. "Which hive produced the most honey?" needs the maximu...
#sql#database#tutorial#ctes
0 0
NelimaLSep 20, 2026 • 5 min read
Window Functions vs Aggregate Functions Made Easy
The first time in a SQL class, aggregate functions and window functions can seem confusing because.....
#database#learning#sql#tutorial
2 0
Daniel PertuSep 22, 2026 • 5 min read
Our product search only returns rows the scanner can actually answer for
Munchable answers a barcode. You point the phone at a pack, the rules engine checks the ingredient.....
#postgres#sql#database#webdev
0 0
joseph mwangiSep 20, 2026 • 11 min read
Window Functions vs Aggregate Functions in SQL: A Beginner-Friendly Guide
If you have written SQL for more than a week, you have used SUM(), AVG() or COUNT(). They are the...
#beginners#database#sql#tutorial
1 0
rose odiwuorSep 20, 2026 • 3 min read
When SQL Has Nothing to Say: Handling NULLs
In Part 1 of the NULL series, we focused on: what NULL represents in a dataset: a value that is...
#database#beginners#sql
2 2
abiud kipngetichSep 19, 2026 • 4 min read
Understanding SQL: A Practical Guide to Categories, Data Types, Joins, and Core Concepts
SQL (Structured Query Language) is the standard language for interacting with relational databases.....
#sql#database#programming#beginners
1 0
Josephine MackylahSep 16, 2026 • 2 min read
Building vs Running: A Simple Way to Understand DDL & DML.
Picture opening Sunrise Supermarket. Before you sell a single item, you build the shelves tables for...
#sql#beginners#basic
5 0
Remy SterlingSep 19, 2026 • 6 min read
Common SQL Injection Vulnerabilities in Student Projects and How to Prevent Them
Introduction A student project can work perfectly with friendly input and still be...
#sql#database
0 0
RahmanSep 19, 2026 • 3 min read
Meta's "Combined Reaction Volume" SQL Question, Explained Simply
A step-by-step walkthrough of Meta's SQL interview question about deduplicating reactions logged acr...
#sql#database#interview#tutorial
0 0