83% wpdb-to-sql

Code Review | WPDB to Sql

WordPress plugin WPDB to Sql scored83%from 54 tests.

About plugin

  • Plugin page: wpdb-to-sql
  • Plugin version: 1.2
  • PHP version: 7.4.16
  • WordPress compatibility: 4.1-5.7.2
  • WordPress version: 6.3.1
  • First release: Jan 7, 2020
  • Latest release: May 13, 2021
  • Number of updates: 16
  • Update frequency: every 30.8 days
  • Top authors: joshiniket14outlook (100%)

Code review

54 tests

User reviews

1 review

Install metrics

300+ active /3,475 total downloads

Benchmarks

Plugin footprint 83% from 16 tests

Installer Passed 1 test

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

Server metrics [RAM: ▲0.02MB] [CPU: ▼6.19ms] Passed 4 tests

Server-side resources used by WPDB to Sql
Server-side resource usage in normal parameters
PageMemory (MB)CPU Time (ms)
Home /3.48 ▲0.0241.23 ▲0.44
Dashboard /wp-admin3.33 ▲0.0245.01 ▼3.26
Posts /wp-admin/edit.php3.38 ▲0.0248.66 ▼2.53
Add New Post /wp-admin/post-new.php5.91 ▲0.0286.36 ▼18.12
Media Library /wp-admin/upload.php3.25 ▲0.0233.91 ▼0.84
Export WPDB2SQL /wp-admin/tools.php?page=wpdb-sql3.2130.80

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

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

Browser metrics Passed 4 tests

A check of browser resources used by WPDB to Sql
This plugin renders optimally with no browser resource issues detected
PageNodesMemory (MB)Script (ms)Layout (ms)
Home /2,829 ▲7213.32 ▼1.062.43 ▲0.1139.31 ▼10.81
Dashboard /wp-admin2,210 ▲195.87 ▲0.98102.96 ▲0.5539.69 ▼1.83
Posts /wp-admin/edit.php2,093 ▲41.99 ▼0.0138.78 ▲2.8435.62 ▼0.40
Add New Post /wp-admin/post-new.php1,536 ▲2223.26 ▲5.82666.01 ▲7.0654.33 ▲11.92
Media Library /wp-admin/upload.php1,395 ▲104.22 ▼0.1598.16 ▼14.8841.17 ▼7.85
Export WPDB2SQL /wp-admin/tools.php?page=wpdb-sql8982.1924.2029.66

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
These items require your attention
  • Zombie WordPress options detected upon uninstall: 6 options
    • can_compress_scripts
    • widget_theysaidso_widget
    • theysaidso_admin_options
    • widget_recent-comments
    • db_upgraded
    • widget_recent-posts

Smoke tests 75% from 4 tests

Server-side errors Passed 1 test

🔹 Test weight: 20 | A shallow check that no server-side errors were triggered
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
Please take a closer look at the following
  • 2× 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/wpdb-to-sql/wpdb-sql.php:37
    • > PHP Fatal error
      Uncaught Error: Call to undefined function esc_html() in wp-content/plugins/wpdb-to-sql/display-wpdb-sql.php:3

User-side errors Passed 1 test

🔹 Test weight: 20 | This is just a short smoke test looking for browser issues
No browser issues were found

Optimizations

Plugin configuration 83% from 29 tests

readme.txt 88% from 16 tests

The readme.txt file describes your plugin functionality and requirements and it is parsed to prepare the your plugin's listing
These attributes need to be fixed:
  • Requires php: Invalid version format
  • Plugin Name: "Plugin Name" should be replaced with the name of your plugin on the first line ( === wpdb-to-sql === )
The official readme.txt might help

wpdb-to-sql/wpdb-sql.php 77% from 13 tests

"WPDB to Sql" version 1.2's primary PHP file adds more information about the plugin and serves as the entry point for WordPress
The following require your attention:
  • Main file name: Even though not officially enforced, the main plugin file should be the same as the plugin slug ("wpdb-to-sql.php" instead of "wpdb-sql.php")
  • Text Domain: You no longer need to specify the text domain since WordPress 4.6; it must be the same as the plugin slug
  • Domain Path: The domain path folder does not exist ("/languages")

Code Analysis Passed 3 tests

File types Passed 1 test

🔸 Test weight: 35 | A short review of files and their extensions; it is not recommended to include executable files
No dangerous file extensions were detected143 lines of code in 3 files:
LanguageFilesBlank linesComment linesLines of code
PHP31726143

PHP code Passed 2 tests

An short overview of logical lines of code, cyclomatic complexity, and other code metrics
There are no cyclomatic complexity problems detected for this plugin
Cyclomatic complexity
Average complexity per logical line of code0.37
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%
Functions3
▷ Named functions3100.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 PNG file occupies 0.01MB with 0.00MB in potential savings
Potential savings
Compression of 1 random PNG file using pngquant
FileSize - originalSize - compressedSavings
assets/images/ecodeblog.png7.58KB2.60KB▼ 65.77%