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.
Quick Overview of Relationship Schemas and Joins

Quick Overview of Relationship Schemas and Joins

Comments
4 min read
One query language for SQL, Mongo, and the browser: the case for Forge

One query language for SQL, Mongo, and the browser: the case for Forge

Comments
9 min read
Ad-Hoc Video Analytics with DuckDB on Parquet Exports from Production SQLite

Ad-Hoc Video Analytics with DuckDB on Parquet Exports from Production SQLite

Comments
10 min read
Our SQL Server loop kept writing the previous row's value

Our SQL Server loop kept writing the previous row's value

Comments
4 min read
SQL vs NoSQL Databases: Which One Should You Choose?

SQL vs NoSQL Databases: Which One Should You Choose?

5
Comments
5 min read
I Built a Chrome Extension - Sidekick

I Built a Chrome Extension - Sidekick

5
Comments
2 min read
Managing Database Migrations with Alembic

Managing Database Migrations with Alembic

Comments
2 min read
Data Migration, Conversion, and ETL — What I Actually Did, Across Two Eras

Data Migration, Conversion, and ETL — What I Actually Did, Across Two Eras

1
Comments
11 min read
Intuit OA 2026 Guide: Code, SQL & Bash Questions Explained

Intuit OA 2026 Guide: Code, SQL & Bash Questions Explained

2
Comments
4 min read
Manticore Search 28.6.6: UUID document IDs, ordered GROUP_CONCAT(), and 16 fixes

Manticore Search 28.6.6: UUID document IDs, ordered GROUP_CONCAT(), and 16 fixes

Comments
3 min read
Breaking the SQL Barrier: How to Build a Natural Language Database Assistant

Breaking the SQL Barrier: How to Build a Natural Language Database Assistant

1
Comments 2
2 min read
Migrating 200 Million Records in .NET without crashing production: From Row-by-Row to a Crash-Safe Batched Pipeline

Migrating 200 Million Records in .NET without crashing production: From Row-by-Row to a Crash-Safe Batched Pipeline

Comments
7 min read
SQL window functions: what separates a mid-level from a senior developer

SQL window functions: what separates a mid-level from a senior developer

Comments
5 min read
Deploying MySQL on RDS and Joining Tables Like It's Production

Deploying MySQL on RDS and Joining Tables Like It's Production

Comments
3 min read
Prompting AI for Complex Multi-Table SQL: A Practical Guide

Prompting AI for Complex Multi-Table SQL: A Practical Guide

1
Comments
5 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.