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.
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
Using dbt to Transform OpenSky Flight Data

Using dbt to Transform OpenSky Flight Data

1
Comments
4 min read
5 SQL Interview Questions That Trip Up Beginners

5 SQL Interview Questions That Trip Up Beginners

Comments
2 min read
2am.tech Releases SQL Migration Tool to Streamline Database Changes

2am.tech Releases SQL Migration Tool to Streamline Database Changes

Comments
2 min read
UUID in Manticore: A Practical Guide

UUID in Manticore: A Practical Guide

Comments
9 min read
Before you pick an Azure target, run the Oracle assessment you're probably skipping

Before you pick an Azure target, run the Oracle assessment you're probably skipping

Comments
3 min read
A Small, Annoying Reminder About MySQL, Next.js, and Reality

A Small, Annoying Reminder About MySQL, Next.js, and Reality

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