Archives
Categories
Archive for February 2009
WordPress Schema
WordPress is a pretty cool blogging application, and the current version 2.7 is leap ahead from the old version I was used to using. It made sense to use the functionality provided by WordPress to drive the back end of the blog on our website, but in order to fully integrate it into the rest of the site we built the public-facing front end from scratch. During the development, the newer version of WordPress was released, so at the last minute prior to lanch we had to refactor the code to work with the revised database structure implemented in WordPress 2.7.
In order to make life simpler, and as an aid to getting my head around the project, I drew out the the WordPress database schema using OmniGraffle - a wonderful tool for producing elegant diagrams and flowcharts very quickly. Having the database schema laid out on a sheet of paper for reference during the development was a real help. The table and column names were always to hand and joining tables was breeze with all the relationships clearly identified.
You can download the PDF of the WordPress v2.7 schema diagram here.
Subscribe »Why Do We have A Blog?
There are several very good reasons why we have incorporated a blog into our web site. It’s relatively simple to do after all.
- A blog is great tool for quickly adding new content to a web site. We chose WordPress, and its ease of use means we are more likely to keep updating the site on a regular basis, whenever one of us has ten minutes to spare.
- Visitors like fresh content. Keeping the site updated will encourage people to come back again and again. It all helps when building an online presence and winning customer mindshare.
- Search engines like fresh content too. As long as we keep it relevant it all counts towards ratings.
- We’re creative types, and blogging is form of self-expression. When we’ve got something to say it won’t do to bottle it up.
- We’re good at what we do, and blogging about it is way of proving it to the world.
It all makes sense doesn’t it. Perhaps you should have a blog on your web site. Don’t think about it for too long though - give us a call…