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.
The same tiny GPT in SQL, PostScript and Brainfuck, byte for byte

The same tiny GPT in SQL, PostScript and Brainfuck, byte for byte

1
Comments
7 min read
From SQL Query to Product Decision: How SaaS Teams Use Data

From SQL Query to Product Decision: How SaaS Teams Use Data

Comments
6 min read
Composite Indexes in PostgreSQL & MySQL: Column Order Guide

Composite Indexes in PostgreSQL & MySQL: Column Order Guide

Comments
7 min read
Context, Not Models: What Actually Made AI BI Reliable

Context, Not Models: What Actually Made AI BI Reliable

Comments
25 min read
How to Generate 500 Realistic Fake Users with PostgreSQL & MySQL Seed Scripts in Seconds

How to Generate 500 Realistic Fake Users with PostgreSQL & MySQL Seed Scripts in Seconds

Comments
1 min read
A new campaign's first results cost zero API quota, because Postgres already has the titles

A new campaign's first results cost zero API quota, because Postgres already has the titles

1
Comments
7 min read
SQL Joins

SQL Joins

Comments
16 min read
Best Snowflake Data Modeling Tools: SQLDBM, erwin, Hackolade & Vertabelo for Reverse Engineering and DDL Generation

Best Snowflake Data Modeling Tools: SQLDBM, erwin, Hackolade & Vertabelo for Reverse Engineering and DDL Generation

Comments
11 min read
Probing FTS5 Support in node:sqlite: A Field Guide to Graceful Degradation

Probing FTS5 Support in node:sqlite: A Field Guide to Graceful Degradation

Comments
4 min read
Window Functions vs. Aggregate Functions in SQL

Window Functions vs. Aggregate Functions in SQL

Comments
6 min read
Changing a Column Type in SQLite: The Table Rebuild and What It Deletes

Changing a Column Type in SQLite: The Table Rebuild and What It Deletes

Comments
8 min read
Your Demo Dashboard Is Not a Funnel: Auditing Synthetic Events in ClickHouse

Your Demo Dashboard Is Not a Funnel: Auditing Synthetic Events in ClickHouse

Comments
5 min read
A per-order margin ledger: reconciling what you quoted against what the carrier billed

A per-order margin ledger: reconciling what you quoted against what the carrier billed

Comments
4 min read
A PostgreSQL Role That Reads the Schema but Not the Data: What to Grant

A PostgreSQL Role That Reads the Schema but Not the Data: What to Grant

Comments
8 min read
ON DELETE SET NULL vs CASCADE vs RESTRICT in PostgreSQL: Which to Use

ON DELETE SET NULL vs CASCADE vs RESTRICT in PostgreSQL: Which to Use

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