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.
I didn't have a PC for my database class, so I built my own T-SQL Sandbox in the browser
abdiel_ortega_5866744e706 profile

I didn't have a PC for my database class, so I built my own T-SQL Sandbox in the browser

#showdev #sql #webdev #productivity
1
Comments
2 min read
SiteRows example #1:
michael_ozersky_9624310ec profile

SiteRows example #1:

#showdev #python #sql #webscraping
Comments
1 min read
Building a Denim Collection API: A Practical Guide to Handling Product Variants
dylan_parker123 profile

Building a Denim Collection API: A Practical Guide to Handling Product Variants

#api #database #sql #tutorial
2
Comments 2
2 min read
SQLite Internals, PostgreSQL Performance & Multi-Tenancy Patterns
soytuber profile
soy

SQLite Internals, PostgreSQL Performance & Multi-Tenancy Patterns

#database #sql #sqlite
Comments
3 min read
CTE vs Temporary Tables in SQL: Which One Should You Use?
akbatra567 profile

CTE vs Temporary Tables in SQL: Which One Should You Use?

#cte #temptable #sql
Comments
3 min read
Pandas vs SQL, when to use each
iwtlp profile

Pandas vs SQL, when to use each

#pandas #sql #dataanalysis
Comments
2 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
2
Comments
3 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
2
Comments
3 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
2
Comments
17 min read
DuckDB Delta, PostgreSQL 17 Migration, & SQLite Optimization Deep Dives
soytuber profile
soy

DuckDB Delta, PostgreSQL 17 Migration, & SQLite Optimization Deep Dives

#database #sql #sqlite
Comments
3 min read
Safer NL2SQL with Select AI and AI Profiles
mark_nelson_oracle profile

Safer NL2SQL with Select AI and AI Profiles

#ai #database #security #sql
Comments
10 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
How to Query Your Database in Plain English (No SQL Required)
abda_net profile

How to Query Your Database in Plain English (No SQL Required)

#ai #sql #database #devops
3
Comments
4 min read
What Actually Helped Our Talk-to-DB Agent Stop Relearning the Same SQL
zeeshan_ghazanfar_97 profile

What Actually Helped Our Talk-to-DB Agent Stop Relearning the Same SQL

#agents #llm #rag #sql
Comments
1 min read
How I Built a Live SQL Workshop Where Students Can't Break Anything
hedi22 profile

How I Built a Live SQL Workshop Where Students Can't Break Anything

#sql #development #database #devtool
Comments
6 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.