jelenacvijic

<p>Looking for the <strong>easiest way to manage your data</strong>?<br />
We are here to help. 😉</p>
<p>Black-Desk is a comprehensive WordPress plugin that helps you <strong>create and manage custom database tables and data</strong> directly from your WordPress dashboard.</p>
<p>The plugin provides an intuitive interface that lets you create, update, and query your data in the simplest way possible, without requiring deep technical knowledge.</p>
<p>Save queries and reuse them quickly.</p>
<p>Black-Desk plugin <strong>shortcodes</strong> let you display selected data on your WordPress pages or posts, as well as easily create input forms directly connected to your tables.</p>
<p><strong>Key Features:</strong></p>
<ul>
<li>Create custom tables with various column types</li>
<li>Manage table data with an easy-to-use interface</li>
<li>View and edit table data</li>
<li>Create and save custom queries, including joins (across multiple related tables)</li>
<li>Soft delete support with trash management</li>
<li>Shortcodes for data display</li>
<li>Shortcodes for input form generation</li>
</ul>
<h3>Usage</h3>
<p>After installation, look for the <strong>‘Tables’</strong> menu item in your WordPress dashboard/admin panel.</p>
<h4>Creating Tables</h4>
<ol>
<li>Go to <em>Tables</em> > <strong>Add Table</strong></li>
<li>Enter table name and description</li>
<li>Add columns with their respective names, types and properties</li>
<li>Preview and save your table structure</li>
</ol>
<p>Available Column Types:</p>
<ul>
<li>Short text – varchar(255)</li>
<li>Number     – int(11)</li>
<li>Big number – bigint(20)</li>
<li>Currency   – decimal(15,2)</li>
<li>Date time  – datetime</li>
<li>Yes no     – bit(1)</li>
<li>Lookup     – varchar(100)</li>
<li>Rich text  – mediumtext</li>
<li>Long text  – longtext</li>
<li>Attachment – longblob</li>
<li>Hyperlink  – varchar(1024)</li>
<li>ENUM       – ENUM (your list of options)</li>
</ul>
<h4>Managing Data</h4>
<ol>
<li>Navigate to <em>Tables</em> > <strong>All Tables</strong></li>
<li>Click on a table to view/edit its data or its structure</li>
<li>Add, edit, or delete records (edit by clicking the field itself)</li>
<li>Use bulk actions for multiple records</li>
<li>Restore deleted records from trash</li>
<li>Display data in your WordPress page or post using shortcodes</li>
</ol>
<h4>Creating Queries</h4>
<ol>
<li>Go to <em>Tables</em> > <em>All Queries</em> > <strong>Select</strong></li>
<li>Choose tables and fields to include</li>
<li>Add conditions and aliases</li>
<li>Preview and save your query</li>
<li>Display the query results in your WordPress page or post using shortcodes</li>
</ol>
<p>If you want to view data from related, joined tables you can create and save a query by setting one of its conditions so that the value from the first table column is equal to the second table column/field (effectively indicating a foreign key column and pointing it to another table’s primary key).</p>
<p><strong>Example</strong> of such query condition:<br />
[<code>review.product_id</code>] [equal to] [FIELD] [<code>product.id</code>]</p>
<h4>View Query Results</h4>
<ol>
<li>Go to <em>Tables</em> > <strong>All Queries</strong></li>
<li>View specific query</li>
</ol>
<h4>Deleting Data</h4>
<p>There are three options for deleting data:</p>
<ol>
<li>Deleting rows while viewing a table, one by one or in bulk; soft delete, <strong>reversible</strong></li>
<li>Truncate – delete all data in a table; <strong>irreversible</strong></li>
<li>Delete the whole table; <strong>irreversible</strong></li>
</ol>
<h4>Shortcodes</h4>
<p>Shortcodes are a powerful feature of Black-Desk that let you seamlessly connect your data tables to any of your WordPress pages or posts, in one of the two directions:</p>
<ul>
<li>Display data from your tables directly on your page or post;</li>
<li>Create custom data entry <strong>forms</strong> to store user input directly into your data tables.</li>
</ul>
<p>Using shortcodes, you can easily:</p>
<ul>
<li>Display data from your table or query result – <code>[bdds-view-table]</code></li>
<li>Display specific field – <code>[bdds-view-field]</code></li>
<li>Display specific field data <strong>for each</strong> row of your table or query result – <code>[bdds-view-repeat]</code></li>
<li>Create an input form using shortcodes:<br />
- <code>[bdds-form-start]</code> – to start a form<br />
- <code>[bdds-form-field]</code> – to add form field<br />
- <code>[bdds-form-stop]</code> – to end a form</li>
</ul>
<p><strong>Detailed shortcodes usage instructions</strong> are provided in dashboard > <em>Tables</em> > <strong>Shortcodes</strong>.</p>


Black-Desk

WordPress plugin for easier data management.

Frank Bueltge

Inpsyde GmbH

<p>List query-actions only for admins; for debug purposes. See all queries on the frontend of the blog and find the slowest part.</p>
<h4>New release, new Plugin</h4>
<p>Please use the plugin <a href="https://wordpress.org/extend/plugins/debug-objects/" rel="ugc">Debug Objects</a>, provides more information and a cleaner query view as this older plugin.<br />
The new solution list also the plugin and core queries in different views.</p>
<p>Since version 1.0.0 the plugin disable the MySQL query cache for the current connected session. That will show you the real execution time for a query. To disable this behavior set the constant <code>QUERY_CACHE_TYPE_OFF</code> to <code>FALSE</code>.</p>
<p>The plugin is perfect for WordPress developers, plugin and theme developers and site administrators who are trying to find out why the blog is too slow.</p>
<h4>Params</h4>
<p>The plugin has since version 1.0.0 a constant to disable the mySQL Session cache. On defoult is the value on true and the cache is off for an better analyse! For change this, set the constant <code>QUERY_CACHE_TYPE_OFF</code> to <code>FALSE</code>.</p>
<h4>Example</h4>
<p>This is a example for evaluation.</p>
<pre><code># Time: 0.00198888778687
Query: SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'
Call from: require, require_once, require_once, require_once, is_blog_installed, wp_load_alloptions
# Time: 0.000695943832397
Query: UPDATE 'wp_options' SET 'option_value' = 'a:3:{i:0;b:0;s:25:\"adminimize/adminimize.php\";a:2:{i:0;O:10:\"adminimize\":1:{s:12:\"wp_filter_id\";i:0;}i:1;s:12:\"on_deinstall\";}s:31:\"debug_queries/debug_queries.php\";a:2:{i:0;O:12:\"DebugQueries\":1:{s:12:\"wp_filter_id\";i:0;}i:1;s:10:\"deactivate\";}}' WHERE 'option_name' = 'uninstall_plugins'
Call from: require, require_once, require_once, require_once, include_once, adminimize->adminimize, register_uninstall_hook, update_option

. . .

Total query time: 0.0155501365662 for 23 queries.
Total num_query time: 0.392 for 23 num_queries.
</code></pre>
<h4>Acknowledgements</h4>
<p>Thanks to Joost de Valk on <a href="http://yoast.com/" title="yoast.com" rel="nofollow ugc">yoast.com</a> for small modifed on the plugin for some extra info.</p>
<h4>Licence</h4>
<p>Good news, this plugin is free for everyone! Since it’s released under the GPL, you can use it free of charge on your personal or commercial blog. But if you enjoy this plugin, you can thank me and leave a <a href="http://bueltge.de/wunschliste/" title="Wishliste and Donate" rel="nofollow ugc">small donation</a> for the time I’ve spent writing and supporting this plugin. And I really don’t want to know how many hours of my life this plugin has already eaten 😉</p>


Debug Queries

List query-actions only for admins; for debug purposes

Black-Desk vs Debug Queries