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.
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 to Set Up a SQL Database for Beginners

How to Set Up a SQL Database for Beginners

Comments
6 min read
How I Made Sure You Can't Like and Dislike the Same Post at Once

How I Made Sure You Can't Like and Dislike the Same Post at Once

7
Comments
3 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
PostgreSQL 19 REPACK: Choosing the Right FILLFACTOR

PostgreSQL 19 REPACK: Choosing the Right FILLFACTOR

1
Comments 1
10 min read
Why Your Database Index Gets Ignored (and How to Design One That Isn't)

Why Your Database Index Gets Ignored (and How to Design One That Isn't)

Comments
3 min read
My Journey Into Data Analysis: From Basics to SQL

My Journey Into Data Analysis: From Basics to SQL

Comments
2 min read
Vendor Invoice Project

Vendor Invoice Project

Comments
2 min read
I'm building Osquil, a schema-aware query workbench for osquery

I'm building Osquil, a schema-aware query workbench for osquery

Comments
3 min read
Tracking Tableau Viewership with PostgreSQL

Tracking Tableau Viewership with PostgreSQL

Comments
2 min read
Vanna AI (El estándar de la industria para Text-to-SQL)

Vanna AI (El estándar de la industria para Text-to-SQL)

Comments 1
4 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.