I discovered databases by accident about a year ago. We had a school project where we needed to build a very basic web app and store some data. We used SQLite for simplicity.
After wiring everything up and running my first query, I thought to myself: this seems too easy for something that must be so complex under the hood. So I googled what actually happens when you write something like this:
INSERT INTO table1 (column1)That’s when I discovered a whole world of internals and complexity I had no idea existed.
Curious to understand more, I decided to dig in. Starting by reprogramming SQLite from scratch, then later contributing to open source projects like TursoDB.
I’ve now been learning and practicing for a while, and I don’t plan on stopping anytime soon. Here are the resources I used along the way. I hope they help other curious minds too.
I follow Andy Pavlo’s course. Mikaël Francoeur recommended it to me. It is a great course, with simple explanations, exercises, and 5 projects.