84% database-backup

Code Review | Database Backup and check Tables Automated With Scheduler 2024

WordPress plugin Database Backup and check Tables Automated With Scheduler 2024 scored84%from 54 tests.

About plugin

  • Plugin page: database-backup
  • Plugin version: 2.22
  • PHP version: 7.4.16
  • WordPress compatibility: 5.2-6.4
  • WordPress version: 6.3.1
  • First release: Jan 18, 2023
  • Latest release: Nov 10, 2023
  • Number of updates: 137
  • Update frequency: every 2.2 days
  • Top authors: sminozzi (100%)

Code review

54 tests

User reviews

1 review

Install metrics

80+ active /2,027 total downloads

Benchmarks

Plugin footprint 83% from 16 tests

Installer Passed 1 test

🔺 Critical test (weight: 50) | Checking the installer triggered no errors
This plugin's installer ran successfully

Server metrics [RAM: ▲0.15MB] [CPU: ▼6.57ms] Passed 4 tests

Server-side resources used by Database Backup and check Tables Automated With Scheduler 2024
Server-side resource usage in normal parameters
PageMemory (MB)CPU Time (ms)
Home /3.56 ▲0.1035.91 ▼9.44
Dashboard /wp-admin3.47 ▲0.1645.44 ▼4.68
Posts /wp-admin/edit.php3.58 ▲0.2247.97 ▲0.54
Add New Post /wp-admin/post-new.php6.07 ▲0.1881.53 ▼12.71
Media Library /wp-admin/upload.php3.39 ▲0.1636.09 ▲1.79
Database Backup /wp-admin/admin.php?page=database_backup_admin_page3.3733.91

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

Input-output and database impact of this plugin
This plugin installed successfully
Filesystem: 34 new files
Database: no new tables, 8 new options
New WordPress options
widget_recent-comments
widget_theysaidso_widget
widget_recent-posts
theysaidso_admin_options
bill_show_warnings
can_compress_scripts
db_upgraded
database_backup_was_activated

Browser metrics Passed 4 tests

Checking browser requirements for Database Backup and check Tables Automated With Scheduler 2024
This plugin has a minimal impact on browser resources
PageNodesMemory (MB)Script (ms)Layout (ms)
Home /2,868 ▲10614.56 ▲0.221.75 ▼0.0540.88 ▼6.39
Dashboard /wp-admin2,271 ▲915.91 ▲0.25108.12 ▲7.3441.76 ▼0.86
Posts /wp-admin/edit.php2,176 ▲762.53 ▲0.5355.06 ▲17.3234.20 ▲0.44
Add New Post /wp-admin/post-new.php1,566 ▲4023.94 ▲0.83663.47 ▲14.9436.21 ▼31.36
Media Library /wp-admin/upload.php1,479 ▲794.95 ▲0.76110.71 ▲10.4542.85 ▲2.44
Database Backup /wp-admin/admin.php?page=database_backup_admin_page9262.0042.9839.84

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

🔸 Tests weight: 35 | It is important to correctly uninstall your plugin, without leaving any traces
You still need to fix the following
  • The uninstall procedure has failed, leaving 8 options in the database
    • widget_recent-posts
    • widget_recent-comments
    • can_compress_scripts
    • database_backup_was_activated
    • bill_show_warnings
    • theysaidso_admin_options
    • db_upgraded
    • widget_theysaidso_widget

Smoke tests 75% from 4 tests

Server-side errors Passed 1 test

🔹 Test weight: 20 | A smoke test targeting server-side errors
Even though everything seems fine, this is not an exhaustive test

SRP 50% from 2 tests

🔹 Tests weight: 20 | SRP (Single-Responsibility Principle) - PHP files must act as libraries and never output text or perform any action when accessed directly in a browser
Please fix the following
  • 18× GET requests to PHP files return non-empty strings (only 10 are shown):
    • > /wp-content/plugins/database-backup/functions/restorebackup.php
    • > /wp-content/plugins/database-backup/dashboard/dashboard_more.php
    • > /wp-content/plugins/database-backup/dashboard/dashboard-settings.php
    • > /wp-content/plugins/database-backup/functions/dorestore-shell.php
    • > /wp-content/plugins/database-backup/functions/download.php
    • > /wp-content/plugins/database-backup/includes/checkup/bill_class_diagnose.php
    • > /wp-content/plugins/database-backup/dashboard/backup.php
    • > /wp-content/plugins/database-backup/database-backup.php
    • > /wp-content/plugins/database-backup/functions/docopy.php
    • > /wp-content/plugins/database-backup/functions/dorestore.php

User-side errors Passed 1 test

🔹 Test weight: 20 | This is a shallow check for browser errors
There were no browser issues found

Optimizations

Plugin configuration 97% from 29 tests

readme.txt 94% from 16 tests

You should put a lot of thought into formatting readme.txt as it is used by WordPress.org to prepare the public listing of your plugin
Please fix the following attributes:
  • Screenshots: These screenshots have no corresponding images in /assets: #1 (Dashboard), #2 (Run a Backup), #3 (Backup Table)
Please take inspiration from this readme.txt

database-backup/database-backup.php Passed 13 tests

"Database Backup and check Tables Automated With Scheduler 2024" version 2.22's main PHP file describes plugin functionality and also serves as the entry point to any WordPress functionality
51 characters long description:
Smart Database Backup and check tables Made Simple.

Code Analysis Passed 3 tests

File types Passed 1 test

🔸 Test weight: 35 | There should be no dangerous file extensions present in any WordPress plugin
Good job! No executable or dangerous file extensions detected3,525 lines of code in 25 files:
LanguageFilesBlank linesComment linesLines of code
PHP183744382,497
JavaScript3120121686
CSS44317342

PHP code Passed 2 tests

This is a very shot review of cyclomatic complexity and code structure
No cyclomatic complexity issues were detected for this plugin
Cyclomatic complexity
Average complexity per logical line of code0.38
Average class complexity16.33
▷ Minimum class complexity1.00
▷ Maximum class complexity47.00
Average method complexity3.50
▷ Minimum method complexity1.00
▷ Maximum method complexity19.00
Code structure
Namespaces0
Interfaces0
Traits0
Classes3
▷ Abstract classes00.00%
▷ Concrete classes3100.00%
▷ Final classes00.00%
Methods19
▷ Static methods15.26%
▷ Public methods1789.47%
▷ Protected methods00.00%
▷ Private methods210.53%
Functions36
▷ Named functions36100.00%
▷ Anonymous functions00.00%
Constants7
▷ Global constants7100.00%
▷ Class constants00.00%
▷ Public constants00.00%

Plugin size Passed 2 tests

Image compression Passed 2 tests

It is recommended to compress PNG files in your plugin to minimize bandwidth usage
5 PNG files occupy 0.46MB with 0.30MB in potential savings
Potential savings
Compression of 5 random PNG files using pngquant
FileSize - originalSize - compressedSavings
screenshot-2.png126.04KB41.13KB▼ 67.37%
screenshot-3.png149.46KB49.87KB▼ 66.63%
includes/checkup/bell.png1.07KB0.27KB▼ 74.45%
screenshot-1.png186.92KB60.56KB▼ 67.60%
assets/images/logo.png12.20KB6.49KB▼ 46.83%