Overview

WP Data Access is a powerful data administration, publication and development tool that allows you to perform database related tasks from your WordPress dashboard. An intuitive user interface helps to create fully responsive publications and data administration pages. No programming skills required!

For advanced users, the plugin support more complex features like remote database access, master-detail pages, lookups, WordPress role integration, WordPress user integration and a layer around your WordPress database which allows you to add database table and view specific functionality like dynamic hyperlinks, WordPress media library integration and using estimated row counts instead of real row counts to support large tables.

Data Explorer – Data and database administration

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.

Data Publisher – Create responsive tables

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.

Geolocation – Search within location range (premium)

With geolocation your users can search places stored in a database table. The users position or a fixed position can be used to search within a range. An interactive map allows your users to change the range from a dropdown list. The plugin needs a Google Maps API to retrieve the geolocation information and stores this information in a database table for fast access.

Data Projects – Write your own WordPress apps

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.

Project Templates – Customize your Data Projects

Project Templates are used to customize Data Projects pages. Without a template the plugin uses the default values for all page items. A template contains five sections to customize table layout and behaviour. Each section can be managed individually.

Every project template contains a template set name. This set name is used to define which template set is used for a specific Data Projects page. The plugin allows to create multiple templates for a table to manage the layout and behaviour of each Data Projects page separately.

When a set name is added to a Data Projects page (see image below – click to enlarge) the page will use that template set name for all tables shown on that page. The set name is also used for tables in relationships, allowing plugin users to customize parent and child tables individually as well.

Data Forms – Turn your Data Project into an AngularJS app

Data Forms turns your Data Projects into state of the art responsive data apps. It uses jQuery DataTable with server side processing to handle large amounts of data. Data entry forms are generated using AngularJS. Existing Data Projects can be executed as Data Forms apps without the need to make any changes to projects.

Query Builder – Execute SQL commands

The Query Builder allows plugin users to execute any SQL command (DCL, DDL and DML) from the WordPress dashboard, as long as the user has the necessary credentials. The tool is available for admin users only and restricts access to WordPress tables. Multiple queries can be edited simultaneously. Queries can be stored per WordPress user account and can be reused at a later time. Output can be exported to CSV, JSON and XML. The Query Builder lets a plugin user access local as well as remote databases. The raw server response can be examined for further research.

Data Designer – Create tables and indexes

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.

Plugin Settings – Manage behaviour, style and security

WP Data Access is highly customizable. An extensive settings page allows plugin users to change the look and feel of back-end and front-end features. Many settings can be defined on global, table and view level, acting like a layer between the database and plugin tools. These settings are available for local as well as remote databases.