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.
Building Self-Correcting LLM Systems: The Evaluator-Optimizer Pattern

Building Self-Correcting LLM Systems: The Evaluator-Optimizer Pattern

1
Comments
6 min read
Entendendo Flyway

Entendendo Flyway

1
Comments
2 min read
Turso, a Bright Future for SQLite Written From Scratch in Rust

Turso, a Bright Future for SQLite Written From Scratch in Rust

2
Comments
4 min read
Understanding Oracle Datetime Datatypes: DATE, TIMESTAMP, and INTERVAL

Understanding Oracle Datetime Datatypes: DATE, TIMESTAMP, and INTERVAL

3
Comments
3 min read
CURSOR AND TRIGGER

CURSOR AND TRIGGER

Comments
2 min read
GCP Cloud SQL + Terraform: Quick Start Guide

GCP Cloud SQL + Terraform: Quick Start Guide

Comments
2 min read
Understanding Normalization in DBMS: Oracle Live SQL Practical Guide

Understanding Normalization in DBMS: Oracle Live SQL Practical Guide

Comments
3 min read
Recuperando dados no Oracle (sem envolver o DBA) com FlashBack Query

Recuperando dados no Oracle (sem envolver o DBA) com FlashBack Query

Comments
3 min read
Database Normalization

Database Normalization

Comments
3 min read
Cursor +Trigger

Cursor +Trigger

Comments
2 min read
normalization

normalization

Comments
2 min read
Indexing, Hashing, and Query

Indexing, Hashing, and Query

Comments
1 min read
From JSONB to Bitmasks: Faster Flags & Cleaner RLS in Postgres with Go/TS

From JSONB to Bitmasks: Faster Flags & Cleaner RLS in Postgres with Go/TS

Comments
6 min read
Database troubleshooting for Umami

Database troubleshooting for Umami

1
Comments
6 min read
Transactions, Deadlocks & Log Based Recovery

Transactions, Deadlocks & Log Based Recovery

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