From Dev.to Community
Tech Articles
Curated developer articles, tutorials, and guides — auto-updated hourly
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
Rick Houlihan5d ago • 54 min read
Oracle SQL/JSON: The Developer's Guide to Querying JSON Like a Pro
Oracle SQL/JSON: The Developer's Guide to Querying JSON Like a Pro SQL and JSON aren't...
#database#sql#tutorial
2 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
Ahmad Fauzan Alghifari17h ago • 3 min read
The latest() Bug That Silently Duplicated Transaction IDs in Production
TL;DR: Using Model::latest()->first() to get the "latest" record by ID is wrong. latest() orders....
#timestamp#laravel#backend#sql
0 0
SEN LLC5d ago • 7 min read
Writing a Safe SQL INSERT Generator Taught Me Why ORMs Exist
Writing a Safe SQL INSERT Generator Taught Me Why ORMs Exist Every engineer writes a CSV...
#php#sql#cli#tutorial
0 0
Sourav Roy5d ago • 5 min read
Building a Vectorized SQL Engine from Scratch in C++ — No Dependencies
Building a Vectorized SQL Engine from Scratch in C++ — No Dependencies I built an embedded...
#cpp#database#sql#programming
1 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
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
Lokesh Vangari3d ago • 2 min read
🚨 When autocommit = false Caused Hidden Table Locks in SQL Server (pymssql + AWS Batch)
While moving a workload from server to AWS Batch (Python), we hit a strange issue: Some SQL jobs.....
#sql#pymssql
0 0
SysLayer4d ago • 3 min read
Coding Cat Oran Ep3, Five Tables Changed Everything
Oran spent two weeks doing something that felt like not working. He sat with the warehouse team...
#sql#systemdesign#programming#backend
0 0
Pawan Singh Kapkoti2d ago • 3 min read
Published a SQL Linter to PyPI Because I Was Tired of Bad Queries Hitting Production
Food manufacturing ERPs run on SQL Server. SSRS reports, stored procedures, ad-hoc queries — often.....
#sql#ai#devops#python
0 0
Braeson Nyahera1d ago • 3 min read
Sub-queries vs Window Functions vs Common Table Expressions: Which Should You Use in SQL?
SQL is the most used tool for data manipulation but what happens when there are some concepts that....
#sql#data#postgres#analytics
1 0
Brian MuriithiApr 13, 2026 • 6 min read
Introduction to Databases with SQL
A hands-on walkthrough of DDL, DML, DQL using a real school project I recently completed my first.....
#sql#data#database#postgres
2 0
Arnab Saha2d ago • 1 min read
A Curated LeetCode List for Full-Stack Developers
I built this list for myself while going through a full-stack web development journey and preparing....
#webdev#typescript#dsa#sql
1 0
Milcah Mukunza1d ago • 4 min read
Subqueries vs. CTEs: Choosing the Right Tool in SQL
INTRODUCTION As you advance beyond basic SQL queries, you’ll encounter scenarios where a...
#sql#subquery#datascience#analytics
1 0
Kanishka Shrivastava5d ago • 2 min read
#beginners #sql #machinelearning #100daysofcode
Apr 15, 2026 · Day 4 of 30 Day 4: I wrote my first SQL queries today and suddenly data feels a lot....
#beginners#database#machinelearning#sql
0 0
Rost3d ago • 9 min read
PostgreSQL Full Text Search vs Elasticsearch Comparison
The real argument is not whether PostgreSQL can search text or whether Elasticsearch can store...
#postgres#architecture#database#sql
0 0
Wahu Elizabeth6d ago • 3 min read
From Scratch to Queries: Building a School Database with SQL – My Nairobi Academy Project.
Transitioning from viewing data as simple lists to managing it within a relational database is a...
#sql#luxdev#beginners
1 0
Abdi Yussuf21h ago • 2 min read
Stop Collapsing Your Data: Why Window Functions Are a Game Changer
If you've been learning SQL for a few weeks, you're probably comfortable with GROUP BY. It's the...
#sql#data#analytics#analyst
1 0
Abdi Yussuf20h ago • 2 min read
SQL Deep Dive: Subqueries vs. CTEs — Which One Should You Use?
When your data questions get harder, you need to perform calculations before you perform your final....
#beginners#database#sql#tutorial
0 0
Clara Morales5d ago • 3 min read
How Senior Data Analysts Keep Trading Platforms Like LomixOne Running Smoothly in Volatile Markets
Trading environments are unforgiving. One unexpected volatility spike, a liquidity crunch, or a...
#productivity#datascience#sql
0 0
Philip McClarence3d ago • 4 min read
PostgreSQL Transaction Isolation Levels Explained
PostgreSQL Transaction Isolation Levels Explained If you've ever had a subtle data...
#database#postgres#sql#tutorial
1 0
soy2d ago • 3 min read
DuckDB Extensions in C#, Production DuckLake, & pgvector Performance Insights
DuckDB Extensions in C#, Production DuckLake, & pgvector Performance Insights ...
#database#sql#sqlite
0 0
Vivek Kumar5d ago • 5 min read
SQL LIMIT and OFFSET: Paginate Your Query Results Like a Pro
Learn how SQL LIMIT and OFFSET work together to paginate query results, with practical examples for ...
#sql#database#beginners#tutorial
0 0