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 […]

Hide Data Explorer Manage link

Restrict table management is a new option available in plugin back-end settings. It allows organizations to remove the Manage link in the Data Explorer for specific admin users. See image below (click to enlarge). Many plugins require WordPress users to have the administrator role. All admin users are allow to perform administrative actions om database […]

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 […]