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.
When to Use SQL vs NoSQL Databases: A Comprehensive 2026 Guide

When to Use SQL vs NoSQL Databases: A Comprehensive 2026 Guide

1
Comments
19 min read
The Slow Query Hidden Inside Your PL/pgSQL Function

The Slow Query Hidden Inside Your PL/pgSQL Function

Comments
5 min read
PostgreSQL Performance: 10 Queries You're Writing Wrong (2026 Edition)

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

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

Understanding SQL: DDL, DML, and Data Transformation

4
Comments
4 min read
Isolation

Isolation

1
Comments
2 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
👋 Sign in for the ability to sort posts by relevant, latest, or top.