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

PostgreSQL 19 REPACK: Choosing the Right FILLFACTOR

1
Comments 1
10 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
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
SQL Design & Query Reference

SQL Design & Query Reference

1
Comments 1
35 min read
The Afternoon We Put Magento's Schema on SQL Server

The Afternoon We Put Magento's Schema on SQL Server

1
Comments
40 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
Data Engineer LeetCode: What to Grind and What to Skip

Data Engineer LeetCode: What to Grind and What to Skip

Comments
7 min read
Following ROWIDs Through an Oracle Unique Index Update

Following ROWIDs Through an Oracle Unique Index Update

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