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...
Transport Layer Security (TLS): Securing Network Communication Modern internet security relies heavily on encryption, particularly through Transport Layer Security (TLS). Let’s explore how we’ve e...
The Network Journey Behind Clicking a Link When you click a hyperlink in your browser, a complex sequence of networking events occurs: DNS Resolution: The domain name (e.g., pravin.dev) is res...