Database

Writing about development and technology.

Database·July 10, 2025

SQL vs NoSQL: The Ultimate Textbook of Database Architecture

The definitive guide for Architects. Covers Storage Engines, Distributed Systems Theory (CAP, PACELC), Transactions, Sharding, Glossary, and FAQ.

#Database#SQL#NoSQL#Backend

SQL vs NoSQL: The Ultimate Textbook of Database Architecture

Database·May 16, 2025

Database Indexing: Why B-Tree is the King of Databases

A comprehensive guide to Database Indexing. Understanding the B-Tree structure, the difference between Clustered and Non-Clustered Indexes, and why Hash Indexes are rarely used for range queries. Includes a dedicated section on 'The Index Usage Anti-Patterns'.

#Database#SQL#Optimization#Data Structure

Database Indexing: Why B-Tree is the King of Databases