Wulf's Webden

The Webden on WordPress

Thursday 22 August 2013
by Wulf
Comments Off on It’s a Monster!

It’s a Monster!

A WordPress question I still haven’t been able to find a decent answer to is how to keep the backend database, particularly the wp_postmeta table, under control. It currently weights in at 150MB and growing; tiny compared to modern storage … Continue reading

Tuesday 5 March 2013
by Wulf
Comments Off on Pushing My Vim Skills

Pushing My Vim Skills

Today’s tasks have included taking a list of identifiers and names and converting them into a series of SQL statements to create, populate and drop temporary database tables. If I just had one or two lines in the form: 56,DataIdentifier … Continue reading

Tuesday 12 February 2013
by Wulf
Comments Off on Data Shaping

Data Shaping

One of the challenges of working with databases is that the structures required to store data for maximum flexibility sometimes end up being an obstacle to providing quick answers to routine questions. I have been finding that at work recently, … Continue reading