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.
A Better Way to Store PostgreSQL Schemas in Git
roman_shevel_a41af9e39d8a profile

A Better Way to Store PostgreSQL Schemas in Git

#postgres #git #database #sql
2
Comments 1
2 min read
How to Build an agent using coral
tejaswahinduja profile

How to Build an agent using coral

#agents #ai #sql #tutorial
Comments 1
7 min read
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
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
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
Pandas vs SQL, when to use each
iwtlp profile

Pandas vs SQL, when to use each

#pandas #sql #dataanalysis
Comments
2 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
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
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 1
4 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
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.