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.
Supabase 42501 permission denied is a grant problem, not RLS

Supabase 42501 permission denied is a grant problem, not RLS

Comments
4 min read
Querying Parquet on S3 with DuckDB: secrets, speed and the settings that matter

Querying Parquet on S3 with DuckDB: secrets, speed and the settings that matter

Comments
3 min read
Your UUID Column Is 9x Bigger Than It Needs to Be

Your UUID Column Is 9x Bigger Than It Needs to Be

Comments
2 min read
A falling lane rank does not prove a champion nerf

A falling lane rank does not prove a champion nerf

Comments
7 min read
SQL for beginners

SQL for beginners

Comments
5 min read
schemagate is now #1 on the official BIRD Mini-Dev leaderboard

schemagate is now #1 on the official BIRD Mini-Dev leaderboard

1
Comments
1 min read
What Is a Data Quality Check? Types, Where to Run Them, and Examples

What Is a Data Quality Check? Types, Where to Run Them, and Examples

1
Comments
5 min read
One Annotation Cut Our SQL Write Amplification by 90%

One Annotation Cut Our SQL Write Amplification by 90%

Comments
6 min read
Preparing Clean Data for a DWH

Preparing Clean Data for a DWH

Comments
21 min read
Pagination That Skips Rows Is an Off-by-One in the Data Model

Pagination That Skips Rows Is an Off-by-One in the Data Model

Comments
3 min read
`SELECT * FROM DUAL` - The Lore of Oracle DB's Weirdest Table

`SELECT * FROM DUAL` - The Lore of Oracle DB's Weirdest Table

Comments
3 min read
Database Indexing – Part 5: Sequential Scan vs. Index Scan vs. Bitmap Index Scan in PostgreSQL

Database Indexing – Part 5: Sequential Scan vs. Index Scan vs. Bitmap Index Scan in PostgreSQL

Comments
6 min read
Why SyteLine Says "Row Has Been Modified by Another User" (and How Optimistic Concurrency Works)

Why SyteLine Says "Row Has Been Modified by Another User" (and How Optimistic Concurrency Works)

Comments
3 min read
Reylo types .sql files by asking your database. I tried to fool it five ways.

Reylo types .sql files by asking your database. I tried to fool it five ways.

Comments
5 min read
Filtering Data in SQL: A Beginner’s Guide to WHERE, AND, LIKE, and Other Operators

Filtering Data in SQL: A Beginner’s Guide to WHERE, AND, LIKE, and Other Operators

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