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 and premium). Open the Data Explorer Click the Search […]
Plugin
WordPress user ID in SQL
WP Data Access version 5.2.3 adds a session variable containing the WordPress user ID to its database connections. This allows plugin users to access the WordPress user ID in SQL queries, database views, triggers, functions and procedures. Open the Query Builder and enter: This returns your WordPress user. Availability Session variable @wpda_wp_user_id is available in […]
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 increase WP_MAX_MEMORY_LIMIT. But no matter how […]
Copy table to other database
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 tables The query buffer size, introduced in version 5.2, helps to copy […]
Adding buttons to publications manually
Topics (1) Standard buttons(2) Customizing standard buttons(3) Custom buttons (1) Standard buttons Buttons can be added to publications directly from the Data Publisher (see image below – click to enlarge). This user friendly feature is the simplest way to add standard buttons to your publication. (2) Customizing standard buttons The publication extention section of the […]
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 wpdageomap to enable this feature: User location search if […]
Environment variables
The following environment variables can be used in WP Data Access: $$USERID$$ Contains the WordPress user ID $$USER$$ Contains the WordPress user login $$EMAIL$$ Contains the WordPress user email Environment variables can be used: As default value in Project Templates In where clauses
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 make interactive backups, download backups and restore backups partially or […]
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 was optimized in version 4.2 and does no longer count all table rows on each request: For MyISAM tables the table row […]
Styling a Data Project
(1) Use the Code Manager to style your projects The Code Manager is the new way to style projects! Read more about the Code Manager… The table below demonstrates how the Code Manager can be used to style a project. Use the project layout panel to switch between stylesFind your favourite combination of styles Download […]