Database Blogs
Write-Ahead Logging (WAL)
Write-Ahead Logging (WAL) is a database technique where every change is first written to an append-only log before the database files, to keep data safe in a crash.
Composite Index in Database
A Composite Index is an index created using multiple columns of a table. It speeds up queries on those columns, and the order of the columns matters a lot.
Database Normalization vs Denormalization
Database normalization focuses on reducing data duplication and keeping data correct, whereas denormalization focuses on making the queries faster.