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

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

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