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.
PostgreSQL Performance: 10 Queries You're Writing Wrong (2026 Edition)

PostgreSQL Performance: 10 Queries You're Writing Wrong (2026 Edition)

Comments
5 min read
Isolation

Isolation

1
Comments
2 min read
Understanding SQL: DDL, DML, and Data Transformation

Understanding SQL: DDL, DML, and Data Transformation

4
Comments
4 min read
SQL LIKE and Wildcards: Pattern Matching Made Simple

SQL LIKE and Wildcards: Pattern Matching Made Simple

Comments
6 min read
Snowflake vs Redshift vs BigQuery: Which One Should You Use?

Snowflake vs Redshift vs BigQuery: Which One Should You Use?

1
Comments
4 min read
The Complete Guide to PostgreSQL SQL Query Analysis & Optimization

The Complete Guide to PostgreSQL SQL Query Analysis & Optimization

2
Comments
10 min read
Beyond CRUD: How easy-query Brings OLAP Superpowers to Your Java ORM

Beyond CRUD: How easy-query Brings OLAP Superpowers to Your Java ORM

2
Comments
7 min read
Basic SQL Select Queries

Basic SQL Select Queries

1
Comments
2 min read
I built a browser-only SQL practice tool because installing DBeaver is a productivity tax

I built a browser-only SQL practice tool because installing DBeaver is a productivity tax

Comments
3 min read
SQL Formatting Best Practices: Write Clean, Readable Queries

SQL Formatting Best Practices: Write Clean, Readable Queries

Comments
14 min read
A Day in the Life of a Data Engineer (Real Talk, No Filter)

A Day in the Life of a Data Engineer (Real Talk, No Filter)

Comments
5 min read
Mastering Commonly Used SQL Joins: With Relatable Examples

Mastering Commonly Used SQL Joins: With Relatable Examples

1
Comments
3 min read
SQL database architecture, use cases, and monitoring: a practitioner's guide

SQL database architecture, use cases, and monitoring: a practitioner's guide

3
Comments
29 min read
Créer un système d’authentification avec PHP et MySQL (étape par étape)

Créer un système d’authentification avec PHP et MySQL (étape par étape)

1
Comments
2 min read
Understanding Subqueries vs CTEs in SQL (With Examples)

Understanding Subqueries vs CTEs in SQL (With Examples)

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