Index

  1. Home
  2. Docs
  3. Index
  4. Getting Started
  5. Overview

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.

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 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.

Features
Free
Premium

Shortcode [ wpdadataproject ] generates AngularJS app from Data Project

Shortcode [ wpdadataforms ] generates AngularJS app from Data Projects page

AngularJS app generated from Data Project + Project Templates

Supports all Data Projects features

Selectable jQuery UI styles

Custom styling = planned

Custom code support = planned

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.

Features
Free
Premium

Execute any SQL command (DCL, DDL, DML, with credentials)

Work on multiple SQL queries simultaneously (using tabs)

Access local and remote databases

Queries can be saved and reused (per WordPress user account)

Protects WordPress table structures (no DROP, ALTER and TRUNCATE allowed - not configurable)

Protects WordPress table data (can be disabled for INSERT, UPDATE and DELETE)

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

Was this article helpful to you? Yes 9 No

Leave a Reply

Your email address will not be published. Required fields are marked *

1 × 3 =