Bytes & B-Tree's
System Design RoadmapBytes & B-trees is a weekly newsletter for software engineers who want to understand databases from first principles — storage physics to distributed consensus. One production concept per issue, with working SQL scripts and demos in the GitHub vault.
| Platform |  | Pricing | Freemium | Publishes | Twice weekly |
|---|---|---|---|---|---|
| Issues | 23 | Founded | 4 months ago | Last Issue | 9 days ago |
| Active | |||||
Read this Newsletter
bytesbtrees.substack.comLatest Issues
Issue-018: B-trees — the balanced tree on disk
Every Postgres table has at least one B-tree index — the primary key.
Every Postgres table has at least one B-tree index — the primary key. Understanding the physical layout of that tree — pages, keys, pointers, splits — explains every ind...
Issue- 017: Row vs columnar storage — when each wins
Postgres stores your data row-by-row.
Postgres stores your data row-by-row. DuckDB, Redshift, and ClickHouse store it column-by-column. Same data, fundamentally different I/O cost for different query types. This is the single most conseque...
Issue-016: TOAST — variable-length columns & the hidden storage layer
Postgres has a second table you never created.
Postgres has a second table you never created. It stores your large column values and is queried every time you read them — but it never appears in EXPLAIN. This is TOAST, and understanding it...
Issue-015:-Pages, heaps & row storage anatomy
Every Postgres read and write moves exactly one 8,192-byte unit between disk and memory — regardless of how small the row you’re looking for.
Every Postgres read and write moves exactly one 8,192-byte unit between disk and memory — regardl...
Issue-014: Build It Yourself #1 — Part 3: Checkpointing and fast startup
Parts 1 and 2 fixed correctness and read performance.
Parts 1 and 2 fixed correctness and read performance. One problem remains: every restart scans the entire log to rebuild the index. For a 300,000-record log, that’s 600ms before the dat...
Audience Metrics
Subscribers, engagement, traffic and sponsorship for Bytes & B-Tree's.
| Subscribers | Engagement | 67 | Monthly Web Visits | ||
|---|---|---|---|---|---|
| Accepts Sponsors | Estimated Cost per Ad | ||||
Explore More
Authors
The writers behind this newsletter.
System Design Interview Roadmap - Step by step process that will make you comfortable, familiar and then expert at System Design.
Frequently Asked Questions
How can I access the email archive for Bytes & B-Tree's?
You can find recent issues that have been published by Bytes & B-Tree's on Reletter by scrolling up to where it says Latest Issues. Tap on the link for any of the most recent emails or hit More Issues to see older ones.
How many subscribers does Bytes & B-Tree's have?
To see how many people subscribe to Bytes & B-Tree's, simply upgrade your Reletter account. We provide readership numbers and lots of other stats for this newsletter so you can decide if it's worth reaching out to.
How can I advertise in Bytes & B-Tree's?
Newsletter advertising can be extremely effective when it's done right. Before you pitch Bytes & B-Tree's as a potential sponsor or partner, make sure that you've done your research and checked its newsletter stats with Reletter.
Then, personalize one of our winning pitching templates and send it to the right person using the contact info provided.
How much does it cost to sponsor a publication like Bytes & B-Tree's?
Newsletter ad rates (or CPM) vary depending on many factors, including industry, number of subscribers, open rate, ad placement and more.
To find out how much an ad will cost, contact Bytes & B-Tree's using the contact information provided and ask for a copy of their media kit.
How can I find newsletters related to Bytes & B-Tree's?
Scroll up to where it says Related Newsletters to see other publications like Bytes & B-Tree's. You can also search our email newsletter directory to discover other newsletters that cover the topics you're interested in.
How do I contact Bytes & B-Tree's?
Reletter provides this newsletter's website URL above, where you will often find their contact information. We also provide links to associated social media accounts and pitching templates so you can reach out fast.