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.
Round-Tripping TPC-DS and a Snowflake Feature Schema Through a Database Diagram: What Snowflake Lost and What We Fixed

Round-Tripping TPC-DS and a Snowflake Feature Schema Through a Database Diagram: What Snowflake Lost and What We Fixed

Comments
13 min read
SQL Joins, CTEs, Subqueries, and Window Functions: A Practical Guide

SQL Joins, CTEs, Subqueries, and Window Functions: A Practical Guide

Comments
8 min read
SQLazy: Find Strings with 5 or More Consecutive Alphabetical Letters

SQLazy: Find Strings with 5 or More Consecutive Alphabetical Letters

5
Comments
4 min read
Setting Up PostgreSQL in VS Code — From Download to Your First Query (Plus Password Rescue)

Setting Up PostgreSQL in VS Code — From Download to Your First Query (Plus Password Rescue)

1
Comments
6 min read
How to Audit Contact–Account Parents After a Salesforce Migration with SOQL

How to Audit Contact–Account Parents After a Salesforce Migration with SOQL

Comments
6 min read
Temperature 0 or Five Samples? A Debate Over Reproducible Agent SQL Drafts

Temperature 0 or Five Samples? A Debate Over Reproducible Agent SQL Drafts

Comments
5 min read
$5,200 of BigQuery, and three queries caused 71 percent of it

$5,200 of BigQuery, and three queries caused 71 percent of it

Comments
2 min read
Working with sequence files in BioseqDB and SeqKit

Working with sequence files in BioseqDB and SeqKit

Comments
22 min read
CVE-2026-76461: SQL Injection in an Email Gateway, Root on the Appliance

CVE-2026-76461: SQL Injection in an Email Gateway, Root on the Appliance

Comments
3 min read
Migrations turn code itself into state

Migrations turn code itself into state

1
Comments
5 min read
JOINS, WINDOW FUNCTIONS, CTEs AND SUBQUERIES

JOINS, WINDOW FUNCTIONS, CTEs AND SUBQUERIES

Comments
8 min read
schemagate tops BIRD Mini-Dev in SQLite, PostgreSQL and MySQL

schemagate tops BIRD Mini-Dev in SQLite, PostgreSQL and MySQL

Comments
2 min read
SQL Concepts: Window Functions, Joins, CTEs and Subqueries

SQL Concepts: Window Functions, Joins, CTEs and Subqueries

1
Comments
14 min read
Window Functions, Joins, CTEs and Subqueries

Window Functions, Joins, CTEs and Subqueries

Comments
3 min read
Mastering Intermediate & Advanced SQL: A Practical Healthcare Analytics Guide

Mastering Intermediate & Advanced SQL: A Practical Healthcare Analytics Guide

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