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.
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
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
1
Comments
9 min read
Infinite recursion in Postgres RLS: a SECURITY DEFINER gotcha
bairescodeai profile

Infinite recursion in Postgres RLS: a SECURITY DEFINER gotcha

#postgres #supabase #webdev #sql
Comments
2 min read
Day 83 of Learning MERN Stack
ali_hamza_589ec7b3eb6688d profile

Day 83 of Learning MERN Stack

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

Day 81 of Learning MERN Stack

#sql #groupby #database #programming
1
Comments
2 min read
Day 78 of Learning MERN Stack
ali_hamza_589ec7b3eb6688d profile

Day 78 of Learning MERN Stack

#sql #backend #database #architecture
1
Comments
1 min read
Chai aur SQL — A Beginner's Journey into Databases
abdulrdeveloper profile

Chai aur SQL — A Beginner's Journey into Databases

#sql #postgres #database #backend
Comments
7 min read
Agent‑safe change delivery on Oracle: discovery, online mechanics, idempotent migrations, and provable rollbacks
mark_nelson_oracle profile

Agent‑safe change delivery on Oracle: discovery, online mechanics, idempotent migrations, and provable rollbacks

#agents #database #devops #sql
Comments
17 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.