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.
MongoDB aggregation Pipelines simplified

MongoDB aggregation Pipelines simplified

4
Comments
2 min read
📝 Understanding Transactions, Deadlocks & Log-Based Recovery in SQL 💾

📝 Understanding Transactions, Deadlocks & Log-Based Recovery in SQL 💾

1
Comments
2 min read
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

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

3
Comments
4 min read
Cursor & Trigger in DBMS

Cursor & Trigger in DBMS

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

Understanding Oracle Datetime Datatypes: DATE, TIMESTAMP, and INTERVAL

4
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

2
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
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
👋 Sign in for the ability to sort posts by relevant, latest, or top.