DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
Bypassing Gated Content with SQL: A Zero-Budget DevOps Solution

Bypassing Gated Content with SQL: A Zero-Budget DevOps Solution

Comments
3 min read
How B-Tree Indexes Work in SQL Databases: An Intuitive Guide

How B-Tree Indexes Work in SQL Databases: An Intuitive Guide

Comments 1
5 min read
Bancos de Dados Relacionais: A Estrutura que Sustenta Aplicações Modernas

Bancos de Dados Relacionais: A Estrutura que Sustenta Aplicações Modernas

Comments
3 min read
What is MySQL's Optimizer Trace? Why is it Essential for SQL Optimization?

What is MySQL's Optimizer Trace? Why is it Essential for SQL Optimization?

1
Comments
4 min read
I Eliminated SQLite Race Conditions in a Multi-Threaded Python App 🚀

I Eliminated SQLite Race Conditions in a Multi-Threaded Python App 🚀

Comments
3 min read
MySQL 8.0 vs 9.0: The Upgrade That Almost Broke Production

MySQL 8.0 vs 9.0: The Upgrade That Almost Broke Production

2
Comments
4 min read
Getting Started with SQL Server

Getting Started with SQL Server

Comments
4 min read
SQL Stored Procedures: From Hard‑Coded Logic to Reusable SQL

SQL Stored Procedures: From Hard‑Coded Logic to Reusable SQL

7
Comments
3 min read
Solving Geo-Blocked Feature Testing with SQL on a Zero Budget

Solving Geo-Blocked Feature Testing with SQL on a Zero Budget

Comments
3 min read
Goodbye NoSQL: Why I Migrated My Stack from Firebase to Supabase.

Goodbye NoSQL: Why I Migrated My Stack from Firebase to Supabase.

Comments
2 min read
Optimizing Test Account Management During High Traffic Events with SQL Security Techniques

Optimizing Test Account Management During High Traffic Events with SQL Security Techniques

Comments
3 min read
Database Fundamentals

Database Fundamentals

Comments
6 min read
The Dangerous Elegance of ActiveRecord::Store

The Dangerous Elegance of ActiveRecord::Store

Comments
3 min read
Testing Metadata Inconsistencies in InterSystems IRIS Using the DATATYPE_SAMPLE Database

Testing Metadata Inconsistencies in InterSystems IRIS Using the DATATYPE_SAMPLE Database

Comments
4 min read
Full-Text Indexing in MySQL: A Developer's Guide

Full-Text Indexing in MySQL: A Developer's Guide

Comments
7 min read
How to Create Indexes in MySQL: A Complete Guide

How to Create Indexes in MySQL: A Complete Guide

Comments
5 min read
Google BigQuery Cost Optimization: 7 Proven Strategies to Slash Your 2026 Cloud Bill

Google BigQuery Cost Optimization: 7 Proven Strategies to Slash Your 2026 Cloud Bill

5
Comments
3 min read
PostgreSQL RLS in Go: Architecting Secure Multi-tenancy

PostgreSQL RLS in Go: Architecting Secure Multi-tenancy

Comments
6 min read
The Object-Relational Impedance Mismatch: Why Your Java Objects and Database Tables Don't Play Nice

The Object-Relational Impedance Mismatch: Why Your Java Objects and Database Tables Don't Play Nice

Comments
4 min read
The Doctor's On-Call Shift solved with SQL Assertions

The Doctor's On-Call Shift solved with SQL Assertions

1
Comments 1
6 min read
Solving the N+1 Query Problem: A Developer's Guide to Database Performance

Solving the N+1 Query Problem: A Developer's Guide to Database Performance

1
Comments
7 min read
Stop hand-writing INSERTs: JSON SQL with dialect-aware output(Postgres/MySQL/SQLite)

Stop hand-writing INSERTs: JSON SQL with dialect-aware output(Postgres/MySQL/SQLite)

Comments
4 min read
Fix CORS, SQL Injection & MySQL Pooling in React + Node.js

Fix CORS, SQL Injection & MySQL Pooling in React + Node.js

2
Comments 2
7 min read
2026's First AI SQL Dataset: Ending the 'SELECT Only' Era

2026's First AI SQL Dataset: Ending the 'SELECT Only' Era

Comments
4 min read
Tu Nube como una Base de Datos: Guía Práctica de Steampipe para AWS

Tu Nube como una Base de Datos: Guía Práctica de Steampipe para AWS

Comments
4 min read
loading...