OPERATING SYSTEMS (how computers actually work) <a target="_blank" href="https://x.com/i/broadcasts/1pKdRRvlyeVJW" color="blue">x.com/i/broadcasts/1…</a>...
Know how long every operation takes on a computer. Once you do, identifying good vs bad vs acceptable performance becomes way easier. It all boils down to knowing your napkin math. ...
There's a million reasons why your app can be slow. The stack of software and hardware beneath are complex. Pinning down performance issues is challenging (but also, fun!) A clip from the chapter 1 stream. More to come this week. ...
Foreign keys vs constraints. Many conflate the two. Foreign key: A column that establishes a relationship between two tables. This is frequently set up as a column in one table (post) that stores primary key values from another table (user) so that it can join between the two. Foreign key constrai...
This is my favorite article on B-tree internals. Jeremy Cole has done MySQL at Twitter, Google, and Shopify. One of the most knowledgeable MySQL Engineers in the world, and his blog is an information goldmine. ...
