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.
Reverse-Engineering Messy Databases: My End-to-End Data Audits Across 17,000+ Relational Schema Logs

Reverse-Engineering Messy Databases: My End-to-End Data Audits Across 17,000+ Relational Schema Logs

1
Comments
4 min read
We caught a SQL injection with an offline AI security scanner — here's the exact query it found

We caught a SQL injection with an offline AI security scanner — here's the exact query it found

Comments 1
3 min read
Is Supabase Actually a Database?

Is Supabase Actually a Database?

Comments
5 min read
Building my first database with SQL: a library project

Building my first database with SQL: a library project

Comments
5 min read
Oracle Indexes: When They Help, When They Hurt, and How to Tell

Oracle Indexes: When They Help, When They Hurt, and How to Tell

Comments
11 min read
MariaDB vs MySQL vs PostgreSQL: an mpazari Benchmark

MariaDB vs MySQL vs PostgreSQL: an mpazari Benchmark

1
Comments
5 min read
Real-World Data Engineering on Snowflake: Architectural Patterns and DEA-C01 Insights

Real-World Data Engineering on Snowflake: Architectural Patterns and DEA-C01 Insights

Comments
2 min read
My "Last Hour" Query Returned 1,252 Rows. The Real Answer Was 68.

My "Last Hour" Query Returned 1,252 Rows. The Real Answer Was 68.

Comments 1
5 min read
PostgreSQL timestamp vs timestamptz: Which to Use and How to Find the Wrong Ones

PostgreSQL timestamp vs timestamptz: Which to Use and How to Find the Wrong Ones

Comments
8 min read
Circular Foreign Keys: Why the First Row Cannot Be Inserted

Circular Foreign Keys: Why the First Row Cannot Be Inserted

Comments
10 min read
Tattoo data taught me to delete every third-party script — and build analytics from a SQLite table

Tattoo data taught me to delete every third-party script — and build analytics from a SQLite table

Comments
4 min read
Taba est devenue une ligne SQL, et ça explique mieux la POO que n'importe quel cours

Taba est devenue une ligne SQL, et ça explique mieux la POO que n'importe quel cours

Comments
4 min read
Grading a wrong answer by how wrong it is: ICD-10 proximity scoring in Postgres

Grading a wrong answer by how wrong it is: ICD-10 proximity scoring in Postgres

1
Comments 1
4 min read
Subqueries and CTEs: Asking a Question Inside a Question

Subqueries and CTEs: Asking a Question Inside a Question

Comments
8 min read
EXPLAIN (ANALYZE, IO) in PostgreSQL 19

EXPLAIN (ANALYZE, IO) in PostgreSQL 19

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