WordPress Bits

Hacking WordPress. Keeping the bits together.

Archive for the ‘Database’ Category

Tip #5 : Taxonomy in WordPress 2.3

Posted by Leonid Mamchenkov on August 27, 2007

The upcoming release of WordPress 2.3 introduces a new way of tagging and categorizing posts and links.   It replaces the old way of categories and should provide enough flexibility to replace a whole bunch of plugins.  Or, at least, make those plugins much simpler.

This new feature required a few changes in the WordPress database scheme. Gladly, Ryan Boren has posted the description of changes in the database structure.


Posted in Database, WordPress, WordPress Tips | 15 Comments »

WordPress Options follow-up

Posted by Leonid Mamchenkov on August 12, 2007

After the “Quick access to WordPress options” post got published, I’ve got plenty of questions, most of which could be rephrased as one of the two:

  1. What does each displayed option mean?
  2. How can I delete unused options?

While a comprehensive description of each option is yet to be done, I thought I’d do another post with a few links that might clear up some confusion.

Read the rest of this entry »

Posted in Database, Options, Plugins, WordPress | 5 Comments »

Automating WordPress customizations – the install.php way

Posted by Leonid Mamchenkov on August 10, 2007

In “Automating WordPress customizations – the plugin way” we looked at how to change a whole bunch of thing in one go by having our own plugin.  The plugin approach can save a lot of time, but it does not actually give any control over the installation process.

Often we want to interfere with the way things are.  For example, upon successful WordPress installation you find a web site with one post (“Hello World!”), one page (“About”), and a test comment to the first post.  Also, there is a category “Uncategorized”, and “admin” user, and a few other things in the database, which are not so obvious (for example, user roles, such as Administrator, Editor, and Subscriber).

There are also a few things, which are happening during the installation process itself.  For example, a random password for the administrator is generation, and email is sent to the administrator’s address with credentials and new site details.  As handy as it is for a friend’s new blog, there are many situations when we don’t want this done, or want it done differently.

WordPress has a way to control installation flow via a custom install.php file, which saves you from all the problems of core files editing.  In this post, we’ll see how to use this feature and what can actually be done with it.

Read the rest of this entry »

Posted in Database, Options, WordPress | 31 Comments »

A look inside the WordPress database

Posted by Leonid Mamchenkov on August 8, 2007

Update: This article is also available in Chinese (thanks to Denis).

WordPress, as most other modern content management systems, is a very database-centric application. It keeps all information in the database – blog settings, posts, comments, links, users, etc. Therefor it is important to understand how the database is organized, what types of data is stored there, and how different things are linked to each other.

Read the rest of this entry »

Posted in Database, WordPress | 95 Comments »