Dylan Tweney
Notes

Database migration.

I spent way too much of last Sunday figuring out how to import over 300 articles from my database of published articles into WordPress, to make it easier to find and manage all that work. Those articles are now visible in the published work category here in my blog. I also switched this site to […]
Dylan Tweney 2 min read
Database migration.

I spent way too much of last Sunday figuring out how to import over 300 articles from my database of published articles into WordPress, to make it easier to find and manage all that work. Those articles are now visible in the published work category here in my blog.

I also switched this site to the impressively flexible and powerful Suffusion theme by sayontan, who provides excellent support for the theme on a public Suffusion support forum.

The old writing database was something I built a few years ago from scratch, using PHP with a MySQL database on the back end. It was a great learning experience and worked well for keeping track of, and showing off, work that I’d done as a freelancer. What I learned while building that database also helped me build the custom CMS that ran on tinywords from about 2004 until last year.

There’s something really satisfying about building one’s own content management system, no matter how simple or bare-bones. But in the end, managing content in a custom CMS gets to be a pain in the ass, and you look more and more enviously at the features that WordPress users keep getting, without any effort on their part. I was already using WordPress for this blog, so it made sense to consolidate it with my older database.

Fortunately WordPress has the ability to import RSS files, so Sunday’s work was mostly a matter of getting the RSS feed into the right format, making sure it included all the articles, and eliminating stray, non-ASCII characters. In other words, a lot of work tweaking PHP.

The WordPress RSS import tool doesn’t give you much feedback — it just works or it doesn’t — and there are no particular options, so it was mostly a matter of trial and error.

Again: a learning experience.

Share
More from Dylan Tweney
Notes

(Untitled)

It’s a challenge to walk in the Tenderloin and not become numb to the world around you. So much squalor and hopelessness. And yet you can still look up from a street corner and see a flock of birds flying out of the sunrise like messengers of the light. Could you see that light in […]
Dylan Tweney

Dylan Tweney

If you're bored, you're not paying attention

Great! You’ve successfully signed up.

Welcome back! You've successfully signed in.

You've successfully subscribed to Dylan Tweney.

Success! Check your email for magic link to sign-in.

Success! Your billing info has been updated.

Your billing was not updated.