#DB
12 articles
Characteristics and Design of Nontemporal, Unitemporal, and Bitemporal
Exploring the features, design examples, advantages, and disadvantages of different temporal data models.
Practical Introduction to Redis: From Technical Mechanisms to Real-World Applications
Practical Introduction to Redis: From Technical Mechanisms to Real-World Applications
PostgreSQL Comprehensive Guide, 4th Edition: From Installation to Features, Mechanisms, Application Development, Management, and Operations
PostgreSQL Comprehensive Guide, 4th Edition: From Installation to Features, Mechanisms, Application Development, Management, and Operations
A Comprehensive Guide to Database Design: For Those Who Don’t Want to Stop at Beginner Level
A Comprehensive Guide to Database Design: For Those Who Don’t Want to Stop at Beginner Level
Beginning SQL, 3rd Edition
Beginning SQL, 3rd Edition
Practical Introduction to Databases: Efficient SQL through the Relational Model
Practical Introduction to Databases: Efficient SQL through the Relational Model
SQL Anti-Patterns
SQL Anti-Patterns
Mastering SQL: A Comprehensive Guide for Advanced Beginners, 2nd Edition
Mastering SQL: A Comprehensive Guide for Advanced Beginners, 2nd Edition
Practical Introduction to SQL: Writing Fast and Understandable Queries
Practical Introduction to SQL: Writing Fast and Understandable Queries
What is a Database Index? How It Works and When You Need It
Understand how database indexes work internally—B-tree and hash structures—when to add or avoid indexes, and how to measure index effectiveness using EXPLAIN.
Database ID Design: UUID vs Auto Increment vs ULID — Which to Choose?
Compare auto-increment integers, UUIDs, and ULIDs as database IDs. Learn the trade-offs in performance, sortability, and distributed system compatibility.
NULL in Database Design: Common Pitfalls and Best Practices
Learn how NULL works in relational databases, the three-valued logic problem, common query mistakes with NULL, and schema design strategies to avoid NULL-related bugs.