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.
REST-style GraphQL — one line of Java handles filtering + sorting + pagination + stats + CSV export.

REST-style GraphQL — one line of Java handles filtering + sorting + pagination + stats + CSV export.

1
Comments
6 min read
Building a School Database with PostgreSQL: My SQL Week 2 Journey

Building a School Database with PostgreSQL: My SQL Week 2 Journey

1
Comments
4 min read
A Small, Annoying Reminder About MySQL, Next.js, and Reality

A Small, Annoying Reminder About MySQL, Next.js, and Reality

1
Comments
2 min read
Azure SQL Managed Instance vs Azure SQL Database: How I Actually Made the Call

Azure SQL Managed Instance vs Azure SQL Database: How I Actually Made the Call

Comments
10 min read
Why SQL Is Still the Most Important Skill for Data Engineers

Why SQL Is Still the Most Important Skill for Data Engineers

Comments
3 min read
You don't need a backend to store form submissions. You need a place to ask "how many."

You don't need a backend to store form submissions. You need a place to ask "how many."

1
Comments 1
2 min read
Lucidchart ERD Alternative: A Desktop ERD Tool That Connects to Your Database

Lucidchart ERD Alternative: A Desktop ERD Tool That Connects to Your Database

Comments
10 min read
# AI-Generated SQL Has a Silent Failure Problem. Here's a Way to Catch It.

# AI-Generated SQL Has a Silent Failure Problem. Here's a Way to Catch It.

Comments
5 min read
Building an Interactive Sales Dashboard with Power BI and PostgreSQL

Building an Interactive Sales Dashboard with Power BI and PostgreSQL

Comments
2 min read
B-tree block split: what's the impact?

B-tree block split: what's the impact?

1
Comments
12 min read
Deploying CockroachDB on Kubernetes

Deploying CockroachDB on Kubernetes

Comments
2 min read
Where Should the Foreign Key Go?

Where Should the Foreign Key Go?

Comments
6 min read
Comparing Staging and Production Database Schemas Side by Side

Comparing Staging and Production Database Schemas Side by Side

Comments
6 min read
SQL for Beginners: Building a Mini School Database from Scratch!

SQL for Beginners: Building a Mini School Database from Scratch!

Comments
5 min read
SQL: Data Integrity Constraints

SQL: Data Integrity Constraints

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