Archive 2024
121 articles
Introduction to System Metrics with ISUCON Environment
A summary of regular study sessions using the ISUCON environment to properly understand system metrics.
The Art of Writing a CFP
Craft compelling conference CFPs using blog-writing, organization techniques, and structured presentation development methodology.
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
MySQL Locks Explained: Preventing Deadlocks and Improving Performance
Understand MySQL locking mechanisms—table locks, row locks, gap locks, and intent locks. Learn how deadlocks occur and how to prevent and diagnose them effectively.
Knowledge and Skills of Accounting Systems for Engineers
Knowledge and Skills of Accounting Systems for Engineers
Knowledge and Technology of Financial Systems for Engineers
Knowledge and Technology of Financial Systems for Engineers
Knowledge and Skills of Inventory Management Systems for Engineers
Knowledge and Skills of Inventory Management Systems for Engineers
Knowledge and Skills of Production Management Systems for Engineers
Knowledge and Skills of Production Management Systems for Engineers
Knowledge and Technology of Logistics Systems for Engineers
Knowledge and Technology of Logistics Systems for Engineers
Database Normalization Explained: 1NF to 3NF with Examples
Learn database normalization from first principles. Understand 1NF, 2NF, and 3NF with practical examples and when denormalization is the right trade-off for performance.
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.
Capacity Planning - Maximizing Resources through Site Analysis, Forecasting, and Placement
Capacity Planning - Maximizing Resources through Site Analysis, Forecasting, and Placement
About Capacity Planning
Plan system capacity by analyzing performance requirements, measuring infrastructure, forecasting needs, and setting safety factors.
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.