tsinf

TS Comfort DB is a database manager to manage your current used WordPress database in WordPress Backend. 
Do you know? You’re a WordPress developer and theres no PHPMyAdmin or something available or you do not have access to this tool? 
But you want to debug something or check if your currently developed plugin saves the test data ordinary? 
Therefore i created TS Comfort DB. 
It has basic database functionality but it`s restricted as much as needed that it has only influence at the current WordPress database.
Features: 
* Full Text Search 
* Create, Edit and Delete Datasets 
* Get Meta Information like Primary Key or Field Type 
* Sort by Column 
* Table Filter-Functionality 
* Backend Post Search 
* SQL Exporter 
* CSV Exporter 
* Unserialize Table-Cells 
* JSON Decode Table-Cells
Since Version 1.0.9 there is an Adminbar Menu, that you can activate in the options to quick access database tables.
Since Version 2.0.4 these is possibility change look and feel with another skin and to speed up table overview with de-activating or caching meta information

TS Comfort DB

Thank you for creating this. Another must have in my plugin dev workflow.

Very handy!

Database Manager for WordPress Database with all functions to need to administrate your current used database.

blubrry

machouinard

By populating a MySQL database table with all the information about the podcasts you can automatically create the posts needed for podcasting with the <a href="https://wordpress.org/extend/plugins/powerpress/" title="WordPress Podcasting" rel="ugc">Blubrry PowerPress plugin</a>. This will allow you to post as draft or published and switch between the two as well as delete posts. Probably not useful to actual Podcasters, but it works for what I needed.
Information required from the database:
<ul>
<li>Host</li>
<li>Database Name</li>
<li>Database Table Name</li>
<li>Database Username</li>
<li>Database Password</li>
</ul>
Also field names from the database which will be used for the following:
<ul>
<li>Primary Key Field</li>
<li>Title</li>
<li>Category</li>
<li>Post Body</li>
<li>Featured Image(URL to an image)</li>
<li>Media URL</li>
<li>Media size</li>
<li>Media type</li>
<li>Date posted</li>
</ul>
Your categories need to be setup prior to using this.
<h4>Example database table for importing from</h4>
You may use the following database table as an example template for your database.
<pre><code>CREATE TABLE episodes (
 episode_id int(11) NOT NULL,
 episode_title varchar(255) NOT NULL,
 episode_category varchar(255) NOT NULL,
 episode_body text NOT NULL,
 episode_image_url varchar(4000) NOT NULL,
 episode_url varchar(4000) NOT NULL,
 episode_length int(11) NOT NULL,
 episode_content_type varchar(20) NOT NULL,
 episode_date date NOT NULL,
 PRIMARY KEY (episode_id)
) DEFAULT CHARSET=utf8;
</code></pre>
Note: You must have at least one record in the database table before you can enter the database column fields in this plugin.

PowerPress Posts From MySQL addon

Have a bunch of podcasts stored on your server and aren't excited about creating each post manually? This can help.

TS Comfort DB vs PowerPress Posts From MySQL addon