From Dev.to Community
Tech Articles
Curated developer articles, tutorials, and guides — auto-updated hourly
Ramkumar M NAug 24, 2026 • 6 min read
Teradata, Explained Like the Warehouse That Was There First
Every large, established company seems to have one: a big, powerful data system
#datawarehouse#dataengineering#sql#database
7 0
NuncAug 21, 2026 • 5 min read
Oracle Designer Lost Support in 2013. My AI Agent Develops in It Anyway.
Oracle Designer 10g is a CASE tool from the early 2000s. Support ended in 2013. At my job it is stil...
#ai#oracle#sql#showdev
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
Iliya.Faz6d ago • 7 min read
SQL Cheat sheet
Long story short, I came back after a long break from programming. Thought I should write this not.....
#beginners#database#sql#tutorial
1 0
Vivek KumarAug 20, 2026 • 6 min read
Read-Only by Design: Letting AI Explore Your Database Without the Risk of Writes
How to give AI assistants safe, read-only access to your SQL database — using database roles, read r...
#sql#database#ai#postgres
0 1
Son TranAug 21, 2026 • 7 min read
Column Comments in PostgreSQL and MySQL: How to Document Columns Without a Migration
A column comment costs a full migration cycle, and on MySQL it means restating the entire column def...
#database#documentation#sql#postgres
0 1
Morgan LiAug 24, 2026 • 4 min read
Synthetic Data Is the Missing Layer in Your SQL Eval Harness
Last spring, a colleague's team shipped an AI-generated query that accidentally exposed row-level...
#sql#ai#testing#dataprivacy
0 0
Tomas RavinskasAug 22, 2026 • 3 min read
Bringing Relational SQL Databases to the P2P World
Have you ever wanted to integrate full-text search (or to be more trendy, vector similarity search)....
#architecture#database#software#sql
0 0
Vlad (Volodymyr Shiyan)Aug 24, 2026 • 7 min read
Why I Chose SQLite Over PostgreSQL
Why I Chose SQLite Over PostgreSQL I chose SQLite over PostgreSQL because LockMargin is a desktop.....
#database#sql#privacy#localfirst
0 0
Shreyas SAug 21, 2026 • 2 min read
Why I Stopped Rushing to Machine Learning and Started with SQL Instead!
I've solved 15 of the 50 problems in LeetCode's SQL 50. I started my first end to end ML project...
#datascience#learning#machinelearning#sql
1 0
Derick LopesAug 20, 2026 • 5 min read
Building my first database with SQL: a library project
As a Computer Science student, one thing I've noticed is that learning a concept in theory is very.....
#sql#computerscience
0 0
Morgan Li6d ago • 4 min read
The Slow Query Sentinel: A Zero-Dollar Server That Explains Your Database's Worst SQL
Last Tuesday, a query that had been fast for months suddenly started eating CPU. The on-call enginee...
#sql#database#ai#python
0 0
Otwoma E.5d ago • 3 min read
Building a Sales Analytics Data Warehouse with PostgreSQL
Introduction Modern businesses generate large volumes of transactional data from systems...
#analytics#data#database#sql
0 0
Mr. S GuptaAug 20, 2026 • 5 min read
Is Supabase Actually a Database?
Is Supabase Actually a Database? Sorting Out Supabase, Firebase, Appwrite, PocketBase, and Neon For ...
#sql#supabase#appwritehack#webdev
0 0
Morgan Li5d ago • 6 min read
Free AI Compute for SQL Review: A Structured Debate and a Decision Rule
Last Thursday, a colleague approved a generated query that returned exactly the rows the ticket aske...
#ai#sql#testing#database
0 0
Morgan LiAug 21, 2026 • 3 min read
The Night an AI-Generated SQL Query Locked My Production Table
It was a Saturday evening, and I was confident. A new model had just dropped, and the leaderboard...
#sql#ai#database#testing
0 1
Prateek SrivastavaAug 23, 2026 • 6 min read
A Windows Service is Down. Now What?
It doesn't matter if it's SQL Server, IIS, a background agent, or a custom app — when a Windows...
#devops#microsoft#sql#sre
0 0
Deepesh DhakeAug 24, 2026 • 7 min read
Prove Your Backups Actually Restore Automatically, on a Separate Server
If you haven't done any restoration of your backups, you cannot count it as your retrieval strategy....
#automation#database#devops#sql
0 0
LukaszAug 22, 2026 • 5 min read
How I Built Memory for a Local AI Companion Without Sending Chats to a Server
A chatbot can sound convincing for five minutes without remembering anything. Then you mention the....
#ai#rust#sql#buildinpublic
0 0
jomynnAug 20, 2026 • 3 min read
We caught a SQL injection with an offline AI security scanner — here's the exact query it found
The bug Here's a login endpoint from a small Express demo...
#ai#javascript#security#sql
0 1
Frank @ Four-LeafAug 22, 2026 • 6 min read
A SQL interview is a translation test, not a syntax test
Canonical: this is a cross-post. The original lives at...
#sql#career#interview#database
0 0
Michael NocitoAug 21, 2026 • 6 min read
Which SQL Database Should You Install?
File-based engines like SQLite and DuckDB versus servers like PostgreSQL, MySQL and SQL Server. One ...
#sql#database#tutorial#beginners
0 0
Adolfo Pedernera6d ago • 9 min read
Web Performance on a Budget: Bundle Size, API Limits, and Database Indexes
The three budgets every web app hits: bundle size, API rate limits, and database index selectivity.....
#guide#webdev#api#sql
1 0
Michael NocitoAug 21, 2026 • 15 min read
Month-over-Month Growth in SQL: LAG, the Growth Formula, and the Traps
The MoM growth formula, LAG() in everyday words, and the trap where one skipped month makes SQL repo...
#sql#database#tutorial#beginners
0 0