83% database-to-excel

Code Review | Database to Excel

WordPress plugin Database to Excel scored83%from 54 tests.

About plugin

  • Plugin page: database-to-excel
  • Plugin version: 1.0
  • PHP version: 7.4.16
  • WordPress compatibility: 2.9.0-4.2
  • WordPress version: 6.3.1
  • First release: Sep 16, 2015
  • Latest release: Sep 18, 2015
  • Number of updates: 22
  • Update frequency: every 2.3 days
  • Top authors: mister.subhash (100%)

Code review

54 tests

User reviews

2 reviews

Install metrics

200+ active /7,610 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.06MB] [CPU: ▼13.63ms] Passed 4 tests

This is a short check of server-side resources used by Database to Excel
No issues were detected with server-side resource usage
PageMemory (MB)CPU Time (ms)
Home /3.51 ▲0.0436.01 ▼5.08
Dashboard /wp-admin3.39 ▲0.0443.51 ▼24.75
Posts /wp-admin/edit.php3.43 ▲0.0747.58 ▼4.34
Add New Post /wp-admin/post-new.php6.08 ▲0.1983.47 ▼20.35
Media Library /wp-admin/upload.php3.33 ▲0.1034.56 ▲0.93

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

Analyzing filesystem and database footprints of this plugin
There were no storage issued detected upon installing this plugin
Filesystem: 4 new files
Database: no new tables, 6 new options
New WordPress options
widget_theysaidso_widget
widget_recent-comments
can_compress_scripts
db_upgraded
widget_recent-posts
theysaidso_admin_options

Browser metrics Passed 4 tests

Checking browser requirements for Database to Excel
This plugin has a minimal impact on browser resources
PageNodesMemory (MB)Script (ms)Layout (ms)
Home /2,817 ▲7114.47 ▲0.181.47 ▼0.3443.62 ▼1.00
Dashboard /wp-admin2,226 ▲354.88 ▼0.0196.92 ▼18.7776.04 ▲29.08
Posts /wp-admin/edit.php2,109 ▲201.98 ▼0.0137.87 ▼2.8435.20 ▼1.20
Add New Post /wp-admin/post-new.php1,543 ▲1018.23 ▼5.00706.25 ▲57.1969.45 ▲18.06
Media Library /wp-admin/upload.php1,405 ▲204.17 ▼0.2191.84 ▼6.2372.91 ▲29.39

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
  • This plugin did not uninstall successfully, leaving 6 options in the database
    • widget_theysaidso_widget
    • db_upgraded
    • widget_recent-posts
    • widget_recent-comments
    • can_compress_scripts
    • theysaidso_admin_options

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 no errors were found, 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
Please fix the following items
  • 1× PHP files trigger server-side errors or warnings when accessed directly:
    • > PHP Fatal error
      Uncaught Error: Call to undefined function add_action() in wp-content/plugins/database-to-excel/DatabaseToExcel.php:13

User-side errors Passed 1 test

🔹 Test weight: 20 | This is a shallow check for browser errors
Everything seems fine on the user side

Optimizations

Plugin configuration 90% from 29 tests

readme.txt 94% from 16 tests

Perhaps the most important file in your plugin readme.txt gets parsed in order to generate the public listing of your plugin
These attributes need to be fixed:
  • Donate link: Please fix this invalid URI: "#"
Please take inspiration from this readme.txt

database-to-excel/DatabaseToExcel.php 85% from 13 tests

The main PHP script in "Database to Excel" version 1.0 is automatically included on every request by WordPress
Please take the time to fix the following:
  • Description: If Twitter did it, so should we! Keep the description under 140 characters (currently 219 characters long)
  • Main file name: It is recommended to name the main PHP file as the plugin slug ("database-to-excel.php" instead of "DatabaseToExcel.php")

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
Everything looks great! No dangerous files found in this plugin148 lines of code in 2 files:
LanguageFilesBlank linesComment linesLines of code
PHP1410126
CSS10022

PHP code Passed 2 tests

An overview of cyclomatic complexity and code structure
There are no cyclomatic complexity problems detected for this plugin
Cyclomatic complexity
Average complexity per logical line of code0.33
Average class complexity0.00
▷ Minimum class complexity0.00
▷ Maximum class complexity0.00
Average method complexity0.00
▷ Minimum method complexity0.00
▷ Maximum method complexity0.00
Code structure
Namespaces0
Interfaces0
Traits0
Classes0
▷ Abstract classes00.00%
▷ Concrete classes00.00%
▷ Final classes00.00%
Methods0
▷ Static methods00.00%
▷ Public methods00.00%
▷ Protected methods00.00%
▷ Private methods00.00%
Functions2
▷ Named functions2100.00%
▷ Anonymous functions00.00%
Constants0
▷ Global constants00.00%
▷ Class constants00.00%
▷ Public constants00.00%

Plugin size Passed 2 tests

Image compression Passed 2 tests

Using a strong compression for your PNG files is a great way to speed-up your plugin
1 compressed PNG file occupies 0.00MB
Potential savings
Compression of 1 random PNG file using pngquant
FileSize - originalSize - compressedSavings
logo.png0.62KB0.55KB▼ 11.91%