/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.
You are here

 planetscale.com
B-trees and database indexes - PlanetScale
| | surfingcomplexity.blog
Modeling B-trees in TLA+ - Surfing Complexity
2.2 parsecs away

Travel
| | I've been reading Alex Petrov's Database Internals to learn more about how databases are implemented. One of the topics covered in the book is a data structure known as the B-tree. Relational databases like Postgres, MySQL, and sqlite use B-trees as the data structure for storing the data on disk. I was reading along with...
| | architecturenotes.co
Relational Databases Explained
2.2 parsecs away

Travel
| | How Relational Databases Work. This post talks about how indexes and transactions work on the inside of relational databases.
| | rcoh.me
Postgres Indexes Under the Hood
2.6 parsecs away

Travel
| | Many software engineers use database indexes every day, but few of us really understand how they work. In this post I'll explain: How indexing works in Postgres using B-Trees What B-Trees are Why they are a good fit for this problem Indexes in Postgres Postgres actually offers 4 different kinds of indexes for different use cases. In this post I'll be focusing on the "normal" index, the kind you get by default when you run create index.
| | lucianonooijen.com
My favourite way to handle SQL in Golang ยท Luciano Nooijen
29.8 parsecs away

Travel
| How to best handle SQL logic in Golang applications for migrations and queries