I just released a major update for my SQL Reports plugin. The new version, 3.06.14, has a lot of exiting new features like automatic scheduled backups of your database, and the ability to save archives of your DB and have them emailed to you. You can also retore these backups directly into your native WP DB or to an external database. The plugin uses the WordPress CRON API to schedule hourly and/or daily DB backups.
I also added a quick and easy shortcode for displaying a single variable from an SQL query. Just wrap your SQL query in the sqlgetvar short code like this:
[sqlgetvar]SELECT COUNT(*) FROM wp_users[/sqlgetvar]
Have fun with these new features and let me know if you have any ideas or suggestions for improvements.
I added a shortcode to my SQL Reports Plugin so you can put a report you’ve created into a Page or Post. Just use the shortcode “SQLREPORT” with the attribute “name” being the name or your desired report. Like this:
[SQLREPORT name="My Report" style="border: 2px solid #CCCCCC; padding: 6px;" /]
The below example is a Report that I make to see the effect that Google’s SSL Search has been having on my Keyword Data. I broke it down by Locale so that I could see the differences between the use of google.com as compared to the other country codes.
Impact of Google Blocking Keyword Data with SSL Search
This plugin allows you to create reports simply by entering in the SQL. You can save multiple reports and they will be listed on the Admin Menu so you can quickly run them again anytime with just one click.