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.
SQL Simplified: DDL, DML, and Essential Commands.

SQL Simplified: DDL, DML, and Essential Commands.

3
Comments
4 min read
Step-by-Step Guide: Setting Up RAG for Gen AI Agents Using IRIS Vector DB in Python

Step-by-Step Guide: Setting Up RAG for Gen AI Agents Using IRIS Vector DB in Python

Comments
25 min read
Understanding SQL: DDL, DML, and data manipulation

Understanding SQL: DDL, DML, and data manipulation

Comments 2
2 min read
I built a free desktop SQL client with a live database health dashboard

I built a free desktop SQL client with a live database health dashboard

Comments
1 min read
Behind the Scenes: How Database Traffic Control Works

Behind the Scenes: How Database Traffic Control Works

5
Comments 1
10 min read
NPI Number Validation: How to Clean and Enrich Provider Data in Your Database

NPI Number Validation: How to Clean and Enrich Provider Data in Your Database

Comments
6 min read
HCC Risk Adjustment Data Model: Building Accurate Risk Score Pipelines in SQL

HCC Risk Adjustment Data Model: Building Accurate Risk Score Pipelines in SQL

Comments 1
6 min read
Modifying Tables Safely in PostgreSQL — ALTER TABLE, Constraints, and Defaults

Modifying Tables Safely in PostgreSQL — ALTER TABLE, Constraints, and Defaults

Comments
4 min read
Subqueries vs. CTEs and When to Use Each

Subqueries vs. CTEs and When to Use Each

2
Comments
2 min read
Using SQLite to Track Sync State in Rust — Simple, Reliable, Zero Dependencies

Using SQLite to Track Sync State in Rust — Simple, Reliable, Zero Dependencies

1
Comments
2 min read
Does ClickHouse Support UPDATEs? A 2026 Data Analysis

Does ClickHouse Support UPDATEs? A 2026 Data Analysis

6
Comments 1
25 min read
HOW MY JOURNEY HAS BEEN INTO UNDERSTANDING SQL.

HOW MY JOURNEY HAS BEEN INTO UNDERSTANDING SQL.

Comments
2 min read
dbtyper: TypeScript for SQL — a Compile-Time SQL Type Checker

dbtyper: TypeScript for SQL — a Compile-Time SQL Type Checker

19
Comments 3
6 min read
The database is where AI agents in production get weird

The database is where AI agents in production get weird

Comments
2 min read
Part 4: Clone ++ Parallelization and Production Features

Part 4: Clone ++ Parallelization and Production Features

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