✅ Database Archives

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…

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…

Shedding Some Light: How the DROP COLUMN Command Works in PostgreSQL

By Lê Hoàng Tâm April 18, 2024DatabaseDatabase, Postgresql, SQL

Imagine your PostgreSQL database as a filing cabinet. Over time, you might accumulate folders you no longer need. The DROP COLUMN command acts like a handy tool to declutter your…

Database

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

Understanding PostgreSQL WAL and How It Can Save Your Data

MySQL Indexes: Boosting Query Performance with Column Order

Shedding Some Light: How the DROP COLUMN Command Works in PostgreSQL

React Coin Celebration Animation Component | Interactive Particle Effects

Master Gradient Text Animations: A Beginner-Friendly Guide with CSS

Creating Stylish Folded Tags in ReactJS Using Clip-Path

Understanding the Magic Behind the Gradient Border Effect in CSS