78% ultimate-db-manager-lite

Code Review | Ultimate WP DB Manager - WordPress Database Backup, Cleanup & Optimize

WordPress plugin Ultimate WP DB Manager - WordPress Database Backup, Cleanup & Optimize scored 78% from 54 tests.

About plugin

  • Plugin page: ultimate-db-manag...
  • Plugin version: 1.3.4
  • PHP version: 7.4.16
  • WordPress compatibility: 4.0-6.1.1
  • WordPress version: 6.3.1
  • First release: Oct 28, 2020
  • Latest release: Dec 13, 2022
  • Number of updates: 42
  • Update frequency: every 18.5 days
  • Top authors: darell (100%)

Code review

54 tests

User reviews

1 review

Install metrics

10+ active / 1,317 total downloads

Benchmarks

Plugin footprint 83% from 16 tests

Installer Passed 1 test

🔺 Critical test (weight: 50) | Checking the installer triggered no errors
Install script ran successfully

Server metrics [RAM: ▲0.13MB] [CPU: ▼4.47ms] Passed 4 tests

This is a short check of server-side resources used by Ultimate WP DB Manager - WordPress Database Backup, Cleanup & Optimize
Server-side resource usage in normal parameters
PageMemory (MB)CPU Time (ms)
Home /3.48 ▲0.0237.18 ▼3.61
Dashboard /wp-admin3.47 ▲0.1747.14 ▼1.93
Posts /wp-admin/edit.php3.52 ▲0.1648.51 ▼2.99
Add New Post /wp-admin/post-new.php6.07 ▲0.1893.72 ▼9.34
Media Library /wp-admin/upload.php3.39 ▲0.1640.40 ▲4.82
Optimize /wp-admin/admin.php?page=ultimate-db-manager-optimize3.4132.33
Help /wp-admin/admin.php?page=ultimate-db-manager-help3.4040.09
New Schedule /wp-admin/admin.php?page=ultimate-db-manager-schedule-wizard3.4643.94
Dashboard /wp-admin/admin.php?page=ultimate-db-manager3.4433.27
Schedules /wp-admin/admin.php?page=ultimate-db-manager-schedule3.4533.64
Backups /wp-admin/admin.php?page=ultimate-db-manager-backups3.4332.16
Cleanup /wp-admin/admin.php?page=ultimate-db-manager-cleanup3.4032.57

Server storage [IO: ▲0.35MB] [DB: ▲0.00MB] Passed 3 tests

How much does this plugin use your filesystem and database?
The plugin installed successfully
Filesystem: 64 new files
Database: no new tables, 6 new options
New WordPress options
can_compress_scripts
widget_recent-comments
widget_recent-posts
widget_theysaidso_widget
theysaidso_admin_options
db_upgraded

Browser metrics Passed 4 tests

This is an overview of browser requirements for Ultimate WP DB Manager - WordPress Database Backup, Cleanup & Optimize
This plugin has a minimal impact on browser resources
PageNodesMemory (MB)Script (ms)Layout (ms)
Home /2,909 ▲15213.33 ▼1.051.89 ▲0.0036.31 ▼17.45
Dashboard /wp-admin2,287 ▲985.07 ▲0.12102.27 ▼3.4043.75 ▼2.40
Posts /wp-admin/edit.php2,179 ▲872.23 ▲0.2543.00 ▲3.1237.37 ▼0.45
Add New Post /wp-admin/post-new.php1,591 ▲7223.44 ▲0.64662.60 ▼12.0954.34 ▼1.99
Media Library /wp-admin/upload.php1,469 ▲814.36 ▲0.17101.83 ▲7.0244.53 ▲1.45
Optimize /wp-admin/admin.php?page=ultimate-db-manager-optimize1,0892.3329.4539.84
Help /wp-admin/admin.php?page=ultimate-db-manager-help1,0811.9828.4029.40
New Schedule /wp-admin/admin.php?page=ultimate-db-manager-schedule-wizard1,5232.0330.5939.89
Dashboard /wp-admin/admin.php?page=ultimate-db-manager1,2562.0229.9528.75
Schedules /wp-admin/admin.php?page=ultimate-db-manager-schedule1,0892.3429.7530.64
Backups /wp-admin/admin.php?page=ultimate-db-manager-backups1,0942.3330.5637.63
Cleanup /wp-admin/admin.php?page=ultimate-db-manager-cleanup1,0892.3328.9830.37

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

🔸 Tests weight: 35 | Checking the uninstaller removed all traces of the plugin
The following items require your attention
  • Zombie WordPress options were found after uninstall: 6 options
    • widget_recent-posts
    • widget_theysaidso_widget
    • widget_recent-comments
    • db_upgraded
    • theysaidso_admin_options
    • can_compress_scripts

Smoke tests 50% from 4 tests

Server-side errors Passed 1 test

🔹 Test weight: 20 | Just a short smoke test targeting errors on the server (in the Apache logs)
Everything seems fine, however this is by no means an exhaustive test

SRP 50% from 2 tests

🔹 Tests weight: 20 | The single-responsibility principle: PHP files have to remain inert when accessed directly, throwing no errors and performing no actions
Almost there! Just fix the following items
  • 23× PHP files trigger server-side errors or warnings when accessed directly (only 10 are shown):
    • > PHP Fatal error
      Uncaught Error: Call to undefined function esc_html_e() in wp-content/plugins/ultimate-db-manager-lite/admin/views/schedule/wizard/content.php:19
    • > PHP Fatal error
      Uncaught Error: Call to undefined function admin_url() in wp-content/plugins/ultimate-db-manager-lite/admin/views/menu/header.php:4
    • > PHP Fatal error
      Uncaught Error: Using $this when not in object context in wp-content/plugins/ultimate-db-manager-lite/admin/views/backups/content.php:3
    • > PHP Fatal error
      Uncaught Error: Call to undefined function esc_url() in wp-content/plugins/ultimate-db-manager-lite/admin/views/help/content.php:3
    • > PHP Fatal error
      Uncaught Error: Call to undefined function esc_url() in wp-content/plugins/ultimate-db-manager-lite/admin/views/cleanup/content.php:3
    • > PHP Fatal error
      Uncaught Error: Call to undefined function esc_html_e() in wp-content/plugins/ultimate-db-manager-lite/admin/views/schedule/list/header.php:1
    • > PHP Fatal error
      Uncaught Error: Call to undefined function esc_html_e() in wp-content/plugins/ultimate-db-manager-lite/admin/views/schedule/wizard/header.php:2
    • > PHP Fatal error
      Uncaught Error: Call to undefined function esc_html_e() in wp-content/plugins/ultimate-db-manager-lite/admin/views/schedule/wizard/sections/tab-schedule.php:4
    • > PHP Fatal error
      Uncaught Error: Call to undefined function esc_html_e() in wp-content/plugins/ultimate-db-manager-lite/admin/views/cleanup/header.php:1
    • > PHP Fatal error
      Uncaught Error: Call to undefined function esc_html_e() in wp-content/plugins/ultimate-db-manager-lite/admin/views/backups/header.php:1

User-side errors 0% from 1 test

🔹 Test weight: 20 | This is a smoke test targeting browser errors/issues
Please fix the following browser errors
  • 7 occurences, only the last one shown
    • > GET request to /wp-admin/admin.php?page=ultimate-db-manager-cleanup
    • > Console-api (warning) in unknown
    https://unpkg.com/ionicons@5.0.0/dist/ionicons.js?ver=1.3.4 26:10 "[ionicons] Deprecated script, please remove: \u003Cscript src=\"https://unpkg.com/ionicons@5.0.0/dist/ionicons.js?ver=1.3.4\" id=\"ionicons-js\">\u003C/script>\nTo improve performance it is recommended to set the differential scripts in the head as follows:\n\u003Cscript type=\"module\" src=\"https://unpkg.com/ionicons@5.0.0/dist/ionicons/ionicons.esm.js\">\u003C/script>\n\u003Cscript nomodule=\"\" src=\"https://unpkg.com/ionicons@5.0.0/dist/ionicons/ionicons.js\">\u003C/script>"

Optimizations

Plugin configuration 93% from 29 tests

readme.txt 88% from 16 tests

It's important to format your readme.txt file correctly as it is parsed for the public listing of your plugin
Attributes that need to be fixed:
  • Screenshots: These screenshots lack descriptions #1, #10, #11, #2, #3, #4, #5, #6, #7, #8, #9 in ultimate-db-manager-lite/assets to your readme.txt
  • Tags: Too many tags (12 tag instead of maximum 10); only the first 5 tags are used in your directory listing
Please take inspiration from this readme.txt

ultimate-db-manager-lite/ultimate-db-manager-lite.php Passed 13 tests

The main PHP script in "Ultimate WP DB Manager - WordPress Database Backup, Cleanup & Optimize" version 1.3.4 is automatically included on every request by WordPress
45 characters long description:
WordPress Database Backup, Optimize & Cleanup

Code Analysis Passed 3 tests

File types Passed 1 test

🔸 Test weight: 35 | This is a short overview of programming languages used in this plugin, detecting executable files
Success! There were no dangerous files found in this plugin7,031 lines of code in 60 files:
LanguageFilesBlank linesComment linesLines of code
PHP499791,7143,285
CSS3386363,054
JavaScript8274255692

PHP code Passed 2 tests

This is a short overview of cyclomatic complexity and code structure for this plugin
Great job! No cyclomatic complexity issues were detected in this plugin
Cyclomatic complexity
Average complexity per logical line of code0.31
Average class complexity12.71
▷ Minimum class complexity1.00
▷ Maximum class complexity60.00
Average method complexity2.57
▷ Minimum method complexity1.00
▷ Maximum method complexity32.00
Code structure
Namespaces0
Interfaces0
Traits0
Classes24
▷ Abstract classes312.50%
▷ Concrete classes2187.50%
▷ Final classes00.00%
Methods182
▷ Static methods63.30%
▷ Public methods16590.66%
▷ Protected methods84.40%
▷ Private methods94.95%
Functions23
▷ Named functions23100.00%
▷ Anonymous functions00.00%
Constants7
▷ Global constants342.86%
▷ Class constants457.14%
▷ Public constants4100.00%

Plugin size Passed 2 tests

Image compression Passed 2 tests

All PNG images should be compressed to minimize bandwidth usage for end users
3 PNG files occupy 0.02MB with 0.01MB in potential savings
Potential savings
Compression of 3 random PNG files using pngquant
FileSize - originalSize - compressedSavings
assets/images/buy.png4.64KB3.54KB▼ 23.59%
assets/images/bottom-dashed.png1.72KB0.19KB▼ 88.70%
assets/images/ultimate.png18.98KB12.00KB▼ 36.80%