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.
Dynamically Generating SQL Joins for Tables Based on a Common Column
kaidanov profile

Dynamically Generating SQL Joins for Tables Based on a Common Column

#dba #sql #tutorial #productivity
Comments
7 min read
Automated SQL Migration Review with Real CLI Output (MySQL, PostgreSQL, TiDB)
fanduzi profile
Fan()

Automated SQL Migration Review with Real CLI Output (MySQL, PostgreSQL, TiDB)

#showdev #cli #database #sql
2
Comments
8 min read
Why Big Tech is Migrating from Traditional Databases to NewSQL
dinhphu2k1gif profile

Why Big Tech is Migrating from Traditional Databases to NewSQL

#bigdata #dataengineering #database #sql
1
Comments
1 min read
We Ran One SQL Query… And Broke Production
cicd_samurai profile

We Ran One SQL Query… And Broke Production

#devops #database #sql #security
Comments
3 min read
Heart Part 7 - dalCTF 2026
exploitnotes profile

Heart Part 7 - dalCTF 2026

#cybersecurity #security #sql #web
1
Comments
3 min read
SQLite Internals & PostgreSQL Multi-Master Replication Updates
soytuber profile
soy

SQLite Internals & PostgreSQL Multi-Master Replication Updates

#database #sql #sqlite
Comments
3 min read
Extended RUM in DocumentDB extension for PostgreSQL: Efficient ESR (Equality, Sort, Range) Queries
franckpachot profile

Extended RUM in DocumentDB extension for PostgreSQL: Efficient ESR (Equality, Sort, Range) Queries

#postgres #sql #document #database
Comments
7 min read
PostgreSQL Query Anti-Patterns and Common Mistakes
philip_mcclarence_2ef9475 profile

PostgreSQL Query Anti-Patterns and Common Mistakes

#database #performance #postgres #sql
Comments 1
7 min read
SQL Subqueries vs CTEs
venuskennedy profile

SQL Subqueries vs CTEs

#beginners #database #sql #tutorial
Comments
3 min read
PostgreSQL AI Memory, Perf Tuning; Data Pipeline Orchestration Comparison
soytuber profile
soy

PostgreSQL AI Memory, Perf Tuning; Data Pipeline Orchestration Comparison

#database #sql #sqlite
Comments 1
3 min read
How I was introduced to SQL window function
dhairya_pandya profile

How I was introduced to SQL window function

#analytics #database #postgres #sql
Comments
2 min read
I built a free SQL practice game where you work at a fictional Singapore bank
martinl5 profile
Martin

I built a free SQL practice game where you work at a fictional Singapore bank

#sql #database #beginners #webdev
4
Comments 2
2 min read
Day 5 of 100 Days of ClickHouse®: Writing Your First Query
kanishga_subramani_49ad73 profile

Day 5 of 100 Days of ClickHouse®: Writing Your First Query

#clickhouse #database #dataengineering #sql
1
Comments
5 min read
Day 19 of 60: From Raw SQL to a Full Stack FastAPI App.
mbugua_cessy profile

Day 19 of 60: From Raw SQL to a Full Stack FastAPI App.

#devchallenge #postgres #python #sql
4
Comments
3 min read
Building a SQL Lexer in Rust: Why I Replaced `Vec<char>` with `&str` and `Ident(String)` with Spans
musab0986 profile

Building a SQL Lexer in Rust: Why I Replaced `Vec<char>` with `&str` and `Ident(String)` with Spans

#rust #sql #database #parser
1
Comments
3 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.