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.
# 🔬 PostgreSQL Internals: What Is Actually Inside an 8 KB Page?
ahmedraza_fyntune profile

# 🔬 PostgreSQL Internals: What Is Actually Inside an 8 KB Page?

#database #webdev #postgres #sql
Comments
5 min read
From Raw Tables to Business Insights: A SQL Workflow Every SaaS Team Can Use
vivekdraxlr profile

From Raw Tables to Business Insights: A SQL Workflow Every SaaS Team Can Use

#sql #database #analytics #tutorial
Comments
5 min read
How to Comment in SQL: -- and /* */, and the Two Traps That Break a Query
michaelnocito profile

How to Comment in SQL: -- and /* */, and the Two Traps That Break a Query

#sql #database #tutorial #beginners
Comments
9 min read
SQL for Beginners: Window Functions vs GROUP BY
mysticg profile

SQL for Beginners: Window Functions vs GROUP BY

#beginners #database #sql #tutorial
1
Comments
4 min read
PostgreSQL MVCC: Why Bloat Doesn't Automatically Mean Expensive Reads
franckpachot profile

PostgreSQL MVCC: Why Bloat Doesn't Automatically Mean Expensive Reads

#postgres #sql #database #mvcc
Comments
23 min read
Dominando SQL para la Ciberseguridad: De la Selección Básica a la Detección de Amenazas
ce4vjpcode profile

Dominando SQL para la Ciberseguridad: De la Selección Básica a la Detección de Amenazas

#cybersecurity #database #sql
Comments
3 min read
SQL Subqueries vs CTEs: Types, Differences, Performance, and When to Use Each
jonathan_kip profile

SQL Subqueries vs CTEs: Types, Differences, Performance, and When to Use Each

#sql #datascience #beginners
2
Comments
4 min read
Your text-to-SQL model isn't as wrong as your benchmark says. The gold SQL is.
omer_hochman profile

Your text-to-SQL model isn't as wrong as your benchmark says. The gold SQL is.

#sql #llm #ai
Comments 1
3 min read
Vanna is archived. What that means if you have it in production.
ashish_sinha_5241c7673d93 profile

Vanna is archived. What that means if you have it in production.

#sql #ai #python #database
1
Comments 2
3 min read
How We Query 1.2 Billion Rows in Under 50ms — Partitioning, Columnstore, and Read Models at Scale
kirandeepjassalcrypto profile

How We Query 1.2 Billion Rows in Under 50ms — Partitioning, Columnstore, and Read Models at Scale

#sql #systemdesign #azure #dotnet
Comments
7 min read
Your audit log is probably lying to you. Postgres 18 fixes it in one statement.

Concurrently logged ghosts hide lost transactions
remdore profile

Your audit log is probably lying to you. Postgres 18 fixes it in one statement.

#postgres #sql #database #webdev
18
Comments 10
5 min read
Your text-to-SQL accuracy is measured on schemas your users will never build
omer_hochman profile

Your text-to-SQL accuracy is measured on schemas your users will never build

#sql #llm #ai
Comments 1
3 min read
5 Habits That Keep a dbt Project From Turning Into a Mess
anthony-gicheru profile

5 Habits That Keep a dbt Project From Turning Into a Mess

#dataengineering #dbt #sql #analytics
4
Comments 1
6 min read
How SQL Actually Works Under the Hood — A Deep Dive Into Snowflake and Redshift
maithreyan11 profile

How SQL Actually Works Under the Hood — A Deep Dive Into Snowflake and Redshift

#sql #dataengineering #snowflake #redshift
Comments
5 min read
DrawSQL Alternative: An Offline Desktop ERD Tool With No Table Limits
tbson87 profile

DrawSQL Alternative: An Offline Desktop ERD Tool With No Table Limits

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