All topics Archives

The secret of Locking Behavior in Mysql and Postgres

By Lê Hoàng Tâm October 24, 2024All topics

The default locking behavior of MySQL and PostgreSQL can affect how transactions interact with one another. Below, I’ll explain the default behavior for both databases and provide a revised example…

Postgres Index Methods: Things you need to know

By Lê Hoàng Tâm October 22, 2024All topics, Database, PostgreSQLDatabase, optimize performance, Postgresql

In PostgreSQL, different types of index methods are used to optimize query performance, especially for large datasets. These methods include B-tree, GiST, GIN, and BRIN, and each serves a specific…

How to prevent table lock when add/drop index in Postgres?

By Lê Hoàng Tâm October 21, 2024All topics, Architecture & Design, Database, PostgreSQLoptimize performance, Postgresql

The CONCURRENTLY option in PostgreSQL is used when creating or dropping indexes to avoid locking the entire table during the process. It's especially useful in production environments where you want…

Behind the Scenes of Ruby Objects lifecycle

By Lê Hoàng Tâm October 21, 2024All topics, Rubyoptimize performance, ruby, Ruby on rails

In Ruby, objects form the core of the language. Everything in Ruby is an object—from numbers and strings to classes themselves. Understanding the Ruby Object Lifecycle can help you write…

3 Common Website Attacks You Need to Know

By Lê Hoàng Tâm October 18, 2024All topics, Architecture & Design, Securitycsrf, protect data, sql injection, xss

In today's digital world, websites are constantly targeted by cybercriminals. Some of the most dangerous threats are SQL Injection (SQLi), Cross-Site Scripting (XSS), and Cross-Site Request Forgery (CSRF). These attacks…

All topics

The secret of Locking Behavior in Mysql and Postgres

Postgres Index Methods: Things you need to know

How to prevent table lock when add/drop index in Postgres?

Behind the Scenes of Ruby Objects lifecycle

3 Common Website Attacks You Need to Know

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?