the wonder of databases
20100217 12:54so much fun to have databases integrated with this piddly site. moving to a new blog location left thousands of stale pages needing redirects to their new versions. years ago, using blogger, i would’ve used an offline database to create manual redirects, uploading thousands of replacement HTML files. but with wordpress (or any DB-based system controlled by user) those redirects simply became a local table, and i can get rid of the vast blogger folder structure while keeping unbroken whatever links go to the old blog — including when i linked to a post in another post, as in the first one linked below, with three links to old blog posts.
though complicated — because links sometimes deviated from a simple pattern — it was still a batch process except for roughly 200 records requiring manual cut and paste (in excel, data from which was easy as hell to import via phpMyAdmin).
here, test it out: (more…)
