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.
Compiling Customer Segments to SQL: OR Groups, Tenant Safety and Membership That Stays Current

Compiling Customer Segments to SQL: OR Groups, Tenant Safety and Membership That Stays Current

1
Comments
9 min read
PostgreSQL's recovery_prefetch prefetches pages the WAL already holds

PostgreSQL's recovery_prefetch prefetches pages the WAL already holds

Comments
6 min read
Your Agent's ADD FOREIGN KEY Stalls Writes on Two Tables. NOT VALID, Then VALIDATE

Your Agent's ADD FOREIGN KEY Stalls Writes on Two Tables. NOT VALID, Then VALIDATE

Comments
7 min read
7 SQL checks I run before UAT sign-off (with queries you can copy)

7 SQL checks I run before UAT sign-off (with queries you can copy)

Comments 2
5 min read
Auditing wp_options autoload, revisions and transients before you clean a WordPress database

Auditing wp_options autoload, revisions and transients before you clean a WordPress database

Comments
5 min read
5 rules we used to turn 164,963 daily follower readings into one honest growth number

5 rules we used to turn 164,963 daily follower readings into one honest growth number

Comments
3 min read
Your SUM() isn't wrong, your grain is: debugging JOIN fan-out in 6 rows

Your SUM() isn't wrong, your grain is: debugging JOIN fan-out in 6 rows

1
Comments 1
3 min read
Construí un panel OLAP con DuckDB que consulta datos en el navegador

Construí un panel OLAP con DuckDB que consulta datos en el navegador

Comments
6 min read
GORM counted 11 rows. PostgreSQL found 7 distinct pairs.

GORM counted 11 rows. PostgreSQL found 7 distinct pairs.

Comments
3 min read
How Relational Databases Prevent Data Corruption: Two-Phase Locking (2PL)

How Relational Databases Prevent Data Corruption: Two-Phase Locking (2PL)

Comments
2 min read
If You Know SQL, You Already Know Most of pandas

If You Know SQL, You Already Know Most of pandas

Comments
7 min read
Second Highest Salary in SQL: 4 Ways, and Which Ones Quietly Break

Second Highest Salary in SQL: 4 Ways, and Which Ones Quietly Break

1
Comments
5 min read
Postgres full-text search is enough for most side projects

Postgres full-text search is enough for most side projects

Comments
1 min read
Postgres full-text search is enough for most side projects

Postgres full-text search is enough for most side projects

Comments
1 min read
Sequill: A Free, Private SQLite Editor & Schema Designer That Runs in Your Browser

Sequill: A Free, Private SQLite Editor & Schema Designer That Runs in Your Browser

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