WordPress Database wpdb Power Tool and Reference
WordPress is run by database driven content. The primary PHP object used to handle the data is the $wpdb object. The WordPress Database WPDB Power Tool is a plugin designed to make development of WordPress plugins trouble free. It does this by providing access to the database while at the same time providing all the useful statistics needed to identify the status of your WordPress database.
At present there are twelve WordPress tables to the WordPress database which can all be easily viewed on the WPDB Tables tab of the WPDB Power Tool by clicking on the WPDB Tables Tab. The twelve tables are:
- commentmeta
- comments
- links
- options
- postmeta
- posts
- termmeta
- terms
- term_relationships
- term_taxonomy
- usermeta
- users
The comments and commentmeta tables are used if your WordPress site implements the use of comments. This can be useful for feedback but can also become time consuming with mediation. The links table contains all the information of links used in your site. This is becoming a more important part of the SEO on your website. Identifying what the link has in the description tells the user and the search engines what to expect at the link if done correctly. The options table contains specific options pertaining to plugins, pages and various other facets of your WordPress site. The postmeta table is to utilize meta data on posts and pages. This is used by Yoast for SEO, by WordPress for page features and image statistics. As well as page attributes. The posts table is the container for your posts and page content the core of your websites display content. The four terms tables termmeta, terms, term_relationships, term_taxonomy are used for all the terms used in your WordPress site and are important to SEO. The usermeta and users tables are for managing user privileges and access the the WordPress site pages, plugins and features. Understanding the WordPress database makes the wpdb object more useful.