icc97

theantichris

This plugin is aimed at developers that need to migrate their databases from 
production to test or local domains.
This is the simplest way I’ve found to migrate databases quickly.
You only have to set the <code>WP_HOME</code> 
(<a href="https://codex.wordpress.org/Editing_wp-config.php#WordPress_address_.28URL.29" rel="nofollow ugc">WordPress address URL</a>) 
and <code>WP_SITEURL</code> 
(<a href="https://codex.wordpress.org/Editing_wp-config.php#Blog_address_.28URL.29" rel="nofollow ugc">Blog address URL</a>) 
constants once for each environment and then the database is automatically 
upgraded when you import a database and login to the admin area.
This stands on the shoulders of the constants and fills the hole for when 
plugins don’t follow the rules and use the database directly.
This plugin is designed to be the most lightweight way to migrate your database 
and stay out the way of your own processes.
It works with WordPress to use WordPress’ own constants to update the database 
using the 
<a href="https://codex.wordpress.org/Class_Reference/wpdb" rel="nofollow ugc">WordPress Database Object</a>. 
It avoids search and replaces in text files. It uses database queries to update 
the database as should be done.
Most developers have their own methods for exporting/importing the database – 
if you can use <code>mysqldump</code> then you probably don’t want a WordPress plugin to 
do it for you.
It makes no assumptions about your database and it’s cross platform.
P.S. Pitta is taken from the start of an <a href="http://wordpress.stackexchange.com/a/182/5433" rel="nofollow ugc">answer from WordPress SE</a>:
<blockquote>
Deployment of a WordPress site from one box to another has been a PITA since 
 day one I started working with WordPress. (Truth-be-told it was a PITA with 
 Drupal for 2 years before I started with WordPress so the problem is 
 certainly not exclusively with WordPress.)
</blockquote>
So this plugin aims to make things less PITA and more yummy Pitta (pedants will 
mention that Pitta can also be spelled pita).
Its inspiration actually comes from the <a href="http://wordpress.stackexchange.com/q/119/5433" rel="nofollow ugc">second answer</a> 
from the same <a href="http://wordpress.stackexchange.com/q/119/5433" rel="nofollow ugc">WordPress SE question</a>.
Coincidentally there is a migratory bird called a <a href="https://en.wikipedia.org/wiki/Pitta" rel="nofollow ugc">Pitta</a>:
<blockquote>
The fairy pitta migrates from Korea, Japan, Taiwan and coastal China to Borneo.
</blockquote>
P.P.S. This plugin is based off the excellent <a href="https://github.com/theantichris/WordPress-Plugin-Boilerplate" rel="nofollow ugc">WordPress Plugin Boilerplate</a> from antichris on Github

Pitta Migration

Migrate WordPress databases using WP_HOME and WP_SITEURL constants.

Guaven Labs

The plugin can create beautiful charts based on your SQL queries, then you can use those charts in any part of your website. 
You can use both native wp and non-wp mysql tables in your queries.
<h3>Pie chart, Donut chart, Line chart, Bar chart, Column chart, Area chart</h3>
<h4>How to use</h4>
<ol>
<li>
Give any name to your report.
</li>
<li>
Use our preinstalled chart or create new one yourself: choose desired chart type, type sql query, 
enter field names, labels and then press to Publish/Update
</li>
<li>
You can use multiple SQL queries too. Just split them by ; sign. You can also add shortcode argument to SQL query. For example if you 
type “select * from wp_posts where ID>{arg1}” then it you can pass arg1 value to the query with [gvn_schart_2 id=”2″ arg1=”11″] shortcode.
</li>
<li>
After update/save you will see needed shortcode below there. You can use that shortcode anywhere in your website: in pages, posts, widgets etc.
</li>
<li>
Just check “Show table-view data below the graph” in order to get table-list view below each chart.
</li>
<li>
Using “Dynamic Filters” you can create dynamic variables inside SQL code. It also creates corresponding dynamic input form above each chart.
</li>
</ol>
<h4>Dynamic filters</h4>
Use this format: variable_name~default_value~variable_label~variable_type | variable_name~default_value~variable_label~variable_type etc.
<ul>
<li>variable_name – any single name you want.</li>
<li>default_value – default value when no any variable chosen by a user</li>
<li>variable_label – Label which would be visible at a form above the chart</li>
<li>variable_type – number, text or date</li>
<li>~ is a separator between variable elements.</li>
<li>| is a separator between variables</li>
</ul>
For example if to put
limit_tag~10~Count~number | post_date_tag~2010-07-05 17:25:18~Date Published~date,
then you can use this SQL code
select * from wp_posts where post_date<{post_date_tag} limit {limit_tag}
in SQL CODE field. 
{post_date_tag} and {limit_tag} would be replaced with dynamic variables.
So, the plugin will automatically recognize it and put corresponding selectboxes above the chart.
<h4>Website</h4>
<a href="https://guaven.com/my-sql-charts/" rel="nofollow ugc">https://guaven.com/my-sql-charts/</a>
<h4>Documentation</h4>
<a href="https://guaven.com/my-sql-charts/#docs" rel="nofollow ugc">https://guaven.com/my-sql-charts/#docs</a>
<h4>Bug Submission and Forum Support</h4>
<a href="https://guaven.com/contact/solution-request/" rel="nofollow ugc">Contact Page</a>
<h4>Please Vote if you liked our plugin</h4>
Your votes really helps us. Thanks.
<h3>Available Filters</h3>
apply_filters( ‘guaven_sqlcharts_table_empty_cell’);
apply_filters(‘guaven_sqlcharts_pre_print_vars’);
apply_filters( ‘guaven_sqlcharts_final_output’);
apply_filters(‘guaven_sqlcharts_rendered_sql’);

SQL Chart Builder

Unfortunately, this plugin is only useful for very specific use-cases, because it supports ONLY two database fields (i.e. X and Y axis, which almost never makes sense for the supported pie chart type but anyway). The external MySQL connector works well, so that part is great, but the shortcode doesn't output the charts and the "preview" doesn't honor the width and height settings. So, this could have been great, with just a little more love and attention. Ah well.

I had such high hopes :(

Turn Your SQL Queries to Beautiful Dynamic Charts- Pie, Line, Area, Donut, Bar Charts with date/input filters.

Pitta Migration vs SQL Chart Builder