databaseinternals

Sharding v/s Partitioning

This article deep dives into the fundamental difference between Sharding and Partitioning and how they both support in scaling a system.

Oct 5, 2024 •

MySQL vs PostgreSQL: Replication

This post deep dives into the replication implementation of MySQL vs PostgreSQL

Sep 7, 2024 •

B-Tree vs B+ Tree: Key Differences Explained

This article deep dives into how data storage happens in a B-Tree and B+Tree.

Sep 1, 2024 •

A deep dive: What is LSM tree?

This article deep dives into what is an LSM tree and how does it work internally.

Aug 18, 2024 •

MySQL vs PostgreSQL: Indexing

This article deep dives into what is the difference in indexing in MySQL vs PostgreSQL

Jun 16, 2024 •

Transaction Isolation Levels

This article will deep dive into various transaction isolation levels, why do we need them and some examples

May 24, 2024 •

Relational vs Document based databases

This post deep dives into the key differences between relational and document-based databases and helps to find the factors to choose one.

Apr 27, 2024 •

Multi Version Concurrency Control

The main advantage of using multi-version concurrency control rather than traditional locking( read-write lock ) is that MVCC locks acquired for reading…

Apr 14, 2024 •

This post deep dive into Google spanner as a database, it's internal working and what's so special about it compared to other databases

Mar 31, 2024 •

Database Internals - Write Ahead Log File Structure

This article deep dives into the file structure of a write-ahead log file

Feb 11, 2024 •

Database Internals - Write Ahead Logging (WAL)

This article deep dives into what is write ahead logging and why is it a useful concept

Dec 30, 2023 •

Database Internals - Optimistic vs Pessimistic

This article deep dives into optimistic locking vs pessimistic locking and which one to use when!

Dec 24, 2023 •

#nojs-banner { position: fixed; bottom: 0; left: 0; padding: 16px 16px 16px 32px; width: 100%; box-sizing: border-box; background: red; color: white; font-family: -apple-system, "Segoe UI", Roboto, Helvetica, Arial, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol"; font-size: 13px; line-height: 13px; } #nojs-banner a { color: inherit; text-decoration: underline; } This site requires JavaScript to run correctly. Please turn on JavaScript or unblock scripts