90% sheetdb

Code Review | SheetDB - get your Google Spreadsheet data

WordPress plugin SheetDB - get your Google Spreadsheet data scored90%from 54 tests.

About plugin

  • Plugin page: sheetdb
  • Plugin version: 1.1.8
  • PHP compatiblity: 5.4+
  • PHP version: 7.4.16
  • WordPress compatibility: 4.0-6.3.0
  • WordPress version: 6.3.1
  • First release: Nov 13, 2019
  • Latest release: Jul 22, 2023
  • Number of updates: 44
  • Update frequency: every 30.6 days
  • Top authors: sheetdb (100%)

Code review

54 tests

User reviews

5 reviews

Install metrics

800+ active /9,880 total downloads

Benchmarks

Plugin footprint 83% from 16 tests

Installer Passed 1 test

🔺 Critical test (weight: 50) | Verifying that this plugin installs correctly without errors
The plugin installed successfully, without throwing any errors or notices

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

An overview of server-side resources used by SheetDB - get your Google Spreadsheet data
Normal server usage
PageMemory (MB)CPU Time (ms)
Home /3.47 ▲0.0038.49 ▼3.41
Dashboard /wp-admin3.31 ▼0.0448.74 ▼18.86
Posts /wp-admin/edit.php3.36 ▲0.0050.31 ▼2.01
Add New Post /wp-admin/post-new.php5.89 ▲0.0095.35 ▼11.14
Media Library /wp-admin/upload.php3.23 ▲0.0037.65 ▼2.92

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

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

Browser metrics Passed 4 tests

A check of browser resources used by SheetDB - get your Google Spreadsheet data
There were no issues detected in relation to browser resource usage
PageNodesMemory (MB)Script (ms)Layout (ms)
Home /2,791 ▲3014.75 ▲0.331.93 ▲0.3339.64 ▼3.67
Dashboard /wp-admin2,195 ▲155.55 ▼0.1383.90 ▼4.9139.42 ▼4.97
Posts /wp-admin/edit.php2,100 ▼02.00 ▲0.0140.59 ▼1.5937.40 ▲0.11
Add New Post /wp-admin/post-new.php1,554 ▲2318.32 ▼4.80630.37 ▲27.0948.70 ▼4.48
Media Library /wp-admin/upload.php1,400 ▲64.22 ▼0.01101.20 ▲1.7942.31 ▲1.47

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
You still need to fix the following
  • This plugin does not fully uninstall, leaving 6 options in the database
    • widget_theysaidso_widget
    • widget_recent-comments
    • can_compress_scripts
    • theysaidso_admin_options
    • widget_recent-posts
    • db_upgraded

Smoke tests Passed 4 tests

Server-side errors Passed 1 test

🔹 Test weight: 20 | This is a short smoke test looking for server-side errors
Everything seems fine, however this is by no means an exhaustive test

SRP Passed 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
Congratulations! This plugin passed the SRP test

User-side errors Passed 1 test

🔹 Test weight: 20 | A shallow check that no browser errors were triggered
There were no browser issues found

Optimizations

Plugin configuration Passed 29 tests

readme.txt Passed 16 tests

Often overlooked, readme.txt is one of the most important files in your plugin
6 plugin tags: google spreadsheet, google api, api, sheetdb, google sheets...

sheetdb/sheetdb.php Passed 13 tests

The primary PHP file in "SheetDB - get your Google Spreadsheet data" version 1.1.8 is used by WordPress to initiate all plugin functionality
109 characters long description:
The SheetDB wordpress plugin allows you to easily add content from Google Spreadsheet to your wordpress site.

Code Analysis Passed 3 tests

File types Passed 1 test

🔸 Test weight: 35 | Executable files are not allowed as they can serve as attack vectors
Success! There were no dangerous files found in this plugin79 lines of code in 3 files:
LanguageFilesBlank linesComment linesLines of code
PHP2182778
JavaScript1001

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.75
Average class complexity26.00
▷ Minimum class complexity26.00
▷ Maximum class complexity26.00
Average method complexity6.00
▷ Minimum method complexity1.00
▷ Maximum method complexity14.00
Code structure
Namespaces0
Interfaces0
Traits0
Classes1
▷ Abstract classes00.00%
▷ Concrete classes1100.00%
▷ Final classes00.00%
Methods5
▷ Static methods00.00%
▷ Public methods480.00%
▷ Protected methods00.00%
▷ Private methods120.00%
Functions0
▷ Named functions00.00%
▷ Anonymous functions00.00%
Constants0
▷ Global constants00.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
No PNG images were found in this plugin