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.
SQL Course for Analysts: Pick, Learn, Apply Fast

SQL Course for Analysts: Pick, Learn, Apply Fast

Comments
3 min read
archery-cli: A psql-style CLI for Archery — Query Databases from Terminal or AI Agents

archery-cli: A psql-style CLI for Archery — Query Databases from Terminal or AI Agents

1
Comments
3 min read
MySQL 的 MVCC:看不见的“时间机器”怎么帮你躲过脏读和幻读?

MySQL 的 MVCC:看不见的“时间机器”怎么帮你躲过脏读和幻读?

Comments
1 min read
The stored procedure ran fine in SSMS — under 1 second, every time. But through the .NET API? 30–120 seconds. Timeouts. Errors.

The stored procedure ran fine in SSMS — under 1 second, every time. But through the .NET API? 30–120 seconds. Timeouts. Errors.

Comments
2 min read
Data Engineers Don't Need DSA. So Why Do Interviews Still Test It?

Data Engineers Don't Need DSA. So Why Do Interviews Still Test It?

Comments
7 min read
SQL Window Functions Explained: Stop Collapsing Your Data with GROUP BY

SQL Window Functions Explained: Stop Collapsing Your Data with GROUP BY

Comments
6 min read
SQL GROUP BY & HAVING: The Beginner's Guide to Summarizing Data Like a Pro

SQL GROUP BY & HAVING: The Beginner's Guide to Summarizing Data Like a Pro

Comments
6 min read
I completed the IBM Data Analyst Certificate 🎓

I completed the IBM Data Analyst Certificate 🎓

Comments
1 min read
Coding Cat Oran S2 Ep2 — The Big Customer

Coding Cat Oran S2 Ep2 — The Big Customer

Comments
4 min read
SQLite RISC-V Fix, Formal Verification & pg_grpc for SQL-Native gRPC

SQLite RISC-V Fix, Formal Verification & pg_grpc for SQL-Native gRPC

Comments
3 min read
I built a VS Code extension to debug MySQL queries step by step

I built a VS Code extension to debug MySQL queries step by step

Comments
1 min read
GBase 8a Full-Text Index: Features, Queries, and Configuration

GBase 8a Full-Text Index: Features, Queries, and Configuration

2
Comments
2 min read
I built a PostgreSQL learning platform with labs & quizzes — would love feedback

I built a PostgreSQL learning platform with labs & quizzes — would love feedback

Comments
1 min read
Using SQLite to Track Sync State in Rust — Simple, Reliable, Zero Dependencies

Using SQLite to Track Sync State in Rust — Simple, Reliable, Zero Dependencies

1
Comments
2 min read
Top 5 Data Engineering Tools for 2026: Why Python and SQL remain Kings

Top 5 Data Engineering Tools for 2026: Why Python and SQL remain Kings

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