DEV Community

Database

Posts on building, using, and learning about databases.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
Why Do Data Pipelines Need Streaming — Isn’t Batch Processing Enough?

Why Do Data Pipelines Need Streaming — Isn’t Batch Processing Enough?

Comments
4 min read
SQL Transactions — The Complete Guide (Internals, ACID, Isolation, Locks, Logs, and Real-World Code)

SQL Transactions — The Complete Guide (Internals, ACID, Isolation, Locks, Logs, and Real-World Code)

Comments
4 min read
🏦 Database Magic: Automating Tasks with Cursor and Trigger ✨

🏦 Database Magic: Automating Tasks with Cursor and Trigger ✨

Comments
3 min read
py schema

py schema

Comments
2 min read
Database Normalization: From 1NF to 3NF

Database Normalization: From 1NF to 3NF

Comments
2 min read
Cursor +Trigger

Cursor +Trigger

Comments
2 min read
🚀 ทำความเข้าใจ Row-Level Security (RLS) ใน PostgreSQL แบบง่ายที่สุด

🚀 ทำความเข้าใจ Row-Level Security (RLS) ใน PostgreSQL แบบง่ายที่สุด

Comments
1 min read
MySQL: Complete Architecture, Internals, and Practical Guide (With Code)

MySQL: Complete Architecture, Internals, and Practical Guide (With Code)

Comments
3 min read
Database Indexing Explained Like You're 5 (Then Like You're a Senior Dev)

Database Indexing Explained Like You're 5 (Then Like You're a Senior Dev)

2
Comments
7 min read
ACID Properties in DBMS

ACID Properties in DBMS

Comments
1 min read
INDEXING - HASHING - AND -QUERY

INDEXING - HASHING - AND -QUERY

Comments
1 min read
Transactions, Deadlocks & Log Based Recovery

Transactions, Deadlocks & Log Based Recovery

Comments
1 min read
Top 5 PostgreSQL backup tools in 2025

Top 5 PostgreSQL backup tools in 2025

2
Comments
5 min read
Understanding Records in PL/SQL: Benefits and Limitations

Understanding Records in PL/SQL: Benefits and Limitations

1
Comments
3 min read
Building Reliable Legal AI: Never Missing a Supreme Court Case

Building Reliable Legal AI: Never Missing a Supreme Court Case

3
Comments
26 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.