Database Peek allows admins to view the database content in a user friendly and safe way.
|Author:||Albert Bertilsson (profile at wordpress.org)|
|WordPress version required:||3.0.1|
|WordPress version tested:||3.3.2|
|Added to WordPress repository:||13-02-2012|
Warning! This plugin has not been updated in over 2 years. It may no longer be maintained or supported and may have compatibility issues when used with more recent versions of WordPress.
|Total downloads:||8 225|
Click to start download
For those with a need to look at the pure contents of the WordPress database. The plugin gives admins a user friendly and safe way to display the tables of the database as well as show the detailed information of the tables and view each row of data including rows in other tables referring to the displayed row.
Functionality for filtering and sorting makes it very easy to get a good overview and find specific data. Integration with other parts of the administration tool makes it quick and easy to browse and examine various entities in the database.
This is not a replacement to having access to the WordPress database but it provides several benefits:
- Developers can get a quick way to view and verify database contents without having database access.
- Overview pages with clickable links to navigate is a lot faster than typing SQL (at least for me).
- Access to tables is verified against the current user access rights, should be safe.
- Quick access to basic table column statistics.
- Added statistics for tables to get a rough overview of the data in a table.
- Changed integration from using metaboxes to adding a button next to the permalink in the admin UI.
- Added link to settings from the plugin admin page.
- Added blog name column to table listing.
- Display more data in fields when displaying a single item. (Eg: post_content)
- Display nice message when single item is missing, instead of empty view.
- Fixed bug in the function that created links between tables.
- Code clean up, separate file for options.
- Added settings option to add shortcut links on edit page for pages and posts.
- Added shortcut links on listing pages for pages, posts, tags, comments and links.
- Added sums of total number of tables and rows in the footer of the table list.
- Added clickable column names to sort the display order.
- Added option to filter results by matching a value in a selected column.
- Initial Release