Posts
All the articles I've posted.
-
Adding Columns to SQL Table: The Hidden Performance Impact
Understand what really happens when you add columns to large SQL tables, the performance implications, and strategies to minimize downtime in production systems.
-
Change Data Capture (CDC) and its Magic
Explore Change Data Capture mechanisms and reactive databases like DiceDB, understanding their architectures, use cases, and fundamental differences in handling data changes.
-
Write-Ahead Logging: The Engine Behind Database Durability and Implemening it
Explore how Write-Ahead Logging powers database durability, its critical role in ACID compliance, and my implementation in Golang.
-
Protobuffers vs JSON over HTTP
A performance comparison between Protocol Buffers and JSON for data transfer over HTTP, with benchmark results showing why binary protocols are often faster and more efficient.
-
Read and Write in a File based Database: Creating Cool DB-I
Explore different file storage methods, their advantages and disadvantages, and why binary storage is often preferred for performance and efficiency.