SQLite Index Visualization
Explores SQLite B-Tree index structure with visualizations, explaining on-disk and in-memory storage mechanisms
Database “sharding” came from Ultima Online? (2009)
Lessons Learned: Sharding for startups is a technical post about database scalability. What caught my eye was the term . What an odd term — “sharding.” Why would a database be described that way?
The biggest source of waste is untapped skilled pragmatists
The biggest source of waste is not low performers or having too many employees.
We need technology that is less immersive, not more
How come so many of the most talented engineers of our time work on making our entertainment more immersive?
The global surveillance free-for-all in mobile ad data
Not long ago, the ability to digitally track someone’s daily movements just by knowing their home address, employer, or place of worship was considered a dangerous power that should remain only within the purview of nation states. But a new lawsuit in a likely constitutional battle over a New Jersey privacy law shows…
A BBC navigation bar component broke depending on the external monitor
Recently, my team and I fixed an absolutely bizarre bug that only one person in the team could reproduce. And to make it even weirder, she was only able to reproduce the issue when using her work laptop at home; it worked fine with the same laptop in the office.
A Taxonomy of Tech Debt (2018)
Hi there. I’m Bill “LtRandolph” Clark, and I’m the engineering manager for the Champions team on LoL . I’ve worked on several different teams on League over the past years, but one focus has been consistent: I’m obsessed with tech debt. I…
The Lego Great Ball Contraption
The Great Ball Contraption is a class of machines built with Lego that transport small balls from place to place in many different ways. The otherwise pointless
Apple's risky bet on CarPlay
What is Apple's strategy with CarPlay?
Does your startup need complex cloud infrastructure?
Notes about startups, AI, health-care and overall engineering
Spotify has shut down several API endpoints
To increase security we are limiting access to certain Web API endpoints for new applications.
How to Be More Agentic
On a supposedly difficult thing
Cities need more trees
A case for planting more trees in urban areas.
Power Metal: is it really about dragons? (2018)
Some years ago, Matt Daniels [1] wrote a great article on who has the largest vocabulary in hip-hop. I thought it was brilliant: comparing Shakespeare to famous hip-hop artists. It got me thinking and gave me the inspiration of doing something similar with a genre I love: Power Metal. People …
Database Design for Google Calendar: A Tutorial
Author: Alexey Makhotkin squadette@gmail.com. Introduction In this database design tutorial (~9000 words) I’m going to show how to design the database tables for a real-world project of substantial complexity. We’ll design a clone of Google Calendar. We will model as much as possible of the functionality that is…
The one-year anniversary of my total glossectomy
One year ago today, I went into surgery expecting that I’d lose half my tongue to a squamous cell carcinoma recurrence. The evening before, Bess and I got legally married;[1] it was a short, but ch…
We Could Fix Everything, We Just Don't
[programmers frantically pulling cables out of the wall]AI: "Nuclear power. Double teachers' salaries. Build more houses. Distribute food more fairly. TRAINS—"— qntmyrrh (@qntm) November 24, 2023 I remember growing up with that same old adage of how you could be the next scientist to invent a cure for cancer, or a…
From engineer to manager: what I love, what I hate
It's been almost 2 years since I moved to a team lead role, then to a full-time engineering management position after the expansion of our team. I've been a front-end developer for 7 years before that, and initially I took the "advanced individual contributor" career track before doing the management turnaround. How's…
Secure Randomness in Go 1.22
ChaCha8Rand is a new cryptographically secure pseudorandom number generator used in Go 1.22.
I accidentally deleted a bad game revision from MAME
Awhile back, I had the chance to dump a game for MAME. I told myself that if the chance ever came up again, I’d contribute again. Luckily, it turns...
A Simple ELF
The Ivory Tower is a blog about software engineering and development philosophy by Anders Sundman.