Blog
Articles, guides, and notes on software engineering.
Knowledge and Skills of Production Management Systems for Engineers
Knowledge and Skills of Production Management Systems for Engineers
Recent Posts
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.
One-liner to Unlock Password-Protected PDFs
Decrypt password-protected PDFs using QPDF—a powerful command-line tool for removing PDF password restrictions securely.
Kubernetes Components Explained: Pods, Nodes, and the Control Plane
Understand the core Kubernetes components—pods, nodes, API server, scheduler, etcd, and kubelet—and how they work together to run containerized workloads.
Jobs Theory
Jobs Theory
Notes on Spanner Insights
Explore Cloud Spanner architecture, replication strategies, indexing, and performance optimization for distributed databases.
NGINX Buffer Directives Explained: Optimizing Proxy Performance
Notes taken while researching buffer sizes in NGINX.
A List to Understand SaaS Architecture
A compilation of resources to transition from knowing nothing about SaaS to fully understanding it.
Practical Email Technology Handbook: From Basic Mechanisms to Protocols, Server Setup, Sending Domain Authentication, Attachments, Encryption, and Security Measures
Practical Email Technology Handbook: From Basic Mechanisms to Protocols, Server Setup, Sending Domain Authentication, Attachments, Encryption, and Security Measures