Database Archives

Enhancing Text Search in MySQL: A Comparison of SOUNDEX and Full-Text Search

By Lê Hoàng Tâm November 8, 2024All topics, Database, MySQLDatabase, mysql, text search

In many applications, efficient text search capabilities are critical for delivering fast and relevant results to users. MySQL provides several tools to facilitate text searching, including SOUNDEX and Full-Text Search.…

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…

Understanding the Limits of LIMIT and OFFSET for Large Datasets

By Lê Hoàng Tâm October 17, 2024All topics, Database, MySQL, PostgreSQL

Introduction When dealing with large datasets (e.g., over 100 million records), using LIMIT and OFFSET for pagination can lead to significant performance problems. This post will explain how the algorithm…

Mastering Databases: From Optimizing Queries to Distributed Systems

By Hoài Nhớ October 17, 2024Database, MySQL, NoSQL, PostgreSQL, TipsBackup Database, Database Replica, Optimize Queries, Popular, Scalability Database

Databases are at the core of modern applications, from e-commerce to social platforms, powering billions of transactions every second. In this blog, we’ll explore key concepts that every software engineer…

Database

Enhancing Text Search in MySQL: A Comparison of SOUNDEX and Full-Text Search

Postgres Index Methods: Things you need to know

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

Understanding the Limits of LIMIT and OFFSET for Large Datasets

Mastering Databases: From Optimizing Queries to Distributed Systems

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?