Curious Engineer
Subscribe
Sign in
Home
Notes
Chat
1:1 with me
Database Internals
Algorithms
System Design Study
databaseinternals
Latest
Top
Discussions
MySQL vs PostgreSQL: Replication
This post deep dives into the replication implementation of MySQL vs PostgreSQL
Sep 7
•
Vivek Bansal
15
Share this post
MySQL vs PostgreSQL: Replication
vivekbansal.substack.com
Copy link
Facebook
Email
Note
Other
1
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
•
Vivek Bansal
24
Share this post
B-Tree vs B+ Tree: Key Differences Explained
vivekbansal.substack.com
Copy link
Facebook
Email
Note
Other
7
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
•
Vivek Bansal
33
Share this post
A deep dive: What is LSM tree?
vivekbansal.substack.com
Copy link
Facebook
Email
Note
Other
6
MySQL vs PostgreSQL: Indexing
This article deep dives into what is the difference in indexing in MySQL vs PostgreSQL
Jun 16
•
Vivek Bansal
18
Share this post
MySQL vs PostgreSQL: Indexing
vivekbansal.substack.com
Copy link
Facebook
Email
Note
Other
2
Transaction Isolation Levels
This article will deep dive into various transaction isolation levels, why do we need them and some examples
May 24
•
Vivek Bansal
10
Share this post
Transaction Isolation Levels
vivekbansal.substack.com
Copy link
Facebook
Email
Note
Other
1
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
•
Vivek Bansal
11
Share this post
Relational vs Document based databases
vivekbansal.substack.com
Copy link
Facebook
Email
Note
Other
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
•
Vivek Bansal
15
Share this post
Multi Version Concurrency Control
vivekbansal.substack.com
Copy link
Facebook
Email
Note
Other
3
Google Spanner
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
•
Vivek Bansal
7
Share this post
Google Spanner
vivekbansal.substack.com
Copy link
Facebook
Email
Note
Other
Database Internals - Write Ahead Log File Structure
This article deep dives into the file structure of a write-ahead log file
Feb 11
•
Vivek Bansal
7
Share this post
Database Internals - Write Ahead Log File Structure
vivekbansal.substack.com
Copy link
Facebook
Email
Note
Other
5
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
•
Vivek Bansal
17
Share this post
Database Internals - Write Ahead Logging (WAL)
vivekbansal.substack.com
Copy link
Facebook
Email
Note
Other
4
Database Internals - Optimistic vs Pessimistic
This article deep dives into optimistic locking vs pessimistic locking and which one to use when!
Dec 24, 2023
•
Vivek Bansal
14
Share this post
Database Internals - Optimistic vs Pessimistic
vivekbansal.substack.com
Copy link
Facebook
Email
Note
Other
1
Database Internals: ACID transactions
This article deep dive into what are ACID transactions and why are they relevant in today's world
Dec 14, 2023
•
Vivek Bansal
9
Share this post
Database Internals: ACID transactions
vivekbansal.substack.com
Copy link
Facebook
Email
Note
Other
1
Share
Copy link
Facebook
Email
Note
Other
This site requires JavaScript to run correctly. Please
turn on JavaScript
or unblock scripts