Welcome

In part 1 I covered the basics: OLTP vs OLAP, row and column storage, and a quick overview of storage engines and indexes. I ended that post saying I’d go deeper into how databases actually persist data to disk. So here we go. B-Trees If you’ve worked with databases for any amount of time, you’ve probably heard of B-Trees. They’re the most widely used data structure for database indexing, and for good reason. ...

If you’re reading this, I assume you’re already used to Git and all the benefits it brings. It is fast, stable, and full of features. In fact, Git is one of those tools where I have a feeling I’ll never use all its features. One of those features that changed the way I work is git worktree, and I wanted to share why. Branching strategies There are many ways to work with Git — things like trunk-based development, Gitflow, and many others. The strategy may vary depending on the project/company you work for, but it usually works like this: a person creates a new branch, and once the changes are completed, this branch gets merged into the main one. This is good for many reasons, but especially because we have a designated “main” branch that is supposed to always be in a clean state (or most of the time). ...

This is part 1 of a series where I document what I’m learning about database internals. Why I’m Exploring This I’ve been using databases since the beginning of my career, but I recently realized I knew very little about how they actually work. I could write queries, design schemas, and optimize indexes — but what happens under the hood? I had no idea. So I decided to dig in. This series is me sharing what I find along the way. Not a comprehensive guide, just my notes and perspective as I explore. ...

Welcome to my blog! I’m a software engineer, and this is where I’ll be sharing my thoughts on technology, programming, and everything in between. What to Expect The main reason for this blog to exist is that I want a place to centralize my topics of interest. Whether I’m learning something new, working on an interesting project, or reading a book—if I think it’s worth storing, I’ll write about it here. ...