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.
Selling 59-cent AI video clips without inventing a currency (a wallet on Cloudflare D1)

Selling 59-cent AI video clips without inventing a currency (a wallet on Cloudflare D1)

Comments
4 min read
Did the property change, or did your collection mode?

Did the property change, or did your collection mode?

Comments
6 min read
My first SQL lesson learned the hard way

My first SQL lesson learned the hard way

Comments
1 min read
How to Verify Oracle Database 19c Release Update Patching in CDB and PDB Environments

How to Verify Oracle Database 19c Release Update Patching in CDB and PDB Environments

Comments
9 min read
SQL Server Statistics Explained: Why Your Query Plans Go Wrong

SQL Server Statistics Explained: Why Your Query Plans Go Wrong

Comments
3 min read
TikTok Shop bundle discounts need a refund-aware contribution ceiling

TikTok Shop bundle discounts need a refund-aware contribution ceiling

Comments 1
5 min read
One constant was costing my schema retriever 17 points

One constant was costing my schema retriever 17 points

Comments
2 min read
Find the Departures Your Offboarding Ticket Report Misses with SQLite

Find the Departures Your Offboarding Ticket Report Misses with SQLite

Comments
4 min read
Postgres not using your index? It's counting pages, not rows

Postgres not using your index? It's counting pages, not rows

Comments
10 min read
Build a Pre-Deployment Schema Drift Check for SQL Server

Build a Pre-Deployment Schema Drift Check for SQL Server

Comments
5 min read
5 SQL mistakes that return the wrong number with no error (reproduce each one in Postgres)

5 SQL mistakes that return the wrong number with no error (reproduce each one in Postgres)

Comments
4 min read
A refund-aware reorder point model for TikTok Shop SKU planning

A refund-aware reorder point model for TikTok Shop SKU planning

Comments
5 min read
From 9 Seconds to 2 Milliseconds: Database Indexes Explained

From 9 Seconds to 2 Milliseconds: Database Indexes Explained

Comments
6 min read
Text-to-SQL Agents Answer Questions Nobody Reviewed. Add Receipts

Text-to-SQL Agents Answer Questions Nobody Reviewed. Add Receipts

Comments
5 min read
Creator commission is a cash event, not a percentage

Creator commission is a cash event, not a percentage

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