Black-Desk

The plugin is designed with people with basic technical knowledge in mind. It is designed to be easy, straight-forward, and intuitive to use. However, some of the database capabilities like creating related tables require you to be acquainted with how relations are made in order to put them into practice. If you have basic data management knowledge, you will be right at home, and if not, try the plugin for free, and don't be too surprised when you find out how easy it is to create database tables, populate them with data, and query your data. Especially now that we've added an AI Assistant.

Our AI Assistant is built to help you do common tasks more efficiently, using natural language to describe what you intend to accomplish. At the moment, the AI Assistant can help you create new tables more quickly. The option of using the AI Assistant for certain tasks does not mean you cannot still do them manually, the way you are used to - you most certainly can!

To enable the use of AI Assistant features, you need to first set up your preferred AI Service Provider and securely store your corresponding API key* in Black-Desk "Settings". * Your API key will be stored on your own server. While we take reasonable precautions to store it securely, we have no control over your hosting environment and cannot be held liable for any loss, exposure, or misuse resulting from a server breach or other unforeseen event. By providing data to enable AI, you acknowledge this and agree.

When viewing your table, clicking on a value you wish to edit will render it an input field. While focused on the input field, press Enter to update the value or Esc to cancel editing.

Yes and no, depending on the action you took. Yes, the plugin uses soft delete functionality when deleting data while viewing a table. Deleted records can be restored from the table trash view. However, if you delete the whole table or truncate table data while viewing the list of tables, those two actions cannot be undone, as the user is warned beforehand when prompted to confirm if they are sure they want to delete or truncate the table.

Yes, and 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). Example of such query condition: [review.product_id] [equal to] [FIELD] [product.id] See USAGE > CREATING QUERIES section for the detailed instructions on query creation and use.

You can find complete, detailed shortcodes usage instructions in your WordPress dashboard > Tables > Shortcodes submenu page, with examples of usage for each shortcode. For basic information purposes, info on shortcodes functionality is available in the USAGE > SHORTCODES section.