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.
Your Postgres already knows why it's slow — you just have to ask it

Your Postgres already knows why it's slow — you just have to ask it

Comments
7 min read
SQL Server Heaps: Understanding Tables Without Clustered Indexes

SQL Server Heaps: Understanding Tables Without Clustered Indexes

1
Comments
4 min read
Normalization vs. Denormalization: The Great Database Debate

Normalization vs. Denormalization: The Great Database Debate

Comments
2 min read
Database Deep Dive Series

Database Deep Dive Series

1
Comments
1 min read
Cómo hablar con tu base de datos usando IA y construir un extractor SQL seguro con Streamlit

Cómo hablar con tu base de datos usando IA y construir un extractor SQL seguro con Streamlit

Comments 1
6 min read
Day 1: Understanding MySQL Storage Engines and MVCC

Day 1: Understanding MySQL Storage Engines and MVCC

Comments
6 min read
Open Source Project of the Day (#116): SAG — Multi-Hop RAG Retrieval via SQL JOINs Instead of PageRank

Open Source Project of the Day (#116): SAG — Multi-Hop RAG Retrieval via SQL JOINs Instead of PageRank

Comments
7 min read
How to Talk to Your Database Using AI: A Practical Implementation Guide

How to Talk to Your Database Using AI: A Practical Implementation Guide

1
Comments
1 min read
Agentes que se auto-corrigen: Text-to-SQL con smolagents (Hugging Face)

Agentes que se auto-corrigen: Text-to-SQL con smolagents (Hugging Face)

Comments
4 min read
How GBase 8a Handles Masked Columns in WHERE, GROUP BY, and Projections

How GBase 8a Handles Masked Columns in WHERE, GROUP BY, and Projections

Comments
2 min read
Relationship Schemas and Joins in Data Modeling

Relationship Schemas and Joins in Data Modeling

Comments
2 min read
A deep dive into building Text-to-SQL solutions using AI models, transforming natural language into SQL magic.

A deep dive into building Text-to-SQL solutions using AI models, transforming natural language into SQL magic.

30
Comments 1
3 min read
Cómo conversar con tu base de datos usando IA: un generador de SQL a partir de lenguaje natural

Cómo conversar con tu base de datos usando IA: un generador de SQL a partir de lenguaje natural

Comments
6 min read
SQLite Internals, Postgres 19 Checksums, & PL/CBMBASIC Extension

SQLite Internals, Postgres 19 Checksums, & PL/CBMBASIC Extension

Comments
3 min read
Cómo construir un agente de IA que "habla" con tu base de datos SQL

Cómo construir un agente de IA que "habla" con tu base de datos SQL

Comments 1
7 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.