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 customer_id that isn't a customer
gaur_data_c6511af396c4bce profile

The customer_id that isn't a customer

#agents #analytics #dataengineering #sql
Comments
8 min read
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
SQL + AI: Real-World Database Solutions You Can Use Today
andrecarbajal profile

SQL + AI: Real-World Database Solutions You Can Use Today

#sql #ai #database #postgres
Comments
9 min read
Managing Database Migrations with Alembic
damla___ profile

Managing Database Migrations with Alembic

#database #python #sql #tutorial
Comments
2 min read
Day 83 of Learning MERN Stack
ali_hamza_589ec7b3eb6688d profile

Day 83 of Learning MERN Stack

#sql #backend #database #softwareengineering
Comments
2 min read
Day 81 of Learning MERN Stack
ali_hamza_589ec7b3eb6688d profile

Day 81 of Learning MERN Stack

#sql #groupby #database #programming
Comments
2 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.