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.
Data Migration, Conversion, and ETL — What I Actually Did, Across Two Eras

Data Migration, Conversion, and ETL — What I Actually Did, Across Two Eras

Comments
17 min read
Database Agnostic Queries: Easing the Pain of Engine Migration

Database Agnostic Queries: Easing the Pain of Engine Migration

Comments
3 min read
Building SaarDB, Part 3: Compaction

Building SaarDB, Part 3: Compaction

3
Comments
10 min read
Intuit OA 2026 Guide: Code, SQL & Bash Questions Explained

Intuit OA 2026 Guide: Code, SQL & Bash Questions Explained

1
Comments
4 min read
Dory Has Received the SourceForge Rising Star Award

Dory Has Received the SourceForge Rising Star Award

Comments
1 min read
Day 2: Understanding MySQL Client-Server Communication, Protocols, and Pages

Day 2: Understanding MySQL Client-Server Communication, Protocols, and Pages

Comments
3 min read
ON DELETE CASCADE Is Invisible in Your ERD and in Your Database Logs

ON DELETE CASCADE Is Invisible in Your ERD and in Your Database Logs

Comments 1
10 min read
Snowflake SQL Interview Questions – Quick Notes

Snowflake SQL Interview Questions – Quick Notes

Comments
2 min read
Introduction to SQL: Understanding Databases, Data Types, Constraints, and Core SQL Concepts

Introduction to SQL: Understanding Databases, Data Types, Constraints, and Core SQL Concepts

1
Comments
7 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
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.