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.
Features
|
Free
|
Premium
|
---|---|---|
Manage local and remote databases |
||
Estimated row count support for large tables |
||
Explore and manage table data |
||
Execute SQL script files |
||
Export to SQL, JSON, XML, CSV and Excel (unlimited size) |
||
Import from SQL and CSV (upload limit = max size) |
||
WordPress media library integration |
||
Dynamic hyperlinks |
||
WordPress role management integration |
||
Unattended scheduled exports |
||
Optimized to support large tables |
||
Transfer data to another WordPress database |
||
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.
Features
|
Free
|
Premium
|
---|---|---|
Easy to create, highly customizable |
||
Multiple CSS styling solutions |
||
Support for responsive devices |
||
Multiple filter strategies |
||
Individual column search |
||
Full-text search |
||
Google like search (empty table on startup) |
||
SHOW MORE button (no paging to support large tables) |
||
Export to CSV, Excel, PDF, SQL, print and clipboard |
||
Custom buttons (using custom JavaScript) |
||
Advanced settings, including custom JavaScript code |
||
Interactive query builder |
||
Search pane support |
||
Row grouping |
||
Integrated geolocation support |
||
Shortcode [ wpdataaccess ] |
||
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.
Features
|
Free
|
Premium
|
---|---|---|
Google Maps integration |
||
Map geolocation data to custom tables |
||
Run batch updates |
||
Built maps from custom tables |
||
Add customizable markers |
||
Use user location on map |
||
Radius search (from user or specific position) |
||
Shortcode [ wpdageomap ] |
||
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.
Features
|
Free
|
Premium
|
---|---|---|
Auto generated list tables and data entry forms |
||
Selectable features per table (insert, update, delete, export, import, and more) |
||
Run as Data Forms app (AngularJS and jQuery DataTables) |
||
Inline editing |
||
Individual column search |
||
Full-text search |
||
Google like search (empty table on startup) |
||
Manage access rights per page per role |
||
WordPress role management integration |
||
Manage filters and sorting |
||
Shortcode [ wpdadiehard ] |
||
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.
Features
|
Free
|
Premium
|
---|---|---|
Import table structures (reverse engineering) |
||
Customize list tables and data entry forms |
||
Manage filters and sorting for child tables |
||
One-to-many and many-to-many relationships |
||
Lookups (listbox and autocomplete) |
||
Multiple filter strategies |
||
Inline editing |
||
Individual column search |
||
Full-text search |
||
Google like search (empty table on startup) |
||
Table reconciliation |
||
Add custom code |
||
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.
Features
|
Free
|
Premium
|
---|---|---|
Create and alter tables and indexes |
||
Load table structures into Data Designer (reverse engineering) |
||
Table reconciliation |
||
Basic and advanced mode |
||
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.
Features
|
Free
|
Premium
|
---|---|---|
Many customizable features |
||
Repository backup and restore management |
||