Understanding PostgreSQL WAL and How It Can Save Your Data
PostgreSQL’s Write-Ahead Logging (WAL) system is a fundamental component that ensures database durability, data integrity,…
Database
PostgreSQL
Database
MySQL
Buffer Cache Hit in MySQL: What It Is and Why It Matters
The InnoDB Buffer Pool in MySQL is essentially a cache that stores frequently accessed data…
Database
MySQL Indexes: Boosting Query Performance with Column Order
In MySQL, the order of columns in a composite index (an index that spans multiple…
Database
MySQL
Ruby
[Mysql 8] Optimizing Snapshot Management Queries in TypeORM
When managing snapshots of items in a database, ensuring that only a limited number of…
Database
Shedding Some Light: How the DROP COLUMN Command Works in PostgreSQL
Imagine your PostgreSQL database as a filing cabinet. Over time, you might accumulate folders you…
Database
MySQL
PostgreSQL
Tips
How to get `previous` and `next` record in PostgreSQL/ MySQL with LAG and LEAD function
1 bài toán cơ bản, nhỏ nhỏ lúc làm việc thôi. Đề bài là: Tìm…