Ben Nadel discusses database index design, including Primary and Secondary indexes, surrogate and natural keys, uniqueness constraints, foreign keys, covering indexes, and even cow-path paving. His hope here is write the article on database index design that he wishes he had had access to way earlier in his web development career.
This series is likewise designed to help visionary friends, but where his friends were living off-the-grid, my friends are creating the programming environments of the future. This series is democratizing access to tools one-step removed. These reviews are for the makers of tools, those that are pushing our computational interfaces forward.