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.
How to Find the Postgres Indexes Your Planner Never Picks (I Found 20 of 51)

78% index disk waste revealed by custom tools

How to Find the Postgres Indexes Your Planner Never Picks (I Found 20 of 51)

6
Comments 2
10 min read
Automated SQL Migration Review with Real CLI Output (MySQL, PostgreSQL, TiDB)

Automated SQL Migration Review with Real CLI Output (MySQL, PostgreSQL, TiDB)

Comments
8 min read
Why I Index Only 32k Companies When Apollo Has 250M: A B2B Database Trade-off

Why I Index Only 32k Companies When Apollo Has 250M: A B2B Database Trade-off

Comments
4 min read
Fast, Efficient, and Confidently Delivered — But Wrong

Fast, Efficient, and Confidently Delivered — But Wrong

Comments
4 min read
O que é ACID?

O que é ACID?

Comments
4 min read
Get Real Row Counts in GBase 8s Without UPDATE STATISTICS

Get Real Row Counts in GBase 8s Without UPDATE STATISTICS

Comments
1 min read
Cloud Embeddings vs. Local Sovereign Memory: AI Agent Memory Layer Compared (2026)

Cloud Embeddings vs. Local Sovereign Memory: AI Agent Memory Layer Compared (2026)

1
Comments 2
12 min read
Fixing Database Import Failures After Moving Text Files from Windows to Linux

Fixing Database Import Failures After Moving Text Files from Windows to Linux

Comments
1 min read
TAP E2E Verify — Snowflake RBAC Automation Pipeline

TAP E2E Verify — Snowflake RBAC Automation Pipeline

Comments
2 min read
Hiểu Chuẩn ACID & Transaction: Đừng Để Database Của Bạn "Toang" Vì Lỗi Cơ Bản!

Hiểu Chuẩn ACID & Transaction: Đừng Để Database Của Bạn "Toang" Vì Lỗi Cơ Bản!

Comments
6 min read
Master Window Function trong SQL: Bí Kíp Tối Ưu Phân Tích Dữ Liệu

Master Window Function trong SQL: Bí Kíp Tối Ưu Phân Tích Dữ Liệu

Comments
4 min read
Vector Database Là Gì? Giải Mã "Trái Tim" Của Kỷ Nguyên AI

Vector Database Là Gì? Giải Mã "Trái Tim" Của Kỷ Nguyên AI

Comments
5 min read
NoSQL Toàn Tập: Khi Nào Nên "Chia Tay" SQL Để Dùng NoSQL?

NoSQL Toàn Tập: Khi Nào Nên "Chia Tay" SQL Để Dùng NoSQL?

Comments
5 min read
Track Rolling-Back Transactions in GBase 8s

Track Rolling-Back Transactions in GBase 8s

Comments
1 min read
Upgrading GBase 8c: Online and Offline Strategies

Upgrading GBase 8c: Online and Offline Strategies

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