78% sql-buddy

Code Review | SQL Buddy - Database Management Made Easy

WordPress plugin SQL Buddy - Database Management Made Easy scored78%from 54 tests.

About plugin

  • Plugin page: sql-buddy
  • Plugin version: 1.0.0
  • PHP compatiblity: 5.6+
  • PHP version: 7.4.16
  • WordPress compatibility: 5.3-6.3
  • WordPress version: 6.3.1
  • First release: Jan 12, 2022
  • Latest release: Sep 22, 2023
  • Number of updates: 10
  • Update frequency: every 62.0 days
  • Top authors: deliciousbrains (100%)

Code review

54 tests

User reviews

7 reviews

Install metrics

2,000+ active /13,104 total downloads

Benchmarks

Plugin footprint 83% from 16 tests

Installer Passed 1 test

🔺 Critical test (weight: 50) | Checking the installer triggered no errors
The plugin installed gracefully, with no errors

Server metrics [RAM: ▲0.01MB] [CPU: ▼11.59ms] Passed 4 tests

Server-side resources used by SQL Buddy - Database Management Made Easy
No issues were detected with server-side resource usage
PageMemory (MB)CPU Time (ms)
Home /3.48 ▲0.0237.76 ▼3.16
Dashboard /wp-admin3.32 ▼0.0244.33 ▼18.51
Posts /wp-admin/edit.php3.37 ▲0.0247.49 ▲3.76
Add New Post /wp-admin/post-new.php5.93 ▲0.0481.16 ▼22.45
Media Library /wp-admin/upload.php3.25 ▲0.0236.00 ▼2.25
SQL Buddy /wp-admin/tools.php?page=sql-buddy-dashboard3.2534.68

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

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

Browser metrics Passed 4 tests

A check of browser resources used by SQL Buddy - Database Management Made Easy
Normal browser usage
PageNodesMemory (MB)Script (ms)Layout (ms)
Home /2,804 ▲5813.25 ▼1.001.79 ▲0.1340.90 ▼1.44
Dashboard /wp-admin2,207 ▲215.77 ▲0.84103.21 ▼19.4739.20 ▼7.83
Posts /wp-admin/edit.php2,090 ▲12.18 ▲0.1735.27 ▼2.0931.87 ▼2.14
Add New Post /wp-admin/post-new.php1,536 ▲323.00 ▼0.21672.25 ▼38.3054.40 ▼12.62
Media Library /wp-admin/upload.php1,392 ▲44.24 ▼0.0195.35 ▼14.5542.88 ▼2.69
SQL Buddy /wp-admin/tools.php?page=sql-buddy-dashboard1,0737.84182.0743.31

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

🔸 Tests weight: 35 | All plugins must uninstall correctly, removing their source code and extra database tables they might have created
The following items require your attention
  • The uninstall procedure has failed, leaving 6 options in the database
    • theysaidso_admin_options
    • widget_theysaidso_widget
    • can_compress_scripts
    • db_upgraded
    • widget_recent-comments
    • widget_recent-posts

Smoke tests 50% 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 0% 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
The following issues need your attention
  • 1× GET requests to PHP files return non-empty strings:
    • > /wp-content/plugins/sql-buddy/includes/templates/admin/dashboard.php
  • 3× PHP files trigger server-side errors or warnings when accessed directly:
    • > PHP Fatal error
      Uncaught Error: Class 'WP_REST_Controller' not found in wp-content/plugins/sql-buddy/includes/REST_API/Table_Controller.php:25
    • > PHP Fatal error
      Trait 'SQL_Buddy\\Traits\\Assets' not found in wp-content/plugins/sql-buddy/includes/Dashboard.php on line 19
    • > PHP Fatal error
      Uncaught Error: Call to undefined function SQL_Buddy\\register_activation_hook() in wp-content/plugins/sql-buddy/includes/namespace.php:52

User-side errors Passed 1 test

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

Optimizations

Plugin configuration 96% from 29 tests

readme.txt Passed 16 tests

The readme.txt file describes your plugin functionality and requirements and it is parsed to prepare the your plugin's listing
5 plugin tags: database management, database queries, sql, database, database browser

sql-buddy/sql-buddy.php 92% from 13 tests

The primary PHP file in "SQL Buddy - Database Management Made Easy" version 1.0.0 is used by WordPress to initiate all plugin functionality
It is important to fix the following:
  • Domain Path: The domain path folder was not found ("/languages")

Code Analysis Passed 3 tests

File types Passed 1 test

🔸 Test weight: 35 | A short check of programming languages and file extensions; no executable files are allowed
Everything looks great! No dangerous files found in this plugin1,028 lines of code in 27 files:
LanguageFilesBlank linesComment linesLines of code
PHP212325801,022
JavaScript4004
CSS2002

PHP code Passed 2 tests

This plugin's cyclomatic complexity and code structure detailed below
Great job! No cyclomatic complexity issues were detected in this plugin
Cyclomatic complexity
Average complexity per logical line of code0.32
Average class complexity10.40
▷ Minimum class complexity1.00
▷ Maximum class complexity44.00
Average method complexity2.47
▷ Minimum method complexity1.00
▷ Maximum method complexity18.00
Code structure
Namespaces4
Interfaces0
Traits1
Classes9
▷ Abstract classes00.00%
▷ Concrete classes9100.00%
▷ Final classes111.11%
Methods66
▷ Static methods710.61%
▷ Public methods6090.91%
▷ Protected methods46.06%
▷ Private methods23.03%
Functions11
▷ Named functions436.36%
▷ Anonymous functions763.64%
Constants8
▷ Global constants675.00%
▷ Class constants225.00%
▷ Public constants2100.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
1 PNG file occupies 0.03MB with 0.01MB in potential savings
Potential savings
Compression of 1 random PNG file using pngquant
FileSize - originalSize - compressedSavings
assets/images/icon-256x256.png25.79KB11.15KB▼ 56.78%