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.
SQL in Depth: Interactive WASM SQLite 3 Workbench & Database Internals from First Principles

SQL in Depth: Interactive WASM SQLite 3 Workbench & Database Internals from First Principles

Comments
1 min read
The same query went from 0.07 ms to 151 ms on its 6th run, because Postgres switched to a generic plan

The same query went from 0.07 ms to 151 ms on its 6th run, because Postgres switched to a generic plan

Comments
4 min read
I Built 3 Free, Open-Source Interactive Textbooks for System Design, SQL, and DSA

I Built 3 Free, Open-Source Interactive Textbooks for System Design, SQL, and DSA

Comments
2 min read
PostgreSQL 19:用 WAIT FOR LSN 实现“读己之写”

PostgreSQL 19:用 WAIT FOR LSN 实现“读己之写”

Comments
1 min read
5 SQL traps that sink data engineering interviews (with runnable examples)

5 SQL traps that sink data engineering interviews (with runnable examples)

Comments
2 min read
UPDATE without WHERE: what MySQL's safe-updates mode stops, and what it lets through

UPDATE without WHERE: what MySQL's safe-updates mode stops, and what it lets through

Comments
6 min read
Snowflake vs BigQuery vs Redshift vs Databricks: Start With How You're Billed

Snowflake vs BigQuery vs Redshift vs Databricks: Start With How You're Billed

Comments
3 min read
Leaving Oracle: the licence is the easy part

Leaving Oracle: the licence is the easy part

Comments
3 min read
What Is an AI Agent, and How Often Is It Right

What Is an AI Agent, and How Often Is It Right

Comments
4 min read
PostgreSQL 19: Exporting Data in JSON Format Using COPY TO

PostgreSQL 19: Exporting Data in JSON Format Using COPY TO

Comments
6 min read
Google Maps timezone lookups in Python: measure match displacement

Google Maps timezone lookups in Python: measure match displacement

Comments
6 min read
Corners and Yellow Cards per Match by League: One Match Table, SQL and pandas, 2025/26 vs 2026/27

Corners and Yellow Cards per Match by League: One Match Table, SQL and pandas, 2025/26 vs 2026/27

Comments
3 min read
Make CI catch a SQL migration that changed after review

Make CI catch a SQL migration that changed after review

7
Comments
1 min read
How to Delete or Update Millions of Rows in SQL Server Safely (Batching)

How to Delete or Update Millions of Rows in SQL Server Safely (Batching)

Comments
4 min read
SQL Running Total: Calculate Cumulative Daily Sales Using SUM() OVER() in Oracle SQL

SQL Running Total: Calculate Cumulative Daily Sales Using SUM() OVER() in Oracle SQL

Comments
2 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.