Remastering chaostangent.com exhumed a question that had haunted me for years: how should I store the blog post content? On the face of it the answer seems straightforward: HTML. Just a big ol' blob of HTML, stored in a single database field, slapped onto a page, job's done. But what about all the bits that make a post interesting: the images, videos, maps, quizzes, and weird little joke functionality? How do you connect that opaque slab of HTML to resources that might change or disappear? Updating one post's hrefs and srcs is onerous, for hundreds it's a capital p Project. Surely there's got to be a better way. I've tried a few over the years and they were all lacking; my most recent attempt has (so far) been the least lacking.

chaostangent.com