Mar 6 · 8 min read · I've seen juniors jump straight into writing schema code without stopping to think about how their collections relate to each other. Then halfway through the project, they realize their data model is
Join discussionJan 26 · 6 min read · Project Summary This project explores the Sakila DVD rental database using SQL, DuckDB, Python, and Evidence. The goal is to understand the data and find patterns in movies, customers, and revenue. The data is loaded from a SQLite database into DuckD...
Join discussion
Jan 24 · 4 min read · If you’ve ever wondered how massive companies like Amazon or Netflix keep track of millions of customers and orders without losing their minds, the answer is the Relational Data Model. It sounds technical, but it’s actually a very logical way of orga...
Join discussion
Jan 19 · 6 min read · Originally published on tudor96stani.com Intro Insertion in heap pages is, in theory, straightforward: you find some free space in the page, place the row there and create a slot pointing to that location. There are, however, multiple small details t...
Join discussionJan 14 · 12 min read · Databases are a crucial tool because they store the data that power our day-to-day lives. Databases are designed to match the real world as much as possible, so they store data of different forms, about different things, just as it is in the world. T...
Join discussion
Jan 12 · 5 min read · Systems don’t stay where they started In Designing Data-Intensive Applications, Martin Kleppmann uses the term evolvability in a very practical way: real systems tend to not stay where they started.You design a service with one set of assumptions lik...
Join discussionJan 12 · 2 min read · This book is not a book for beginners. A good exposure to different SQL products will help you learn what concepts run on the database products that you use. Although the book doesn’t reference specific products, it focuses on relational model concep...
Join discussionJan 5 · 7 min read · Originally published on tudor96stani.com intro Christmas, New Year's, a 1-week ski trip, time with family, the rabbit hole of a full re-organization of my Obsidian vault into a Zettelkasten slip box after reading How to take smart notes - all of thes...
Join discussionJan 5 · 3 min read · A relational database organises data into tables (rows and columns) with relationships between them. Key Components: Rows (Records): Each row represents a single entry Columns (Fields): Each column represents a specific attribute Primary Key: Uniq...
Join discussion