Blog
Articles, guides, and notes on software engineering.
Summary of PostgreSQL Logical Replication Specifications
Learn PostgreSQL logical replication: how it differs from physical replication, publisher/subscriber setup with Docker, wal_level configuration, replication slots, and CREATE SUBSCRIPTION.
Recent Posts
About Row Level Security (RLS) in PostgreSQL
Master PostgreSQL Row Level Security with PERMISSIVE and RESTRICTIVE policies for multi-tenant data isolation and access control.
Bounded Contexts
Understand bounded contexts in domain-driven design to clarify word meanings, organize responsibilities, and improve system design.
Structure of My System Specification Document
Learn to structure system specification documents with sections for architecture, data models, APIs, and sequence diagrams for design clarity.
What is Open Policy Agent (OPA)? A Practical Guide to Policy as Code
Learn what Open Policy Agent (OPA) is, how policy as code works, and practical examples of using OPA to centralize authorization logic in your infrastructure.
Communication Guide for Developers and Architects: Learning Information Transmission through Patterns
A book discussing communication through visual information, text, language, non-verbal cues, and documentation.
Building Multi-Tenant SaaS Architecture - Principles, Best Practices, AWS Architecture Patterns
Design multitenant SaaS architecture patterns: control plane, application plane, tenant routing, and data partitioning strategies.
Implementation of Access Control System for Microservices Using OPA
Implement fine-grained access control for distributed microservices using Open Policy Agent and declarative Rego policy language.
Optimal Architecture Strategy for Requirements
Optimal Architecture Strategy for Requirements
A Practical Guide to Backup: From Basic Concepts to Tool Utilization, Differential Management, Generation Management, Data Preservation, Restore, Recovery, and Ensuring Availability
A Practical Guide to Backup: From Basic Concepts to Tool Utilization, Differential Management, Generation Management, Data Preservation, Restore, Recovery, and Ensuring Availability
Troubleshooting 'configure' Errors During PostgreSQL Installation
Fix the You need to run the configure program first error when compiling PostgreSQL from source. Covers ./configure options, re-running make, and common dependency issues on Ubuntu/CentOS.
About COLLATE in PostgreSQL
Learn how COLLATE works in PostgreSQL for string sorting and comparison. Covers database-level and column-level settings, checking collation with pg_database, and tips for Japanese locale.
Differences in Sorting Order Due to COLLATE and glibc Version Differences in PostgreSQL
Encountered an issue where sorting order differs despite specifying the same COLLATE setting, and documented the investigation.
Current Status of FuelPHP as of February 2025 by AI
Understand FuelPHP's current status in 2025: EOL 1.x series, PHP8 compatibility with 1.9-dev, and community migration trends.
Characteristics and Design of Nontemporal, Unitemporal, and Bitemporal
Exploring the features, design examples, advantages, and disadvantages of different temporal data models.
Open Addressing Hash Tables and Swiss Tables
Explore open addressing, Swiss tables, collision resolution techniques, and cache-efficient hash table design.
Understanding Story Points Using the Cynefin Framework
An idea on how to think about the criteria for story points.
How to Split a Large Monolith? - Lessons from Software Architecture Hard Parts
This article organizes useful points for considering service division from a monolith, based on chapters 1 to 4 of 'Software Architecture: The Hard Parts'.
Considering Architecture Strategy
Understand architecture strategy as systematic policy for building and evolving systems, covering vision, principles, and scalability planning.
How to Read Books
How to Read Books