✅ Database Archives

7 Essential Caching Strategies to Boost Backend Performance and Scalability

By Hoài Nhớ November 13, 2024All topicsCaching, cdn, Database, optimize database, optimize performance, redis

Discover 6 powerful caching strategies to enhance backend performance and scalability. From in-memory and distributed caching to hybrid solutions, learn how to implement effective caching in your backend architecture for faster response times and optimized resource use

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…

A Deep Dive into Schema-Based Multi-Tenancy: Scaling, Maintenance, and Best Practices

By Lê Hoàng Tâm September 25, 2024All topics, Architecture & Design, Database, PostgreSQL, Ruby on RailsDatabase, Postgresql

Introduction As your application scales and serves multiple tenants, choosing the right multi-tenancy architecture is critical. One popular approach in the Rails ecosystem is schema-based multi-tenancy, particularly with PostgreSQL. In…

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…

Database

7 Essential Caching Strategies to Boost Backend Performance and Scalability

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

Postgres Index Methods: Things you need to know

A Deep Dive into Schema-Based Multi-Tenancy: Scaling, Maintenance, and Best Practices

Understanding PostgreSQL WAL and How It Can Save Your Data

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?