63% wp-data-access

Code Review | WP Data Access

WordPress plugin WP Data Access scored 63% from 54 tests.

About plugin

  • Plugin page: wp-data-access
  • Plugin version: 5.1.5
  • PHP version: 7.4.16
  • WordPress compatibility: 4.8.3-5.9
  • WordPress version: 5.9.2
  • First release: Dec 22, 2017
  • Latest release: Mar 25, 2022
  • Number of updates: 190
  • Update frequency: every 8.2 days
  • Top authors: peterschulznl (100%)

Code review

54 tests

User reviews

52 reviews

Install metrics

10,000+ active / 192,623 total downloads

Benchmarks

Plugin footprint 47% from 16 tests

Installer Passed 1 test

🔺 Critical test (weight: 50) | It is important to correctly install your plugin, without throwing errors or notices
This plugin's installer ran successfully

Server metrics [RAM: ▲5.16MB] [CPU: ▼263.21ms] 75% from 4 tests

This is a short check of server-side resources used by WP Data Access
The following require your attention
  • Extra RAM: The extra memory usage must be under 5MB (currently 5.16MB on /wp-admin/options-general.php?page=wpdataaccess)
PageMemory (MB)CPU Time (ms)
Home /8.68 ▲5.1689.82 ▲37.96
Dashboard /wp-admin8.61 ▲5.2067.06 ▲27.81
Posts /wp-admin/edit.php8.83 ▲5.1972.10 ▲31.92
Add New Post /wp-admin/post-new.php12.08 ▲5.11125.02 ▼1,150.54
Media Library /wp-admin/upload.php8.52 ▲5.2268.59 ▲44.85
Freemius Debug [v.2.4.3] /wp-admin/admin.php?page=freemius8.7356.58
WP Data Access /wp-admin/options-general.php?page=wpdataaccess9.4268.08

Server storage [IO: ▲6.60MB] [DB: ▲0.01MB] Passed 3 tests

Filesystem and database footprint
There were no storage issued detected upon installing this plugin
Filesystem: 559 new files
Database: 10 new tables, 8 new options
New tables
wp_wpda_project_page
wp_wpda_table_design
wp_wpda_media
wp_wpda_project
wp_wpda_menus
wp_wpda_publisher
wp_wpda_csv_uploads
wp_wpda_logging
wp_wpda_project_table
wp_wpda_table_settings
New WordPress options
wpda_version
fs_debug_mode
fs_accounts
wpda_fulltext_support
wpda_show_whats_new
fs_active_plugins
wpda_plugin_sonce_seed
fs_gdpr

Browser metrics Passed 4 tests

An overview of browser requirements for WP Data Access
There were no issues detected in relation to browser resource usage
PageNodesMemory (MB)Script (ms)Layout (ms)
Home /3,962 ▲20817.96 ▲2.1820.93 ▲15.122.39 ▼0.05
Dashboard /wp-admin2,942 ▲816.11 ▼0.07118.46 ▼19.61169.80 ▲9.47
Posts /wp-admin/edit.php2,744 ▲563.37 ▲0.0163.37 ▼3.10164.92 ▲22.94
Add New Post /wp-admin/post-new.php1,639 ▼2919.36 ▲0.45447.03 ▲50.87183.01 ▲25.51
Media Library /wp-admin/upload.php1,751 ▲535.46 ▼0.08151.13 ▲12.21210.31 ▲27.04
Freemius Debug [v.2.4.3] /wp-admin/admin.php?page=freemius1,4782.6259.95128.14
WP Data Access /wp-admin/options-general.php?page=wpdataaccess2,7606.01105.87161.84

Uninstaller [IO: ▲0.00MB] [DB: ▲0.01MB] 25% from 4 tests

🔸 Tests weight: 35 | It is important to correctly uninstall your plugin, without leaving any traces
It is recommended to fix the following
  • This plugin cannot be uninstalled
    • > Notice in wp-content/plugins/wp-data-access/freemius/includes/class-freemius.php+8575
    Undefined property: stdClass::$plugins
  • The plugin did not uninstall successfully, leaving 10 tables in the database
    • wp_wpda_project
    • wp_wpda_menus
    • wp_wpda_project_page
    • wp_wpda_logging
    • wp_wpda_table_design
    • wp_wpda_publisher
    • wp_wpda_media
    • wp_wpda_table_settings
    • wp_wpda_csv_uploads
    • wp_wpda_project_table
  • Zombie WordPress options were found after uninstall: 8 options
    • fs_active_plugins
    • wpda_version
    • wpda_show_whats_new
    • fs_gdpr
    • fs_debug_mode
    • wpda_plugin_sonce_seed
    • fs_accounts
    • wpda_fulltext_support

Smoke tests 75% from 4 tests

Server-side errors Passed 1 test

🔹 Test weight: 20 | This is a shallow check for server-side errors
Even though everything seems fine, this is not an exhaustive test

SRP 50% from 2 tests

🔹 Tests weight: 20 | A shallow check of the single-responsibility principle; PHP files should perform no action - including output of placeholder text - and trigger no errors when accessed directly
Please fix the following
  • 115× GET requests to PHP files have triggered server-side errors or warnings (only 10 are shown):
    • > PHP Fatal error
      Uncaught Error: Class 'WPDataAccess\\Simple_Form\\WPDA_Simple_Form_Item' not found in wp-content/plugins/wp-data-access/WPDataAccess/Simple_Form/WPDA_Simple_Form_Item_File.php:19
    • > PHP Fatal error
      Uncaught Error: Class 'WPDataProjects\\Parent_Child\\WPDP_Child_List_Table' not found in wp-content/plugins/wp-data-access/WPDataProjects/Project/WPDP_Project_Page_List.php:20
    • > PHP Fatal error
      Uncaught Error: Interface 'Psr\\Http\\Message\\UploadedFileInterface' not found in wp-content/plugins/wp-data-access/vendor/guzzlehttp/psr7/src/UploadedFile.php:10
    • > PHP Fatal error
      Uncaught Error: Interface 'Psr\\Http\\Message\\ResponseInterface' not found in wp-content/plugins/wp-data-access/vendor/guzzlehttp/psr7/src/Response.php:11
    • > PHP Fatal error
      Uncaught Error: Class 'GuzzleHttp\\Exception\\BadResponseException' not found in wp-content/plugins/wp-data-access/vendor/guzzlehttp/guzzle/src/Exception/ServerException.php:7
    • > PHP Fatal error
      Uncaught Error: Class 'WPDataProjects\\Parent_Child\\WPDP_Parent_List_Table' not found in wp-content/plugins/wp-data-access/WPDataProjects/Project/WPDP_Project_Project_List.php:21
    • > PHP Fatal error
      Uncaught Error: Interface 'GuzzleHttp\\Promise\\PromiseInterface' not found in wp-content/plugins/wp-data-access/vendor/guzzlehttp/promises/src/Promise.php:10
    • > PHP Fatal error
      Uncaught Error: Class 'WPDataProjects\\Parent_Child\\WPDP_Child_List_Table' not found in wp-content/plugins/wp-data-access/WPDataProjects/Parent_Child/WPDP_Child_List_Table_View.php:17
    • > PHP Fatal error
      Uncaught Error: Interface 'Psr\\Http\\Message\\StreamInterface' not found in wp-content/plugins/wp-data-access/vendor/guzzlehttp/psr7/src/DroppingStream.php:13
    • > PHP Fatal error
      Uncaught Error: Class 'WPDataAccess\\Utilities\\WPDA_Export_Formatted' not found in wp-content/plugins/wp-data-access/WPDataAccess/Utilities/WPDA_Export_Csv.php:19

User-side errors Passed 1 test

🔹 Test weight: 20 | This is a shallow check for browser errors
Everything seems fine, but this is not an exhaustive test

Optimizations

Plugin configuration 93% from 29 tests

readme.txt 88% from 16 tests

The readme.txt file uses markdown syntax to describe your plugin to the world
Please fix the following attributes:
  • Screenshots: These screenshots lack descriptions #1, #10, #2, #3, #4, #5, #6, #7, #8, #9 in wp-data-access/assets to your readme.txt
  • Tags: There are too many tags (11 tag instead of maximum 10)
The official readme.txt is a good inspiration

wp-data-access/wp-data-access.php Passed 13 tests

The main PHP file in "WP Data Access" ver. 5.1.5 adds more information about the plugin and also serves as the entry point for this plugin
123 characters long description:
Local and remote data administration, publication and app development tool available directly from the WordPress dashboard.

Code Analysis 95% from 3 tests

File types Passed 1 test

🔸 Test weight: 35 | Executable files are considered dangerous and should not be included with any WordPress plugin
Everything looks great! No dangerous files found in this plugin90,889 lines of code in 431 files:
LanguageFilesBlank linesComment linesLines of code
PHP33714,29433,26778,029
Markdown121,25804,404
JavaScript183992923,715
PO File11,1361,9842,236
CSS27206481,741
JSON700505
SQL2300139
YAML425087
XML10024
make1409

PHP code 0% from 2 tests

An overview of cyclomatic complexity and code structure
It is recommended to fix the following
  • Please reduce cyclomatic complexity of classes to less than 1000 (currently 2,910)
  • Method cyclomatic complexity should be reduced to less than 100 (currently 173)
Cyclomatic complexity
Average complexity per logical line of code0.52
Average class complexity41.16
▷ Minimum class complexity1.00
▷ Maximum class complexity2,910.00
Average method complexity4.90
▷ Minimum method complexity1.00
▷ Maximum method complexity173.00
Code structure
Namespaces36
Interfaces14
Traits2
Classes243
▷ Abstract classes31.23%
▷ Concrete classes24098.77%
▷ Final classes177.08%
Methods2,792
▷ Static methods47917.16%
▷ Public methods1,94569.66%
▷ Protected methods37613.47%
▷ Private methods47116.87%
Functions255
▷ Named functions16464.31%
▷ Anonymous functions9135.69%
Constants323
▷ Global constants9830.34%
▷ Class constants22569.66%
▷ Public constants225100.00%

Plugin size Passed 2 tests

Image compression Passed 2 tests

Often times overlooked, PNG files can occupy unnecessary space in your plugin
75 PNG files occupy 0.22MB with 0.07MB in potential savings
Potential savings
Compression of 5 random PNG files using pngquant
FileSize - originalSize - compressedSavings
assets/images/google_chart_types/ScatterChart.png6.30KB3.02KB▼ 52.11%
assets/css/images/ui-icons_cd0a0a_256x240.png4.27KB4.11KB▼ 3.78%
assets/css/images/ui-bg_glass_75_dadada_1x400.png0.11KB0.16KB0.00%
assets/css/images/ui-bg_glass_40_ffc73d_1x400.png0.37KB0.16KB▼ 57.22%
assets/css/images/ui-bg_glass_65_ffffff_1x400.png0.20KB0.09KB▼ 57.49%