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.
Ghost CMS has 12 tables and 80+ columns. What does each one mean?
kekekuki profile

Ghost CMS has 12 tables and 80+ columns. What does each one mean?

#database #sql #opensource #ai
Comments
3 min read
Beyond SQL Queries: Exploring the Programming Side of SQL
yash_kishan_singh_6t profile

Beyond SQL Queries: Exploring the Programming Side of SQL

#sql #queries #programming
4
Comments
4 min read
When to denormalize, when to join: A ClickHouse guide (2026)
manveerchawla profile

When to denormalize, when to join: A ClickHouse guide (2026)

#clickhouse #database #performance #sql
1
Comments
17 min read
How Database Indexes Actually Work (and When They Backfire)
dilip_v_p profile

How Database Indexes Actually Work (and When They Backfire)

#database #sql #backend #webdev
Comments
3 min read
Quick Overview of Relationship Schemas and Joins
felix_omayo_95e7e6dafed3b profile

Quick Overview of Relationship Schemas and Joins

#analytics #beginners #database #sql
Comments
4 min read
One query language for SQL, Mongo, and the browser: the case for Forge
johnsonfash profile

One query language for SQL, Mongo, and the browser: the case for Forge

#backend #database #sql #typescript
Comments
9 min read
Data Analysis SQL: Asking the right questions and using the right tools
lulij profile

Data Analysis SQL: Asking the right questions and using the right tools

#sql #career #database #tutorial
Comments
4 min read
Ad-Hoc Video Analytics with DuckDB on Parquet Exports from Production SQLite
ahmet_gedik778845 profile

Ad-Hoc Video Analytics with DuckDB on Parquet Exports from Production SQLite

#duckdb #sql #analytics #php
Comments
10 min read
Our SQL Server loop kept writing the previous row's value
iamamitkumarsahoo profile
Amit

Our SQL Server loop kept writing the previous row's value

#sql #sqlserver #database
Comments
4 min read
SQL vs NoSQL Databases: Which One Should You Choose?
jaspreet_singh_86ae1740ac profile

SQL vs NoSQL Databases: Which One Should You Choose?

#architecture #database #sql #systemdesign
5
Comments
5 min read
Managing Database Migrations with Alembic
damla___ profile

Managing Database Migrations with Alembic

#database #python #sql #tutorial
Comments
2 min read
Breaking the SQL Barrier: How to Build a Natural Language Database Assistant
rodrigo_sidneycolquequi profile

Breaking the SQL Barrier: How to Build a Natural Language Database Assistant

#ai #python #sql #tutorial
1
Comments 2
2 min read
I Reverse Engineered a Closed-Format App. Everything Was in SQLite.
antonio_zhu_e726fd856cd86 profile

I Reverse Engineered a Closed-Format App. Everything Was in SQLite.

#database #productivity #software #sql
Comments
4 min read
SQL window functions: what separates a mid-level from a senior developer
lbraun7 profile

SQL window functions: what separates a mid-level from a senior developer

#sql #postgres #backend #database
Comments
5 min read
Prompting AI for Complex Multi-Table SQL: A Practical Guide
vivekdraxlr profile

Prompting AI for Complex Multi-Table SQL: A Practical Guide

#sql #database #ai #tutorial
1
Comments
5 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.