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.
SafariConnect: From a Broken Excel Export to a Board-Ready Analysis in PostgreSQL
leahkivuti profile

SafariConnect: From a Broken Excel Export to a Board-Ready Analysis in PostgreSQL

#data #database #sql
Comments 5
11 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
An AI-generated login endpoint "works" - I still found SQL concatenation before launch
yuan_ming_3549dae7e400994 profile

An AI-generated login endpoint "works" - I still found SQL concatenation before launch

#ai #python #security #sql
Comments 2
3 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
SQL NULL vs empty string vs zero
nexus_vibes profile

SQL NULL vs empty string vs zero

#sql
Comments 1
1 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
Why RBAC Alone Isn't Enough for Enterprise Data Agents
arisyndata profile

Why RBAC Alone Isn't Enough for Enterprise Data Agents

#ai #agents #llm #sql
1
Comments 1
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 agent picks tables before security runs. Here’s the fix.
ashish_sinha_5241c7673d93 profile

Your text-to-SQL agent picks tables before security runs. Here’s the fix.

#ai #python #sql #opensource
1
Comments 15
2 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
👋 Sign in for the ability to sort posts by relevant, latest, or top.