badasswp

This plugin helps you migrate legacy SQL database tables to WordPress’ Custom Post Types (CPT). It provides a user-friendly UI interface that enables users upload an SQL file which is then parsed and converted to a CPT with meta data that is recognisable within WordPress.
If you ever need to migrate a non-WordPress database table into WP, look no further. This is exactly what you need!
<h4>✔️ Features</h4>
Our plugin comes with everything you need to easily migrate SQL tables to CPTs.
✔️ Import & Convert to CPT feature. 
✔️ Quick & Lightening Fast uploads. 
✔️ Friendly, User Interface (UI). 
✔️ Custom Post Type Capabilities. 
✔️ Error Loggging Capabilities. 
✔️ Custom Hooks to help you customize plugin behaviour. 
✔️ Available in mutiple langauges such as Arabic, Chinese, Hebrew, Hindi, Russian, German, Italian, Croatian, Spanish & French languages. 
✔️ Backward compatible, works with most WP versions.
<h4>✨ Getting Started</h4>
Head over to the SQL to CPT options page. Upload an SQL file of your choice by clicking on the Import SQL File. This would analyse your SQL table and show you the table name and table columns you are about to import. Once ready, click on the Convert to CPT button to complete the process.
On import completion, you should now be re-directed to the Custom Post Type page of your newly imported data!
You can get a taste of how this works, by using the <a href="https://tastewp.com/create/NMS/8.0/6.7.0/sql-to-cpt/twentytwentythree?ni=true&origin=wp" rel="nofollow ugc">demo</a> link.
<h4>⚡ Why SQL to CPT ?</h4>
<ol>
<li>Because you need something that works great and fast!</li>
<li>Because you want to port your data across platforms easily.</li>
<li>Because you don’t want to spend hours building custom software for this.</li>
<li>Because you think SQL to CPT is cool.</li>
</ol>
NB: At the moment, the SQL to CPT plugin currently does not provide a way for users to import more than one SQL table at a time, this feature should be available in future releases as well as the option to remove unused CPTs.
<h4>🔌🎨 Plug and Play or Customize</h4>
The SQL to CPT plugin is built to work right out of the box. Simply install, activate and start using.
Want to add your personal touch? All of our documentation can be found <a href="https://github.com/badasswp/sql-to-cpt" rel="nofollow ugc">here</a>. You can override the plugin’s behaviour with custom logic of your own using <a href="https://github.com/badasswp/sql-to-cpt?tab=readme-ov-file#hooks" rel="nofollow ugc">hooks</a>.
<h3>Contribute</h3>
If you’d like to contribute to the development of this plugin, you can find it on <a href="https://github.com/badasswp/sql-to-cpt" rel="nofollow ugc">GitHub</a>.
To build, clone repo and run <code>yarn install && yarn build</code>

SQL To CPT

Import & Convert SQL tables to Custom Post Types (CPT). Migrate legacy SQL table data to WordPress custom post types of your choice. It's super fast!

joeyoungblood

WP Business Intelligence Lite allows you to powerfully display responsive data tables and charts on your website. This plugin is simple to use and allows you to connect with your wordpress database and display the data in real time. Once you have created at least one SQL query that retrieves data from your DB, you can define the type of chart (bar, donut, line, or grouped bar) or table to be used to display them. A simple shortcode embeds the chart or table in any post or page. Each page refresh retrieves the data from the DB so that the information in the chart or table is always up-to-date.
Installation guide, FAQs and support can be found at <a href="http://www.wpbusinessintelligence.com/support" rel="nofollow ugc">WP Business Intelligence Support</a>
<a href="http://www.wpbusinessintelligence.com/demos" rel="nofollow ugc">WP Business Intelligence Demos</a>
In order to use your own live MySQL, MS SQL, or PostgreSQL database with WP Business Intelligence, purchase the Pro version of WP Business Intelligence from the <a href="http://www.wpbusinessintelligence.com" rel="nofollow ugc">WP Business Intelligence web site</a>
We are actively developing this plugin and would love to hear from you with feature requests. <a href="http://www.wpbusinessintelligence.com/contact/" rel="nofollow ugc">Contact Us.</a>
Some icons provided by <a href="https://fontawesome.com/license" rel="nofollow ugc">Font Awesome</a>
<h4>Features</h4>
<ol>
<li>Live connection to your WordPress DB via custom SQL queries</li>
<li>Responsive charts/tables</li>
<li>Works in Chrome, Firefox, IE9+</li>
<li>Charts based on <a href="https://eventbrite.github.io/britecharts/tutorial-kitchen-sink.html" rel="nofollow ugc">Britecharts</a></li>
<li>Tables build on <a href="https://datatables.net/" rel="nofollow ugc">Datatables</a></li>
</ol>

WP Business Intelligence Lite

As a long-time user of this plugin I had been dismayed with how it had eroded in recent years. A few months ago the developer and I reached an agreement for me to take over the plugin so my team and I could start making updates. 

Since December of last year we have fixed all of the known bugs in the display of the charts, fixed the tooltip display, introduced more free charts for WP users, fixed a handful of database query bugs, added a feature to give your charts and graphs a name, added animation to all charts and graphs, and added a feature to give charts and graphs a caption. 

This is only the beginning of our updates, but after 3 months of hardwork the issues with this plugin that were breaking reporting dashboards for us and our clients have now been fixed. We have an aggressive roadmap to bring more charts, features, and functionality to both the free and paid version of this plugin and I am excited to keep using it to build business intelligence dashboards and to display in-depth data on our clients websites.

Problems Getting Fixed, Great Charts!

Dynamic web charts and tables for your site! Connect to your live WordPress instance DB to retrieve data in real-time and update charts and tables!

SQL To CPT vs WP Business Intelligence Lite