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.
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
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
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
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
SQLite Optimization, PostgreSQL Async Queries, & DuckLake Dataframe Spec
soytuber profile
soy

SQLite Optimization, PostgreSQL Async Queries, & DuckLake Dataframe Spec

#database #sql #sqlite
Comments
3 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
👋 Sign in for the ability to sort posts by relevant, latest, or top.