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.
ORA-04068 After a Deploy: The Retry Works. The Package State Is Gone.

ORA-04068 After a Deploy: The Retry Works. The Package State Is Gone.

Comments
12 min read
A Practical OLAP Walkthrough with DuckDB: Star Schema, Rollups, and Drill-Down

A Practical OLAP Walkthrough with DuckDB: Star Schema, Rollups, and Drill-Down

Comments
4 min read
9 PostgreSQL fixes that took real queries from ~100 ms to under 1 ms (with EXPLAIN output)

9 PostgreSQL fixes that took real queries from ~100 ms to under 1 ms (with EXPLAIN output)

1
Comments
4 min read
Building a Zero-AWS Power Grid OLAP Explorer in the Browser with DuckDB-Wasm and Apache Parquet

Building a Zero-AWS Power Grid OLAP Explorer in the Browser with DuckDB-Wasm and Apache Parquet

Comments
5 min read
How to get a data analyst internship

How to get a data analyst internship

Comments 1
3 min read
Spurious Tuples: How to Mathematically Prove Lossless Join Decomposition

Spurious Tuples: How to Mathematically Prove Lossless Join Decomposition

Comments
2 min read
MySQL utf8mb3 to utf8mb4: What CONVERT TO CHARACTER SET Locks, Refuses and Silently Changes

MySQL utf8mb3 to utf8mb4: What CONVERT TO CHARACTER SET Locks, Refuses and Silently Changes

Comments
11 min read
Case-Insensitive Email in PostgreSQL: citext, a lower() Index, or a Nondeterministic Collation?

Case-Insensitive Email in PostgreSQL: citext, a lower() Index, or a Nondeterministic Collation?

Comments
8 min read
ClickHouse IP Geolocation for Billions of Log Rows

ClickHouse IP Geolocation for Billions of Log Rows

Comments
18 min read
Same Row Count, Missing Records: 4 Ways a Count Check Can Fool You

Same Row Count, Missing Records: 4 Ways a Count Check Can Fool You

Comments
3 min read
Typed raw SQL for Effect

Typed raw SQL for Effect

Comments
2 min read
DP-900 Study Guide: Azure Data Fundamentals in Plain English

DP-900 Study Guide: Azure Data Fundamentals in Plain English

Comments
3 min read
SQL Window Functions Explained (with Examples You Can Run)

SQL Window Functions Explained (with Examples You Can Run)

Comments
4 min read
Aynı bakiyeden iki kez harcama nasıl önlenir?

Aynı bakiyeden iki kez harcama nasıl önlenir?

Comments
8 min read
The SQL Checks I Run Before I Trust a Dataset

The SQL Checks I Run Before I Trust a Dataset

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