MemCached In-Memory database Architecture Memcached Architecture Memcached is an in-memory key-value store originally written in Perl and later rewritten in C. It is popular with companies such a...

Concurrency Control Exclusive Lock vs Shared Lock Exclusive locks and shared locks are mechanisms used in database systems to manage concurrent access to data. Let’s explain these concepts with a...

Sharding with Postgres Simple Java Implementation for Database Sharding: URL Shortener Example Step 1: Table Creation First, we’ll create a simple table for our URL shortener on each shard. Here...

Table of Contents B-Tree vs B+ Tree in Production Database Systems Full Table Scans B-Tree B-Tree limitations [B+Tree] [B+Tree Considerations] B+Tree storage cost in MySQL vs Postgres...

Article - The Cost of Long running Transactions The cost of a long-running update transaction that eventually failed in Postgres (or any other database for that matter. In Postgres, any DML trans...

Article - Microsoft SQL Server Clustered Index Design This is one of the most interesting documentation pages I have read and I really thought I would share it with you. You can read the entire de...

Databases Pages (Article) Database Pages — A deep dive Databases often use fixed-size pages to store data. Tables, collections, rows, columns, indexes, sequences, documents and more eventually en...

Table of Contents ACID Properties Understanding Database Internals Row-Based vs Column-Based Databases Primary Key vs Secondary Key Database Indexing SQL Query Planner and Optimizer ...

System design interviews are a critical part of the hiring process for software engineering roles, especially for senior positions. These interviews assess your ability to design scalable, maintain...

Finally, let’s touch on a few more advanced topics, including database access control, network analysis tools, and challenges in protocol evolution, before concluding with a reflection on the impor...