All topics Archives

How to Migrate Nginx to Docker with Traefik as a Reverse Proxy

By Lê Hoàng Tâm September 21, 2024All topics, Architecture & Design, Ruby on RailsDocker, Nginx, Rails, Traefik, Wordpress

1. Problem I'm currently running Nginx on my Ubuntu server to host my Rails application. However, my app uses Kamal, which requires Traefik, and both Nginx and Traefik utilize ports…

REST vs gRPC: A Detailed Comparison for High-Performance APIs

By Lê Hoàng Tâm September 16, 2024All topics, Architecture & DesigngRPC, RESTFul API

RESTful APIs and gRPC are two popular approaches for building distributed systems and services, but they differ in architecture, communication protocols, performance, and use cases. Below is a detailed comparison…

Understanding PostgreSQL WAL and How It Can Save Your Data

By Lê Hoàng Tâm September 12, 2024All topics, Database, PostgreSQLDatabase, Point in time recovery, Postgresql, WAK, WAL

PostgreSQL’s Write-Ahead Logging (WAL) system is a fundamental component that ensures database durability, data integrity, and the ability to recover from crashes. If you've ever wondered how PostgreSQL can help…

Buffer Cache Hit in MySQL: What It Is and Why It Matters

By Lê Hoàng Tâm September 12, 2024All topics, Architecture & Design, Database, MySQLmysql, optimize database, optimize performance, Optimize Queries, optimize query

The InnoDB Buffer Pool in MySQL is essentially a cache that stores frequently accessed data (like table rows and index pages) in memory. This reduces the need for disk I/O…

MySQL Indexes: Boosting Query Performance with Column Order

By Lê Hoàng Tâm September 12, 2024All topics, Database, MySQLDatabase, mysql, optimize database, optimize index, optimize performance, optimize query

In MySQL, the order of columns in a composite index (an index that spans multiple columns) matters. The index is optimized based on the order of the columns, and this…

All topics

How to Migrate Nginx to Docker with Traefik as a Reverse Proxy

REST vs gRPC: A Detailed Comparison for High-Performance APIs

Understanding PostgreSQL WAL and How It Can Save Your Data

Buffer Cache Hit in MySQL: What It Is and Why It Matters

MySQL Indexes: Boosting Query Performance with Column Order

The secret of console in javascript

Top 10 secrets of Ruby

Understanding Threads and Processes in Ruby: Optimize Performance on Multi-Core CPUs

What is Ruby’s Global Interpreter Lock (GIL) and How to Overcome Its Limitations?