Skip to content

DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

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

Young Gao

Mar 21

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

#database #postgres #performance #sql

5 min read

Mar 25

Isolation

#backend #beginners #database #sql

2 min read

Apr 24

Understanding SQL: DDL, DML, and Data Transformation

#beginners #database #sql #tutorial

4 min read

Mar 21

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

#sql #beginners #snowflake #dataengineering

4 min read

Philip McClarence

Apr 23

The Complete Guide to PostgreSQL SQL Query Analysis & Optimization

#database #performance #postgres #sql

10 min read

Mar 24

Basic SQL Select Queries

#beginners #database #learning #sql

2 min read

Li

Mar 20

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

#showdev #database #java #sql

7 min read

AlexChen

Mar 20

From 68% to ~100%: How We Built a Text-to-SQL System That Gets Smarter Every Day

#sql #machinelearning #webdev #programming

11 min read

楊東霖

Mar 20

SQL Formatting Best Practices: Write Clean, Readable Queries

#sql #database #programming #tools

14 min read

Mar 24

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

#dataengineering #career #beginners #sql

5 min read

Apr 22

Mastering Commonly Used SQL Joins: With Relatable Examples

#sql #datanalysis #dataengineering #database

3 min read

Apr 22

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

#architecture #database #performance #sql

29 min read

NelimaL

Apr 22

SQL Without Confusion: Subqueries vs CTEs (Visual + Practical Guide)

#sql #dataanalytics #beginners #database

3 min read

Apr 21

How I Started Thinking in SQL (Not Just Writing Queries)

#beginners #database #learning #sql

4 min read

Apr 21

SQL Window Functions and CTEs

#sql #beginners #database #postgressql

5 min read

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