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.
The Five Most Important Columns to Add to Every Database Table

The Five Most Important Columns to Add to Every Database Table

Comments
5 min read
6 Essential SQL Concepts Every Beginner Should Master

6 Essential SQL Concepts Every Beginner Should Master

1
Comments
2 min read
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
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
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
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
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.