Archive 2025

82 articles

About COLLATE in PostgreSQL
Database 2025-03-05

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.

#PostgreSQL
Differences in Sorting Order Due to COLLATE and glibc Version Differences in PostgreSQL
Database 2025-03-05

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.

#PostgreSQL
Current Status of FuelPHP as of February 2025 by AI
Application 2025-02-27

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.

#FuelPHP#PHP
Characteristics and Design of Nontemporal, Unitemporal, and Bitemporal
Database 2025-02-27

Characteristics and Design of Nontemporal, Unitemporal, and Bitemporal

Exploring the features, design examples, advantages, and disadvantages of different temporal data models.

#Bi-Temporal#Uni-Temporal#Non-Temporal#DB
Open Addressing Hash Tables and Swiss Tables
Algorithms and Data Structures 2025-02-27

Open Addressing Hash Tables and Swiss Tables

Explore open addressing, Swiss tables, collision resolution techniques, and cache-efficient hash table design.

#Open Addressing Hash Table#Swiss Table#Data Structures
Understanding Story Points Using the Cynefin Framework
Development Process 2025-02-26

Understanding Story Points Using the Cynefin Framework

An idea on how to think about the criteria for story points.

#Agile#Scrum
How to Split a Large Monolith? - Lessons from Software Architecture Hard Parts
Architecture 2025-02-17

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'.

#Architecture Strategy#Monolith#Microservices
Considering Architecture Strategy
Architecture 2025-02-16

Considering Architecture Strategy

Understand architecture strategy as systematic policy for building and evolving systems, covering vision, principles, and scalability planning.

#Architecture#Organizational Design#Design#System Design#Architecture Strategy
How to Read Books
Business 2025-02-15

How to Read Books

How to Read Books

#Book Review
Practical Introduction to Redis: From Technical Mechanisms to Real-World Applications
Database 2025-02-15

Practical Introduction to Redis: From Technical Mechanisms to Real-World Applications

Practical Introduction to Redis: From Technical Mechanisms to Real-World Applications

#Book Review#Redis#Cache#DB
How to Write Code That Fits in the Brain: Rules and Techniques for Avoiding Complexity and Ensuring Sustainability
Application 2025-02-15

How to Write Code That Fits in the Brain: Rules and Techniques for Avoiding Complexity and Ensuring Sustainability

How to Write Code That Fits in the Brain: Rules and Techniques for Avoiding Complexity and Ensuring Sustainability

#Book Review#Coding
Generative AI and the Career of Software Engineers
Career 2025-02-12

Generative AI and the Career of Software Engineers

The rapid evolution of generative AI is bringing significant changes to society. As a software engineer, anticipating these technological changes is crucial.

#Generative AI
About GraphQL Federation
Architecture 2025-02-02

About GraphQL Federation

A summary of what I researched about GraphQL federation.

#GraphQL#GraphQL Federation
Understanding the Linux Kernel through Illustrations
Operating Systems 2025-01-31

Understanding the Linux Kernel through Illustrations

Understanding the Linux Kernel through Illustrations

#Linux#Book Review#Kernel
Differences Between Instance Variables, Class Variables, and Class Instance Variables in Ruby
Application 2025-01-31

Differences Between Instance Variables, Class Variables, and Class Instance Variables in Ruby

Summarizing the differences between instance variables, class variables, and class instance variables in Ruby.

#Ruby
Implementing Singleton Pattern in Ruby
Application 2025-01-31

Implementing Singleton Pattern in Ruby

A summary of how to implement the Singleton pattern in Ruby.

#Ruby
Software Architecture Metrics: 10 Tips for Improving Architecture Quality
Architecture 2025-01-25

Software Architecture Metrics: 10 Tips for Improving Architecture Quality

Software Architecture Metrics: 10 Tips for Improving Architecture Quality

#Book Review#Architecture#Metrics
The Path to Staff Engineer: A Guide to Becoming an Excellent Technical Professional
Career 2025-01-23

The Path to Staff Engineer: A Guide to Becoming an Excellent Technical Professional

The Path to Staff Engineer: A Guide to Becoming an Excellent Technical Professional

#Book Review
Architect's Textbook: Building Software Architecture that Creates Value
Architecture 2025-01-13

Architect's Textbook: Building Software Architecture that Creates Value

Architect's Textbook: Building Software Architecture that Creates Value

#Architect#Architecture#Design#Fundamental Information Technology Engineer#Book Review
Metaprogramming Ruby 2nd Edition
Application 2025-01-06

Metaprogramming Ruby 2nd Edition

Metaprogramming Ruby 2nd Edition

#Book Review#Ruby