Plugin

Posts under the "Plugin" category

The New Data Explorer – WP Data Access 5.4.0

WPDA 5.4.0 will introduce a complete new Data Explorer interface. In this post, we'll show you the parts that are new and how you can start experimenting using the new UI. Later on, we'll also discuss when and how these changes will affect your projects. Switching to...

Global Search & Replace

A new feature was added to perform global search and replace actions on multiple databases and tables. The new feature can be accessed from the new Search & Replace icon (see image below) in the menu bar of the Data Explorer and is available for all users (free...

Copy/export large tables

When a table is copied or exported, the plugin needs to read and write all table rows. For large tables this might result in a fatal error:Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 4096 bytes)One way to solve this issue is to...

Copy table to other DB

A new feature was added to the Data Explorer, which allows users to copy a table to another local or remote database. The current database is selected by default. It is still possible to copy the table with or without data.Copying large tablesThe query buffer size,...

Interactive chart demo

Charts can be added to dashboards and webpages. It is also possible to embed charts on external websites. The chart show below contains a drop down list to allow users to interactively changed the chart type. The chart data can exported to CSV and printed. Read more...

Added user location search

Version 5.1.0 adds support for user location search to geo maps. This adds a search box to a geo map that allows the user to select a location using Google location services and search within a range of the given location.Add parameter map_search to shortcode...

Repository backup and restore management

WP Data Access creates a backup of all your repository tables each time the plugin is updated (unless disabled). This mechanism was added to prevent plugin users losing their repository data during an update failure. It has now been extended to allow plugin users to...

Improved performance for large tables

Tables are using pagination by default. Although pagination improves the user experience, it slows down performance, especially for large tables. Pagination requires counting: All table rows All matching table rows The pagination features were optimized in version 4.2...