September 12, 2024

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…

NestJS vs. Ruby on Rails: A Full Comparison

By Lê Hoàng Tâm September 12, 2024All topics, NodeJS, Notes, RubyRuby on rails

I want to have full insight about it because I'm going to build new application which can scale horizontal, optimize and less development cost. If you have same question, let's…

Day: September 12, 2024

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

NestJS vs. Ruby on Rails: A Full Comparison

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?