Tutorials

Data Explorer

The Data Explorer allows plugin users to perform data and database related tasks directly from the WordPress dashboard. Tables, columns, indexes and foreign keys can be viewed inline. Common DDL actions, SQL and CSV imports, as well as table and row exports in several formats are available on mouse click. Table data can be viewed and managed from list tables and user friendly data entry forms. Many settings can be managed from the Data Explorer to customize table and view management.

More complex features are available for experienced developers, like remote database access and executing SQL scripts. Remote database access is supported by all features.

• Import CSV and SQL file
• Export tables
• Export table rows

Data Publisher

The Data Publisher allows plugin users to create responsive tables from local and remote databases. Publications can be created with just a few mouse clicks. Customizable styles are available for download for free. Demos and videos are available to help new and experienced users getting their publications up and running. The Data Publisher supports client side processing for small tables and server side processing for large tables (several use cases with over two million rows). Advanced options and javscript support is available for more experienced developers.

• Getting started
• Styling publications
• Setup and use
• Non admin user access

Data Projects

Manage your local and remote data with Data Projects. Supports many features like parent-child relationships, lookups, autocomplete, many customizable options and access rights per page supporting WordPress roles. Projects can be executed from the dashboard or a web page using a shortcode. Data Forms is a premium feature which allows plugin users to turn their Data Projects into fully responsive AngularJS apps without the need to make any modifications to their projects. Data Projects is optimized to work with large tables.

• Projects and templates (added 7 June 2021)
• Registration page
• One to many relationships
• Many to many relationships
• Manage table options
• Advanced table options
• Advanced lookups
• Less/more button
• Managing roles and user access
• Transfer to other WordPress site

Data Designer

Use the Data Designer to create your own tables and indexes. Or load existing tables into the Data Designer with reverse engineering. Works with local and remote databases (make sure you have to necessary credentials). Use the Data Explorer to execute your own sql scripts (button Import data/Execute script(s)) if you are an experience database developer.

• Basic mode

Shortcodes

Publications and projects created directly from a shortcode is still supported for backward compatibility. This is an old feature with many limitations. Please update your shortcodes and use the Data Publisher for your publications and Data Projects for data management.

 

• Shortcode wpdataaccess

Databases

Here are some external tutorials that might help to get a better understanding of databases.

Beginner

• What is a database?
• Table columns and data types
• References
• How to start creating a database model

Advanced

• Beginner SQL – One to Many Relationship
• Beginner SQL – Many to Many Relationship
• A beginner’s guide to many-to-many relationships
• SQL for Beginners – Database Relationships

jQuery DataTables

WP Data Access uses jQuery DataTables for publications and Data Forms. Some table options can be managed interactively, many other options are available through customizable JSON. A link is provided to a reference showing all available options.

 

• jQuery DataTables reference