78% sqlite-cache

Code Review | SQLite Cache

WordPress plugin SQLite Cache scored78%from 54 tests.

About plugin

  • Plugin page: sqlite-cache
  • Plugin version: 0.6.2
  • PHP version: 7.4.16
  • WordPress compatibility: 3.8.1-4.5.3
  • WordPress version: 6.3.1
  • First release: May 21, 2015
  • Latest release: Jul 1, 2016
  • Number of updates: 9
  • Update frequency: every 45.1 days
  • Top authors: andreyk (100%)

Code review

54 tests

User reviews

2 reviews

Install metrics

10+ active /1,323 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
Install script ran successfully

Server metrics [RAM: ▲0.08MB] [CPU: ▼7.22ms] Passed 4 tests

An overview of server-side resources used by SQLite Cache
This plugin has minimal impact on server resources
PageMemory (MB)CPU Time (ms)
Home /3.53 ▲0.0733.72 ▼6.15
Dashboard /wp-admin3.39 ▲0.0852.53 ▲4.26
Posts /wp-admin/edit.php3.44 ▲0.0847.62 ▼2.91
Add New Post /wp-admin/post-new.php5.97 ▲0.0878.32 ▼16.87
Media Library /wp-admin/upload.php3.31 ▲0.0833.41 ▼2.96
SQLite Cache /wp-admin/options-general.php?page=sqlite_cache3.2528.02

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

A short overview of filesystem and database impact
The plugin installed successfully
Filesystem: 8 new files
Database: no new tables, 6 new options
New WordPress options
can_compress_scripts
theysaidso_admin_options
widget_theysaidso_widget
db_upgraded
widget_recent-comments
widget_recent-posts

Browser metrics Passed 4 tests

Checking browser requirements for SQLite Cache
This plugin renders optimally with no browser resource issues detected
PageNodesMemory (MB)Script (ms)Layout (ms)
Home /2,804 ▲3314.78 ▲0.361.65 ▼0.3939.38 ▼5.49
Dashboard /wp-admin2,213 ▲284.83 ▼0.03111.42 ▼4.3841.48 ▼9.41
Posts /wp-admin/edit.php2,093 ▲42.01 ▲0.0139.49 ▲1.8934.25 ▼3.49
Add New Post /wp-admin/post-new.php1,536 ▼823.38 ▲5.00644.96 ▼7.7348.64 ▼3.90
Media Library /wp-admin/upload.php1,392 ▲104.24 ▲0.0296.87 ▼2.6440.38 ▼2.86
SQLite Cache /wp-admin/options-general.php?page=sqlite_cache9502.1626.7933.85

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

🔸 Tests weight: 35 | The uninstall procedure must remove all plugin files and extra database tables
Please fix the following items
  • This plugin does not fully uninstall, leaving 6 options in the database
    • widget_recent-comments
    • can_compress_scripts
    • db_upgraded
    • widget_recent-posts
    • theysaidso_admin_options
    • widget_theysaidso_widget

Smoke tests 50% from 4 tests

Server-side errors 0% from 1 test

🔹 Test weight: 20 | Just a short smoke test targeting errors on the server (in the Apache logs)
Please fix the following server-side errors
    • > GET request to /wp-admin/options-general.php?page=sqlite_cache
    • > Warning in wp-content/plugins/sqlite-cache/wp-sqlite-cache.php+113
    parse_ini_file(/domains/wp.com.ini): failed to open stream: No such file or directory
  • 6 occurences, only the last one shown
    • > GET request to /wp-admin/options-general.php?page=sqlite_cache
    • > Notice in wp-content/plugins/sqlite-cache/wp-sqlite-cache.php+143
    Trying to access array offset on value of type bool

SRP 50% from 2 tests

🔹 Tests weight: 20 | It is important to ensure that your PHP files perform no action when accessed directly, respecting the single-responsibility principle
Almost there! Just 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/sqlite-cache/wp-sqlite-cache.php:37

User-side errors Passed 1 test

🔹 Test weight: 20 | This is just a short smoke test looking for browser issues
Everything seems fine, but this is not an exhaustive test

Optimizations

Plugin configuration 93% from 29 tests

readme.txt Passed 16 tests

It's important to format your readme.txt file correctly as it is parsed for the public listing of your plugin
3 plugin tags: sqlite, cache, performance

sqlite-cache/wp-sqlite-cache.php 85% from 13 tests

The primary PHP file in "SQLite Cache" version 0.6.2 is used by WordPress to initiate all plugin functionality
You should first fix the following items:
  • Description: Please keep the plugin description shorter than 140 characters (currently 249 characters long)
  • Main file name: It is recommended to name the main PHP file as the plugin slug ("sqlite-cache.php" instead of "wp-sqlite-cache.php")

Code Analysis Passed 3 tests

File types Passed 1 test

🔸 Test weight: 35 | Executable files are considered dangerous and should not be included with any WordPress plugin
Everything looks great! No dangerous files found in this plugin705 lines of code in 5 files:
LanguageFilesBlank linesComment linesLines of code
PHP27430457
PO File280142239
SQL1109

PHP code Passed 2 tests

Cyclomatic complexity and code structure are the fingerprint of this plugin
Everything seems fine, there were no complexity issues found
Cyclomatic complexity
Average complexity per logical line of code0.52
Average class complexity66.00
▷ Minimum class complexity66.00
▷ Maximum class complexity66.00
Average method complexity17.25
▷ Minimum method complexity12.00
▷ Maximum method complexity24.00
Code structure
Namespaces0
Interfaces0
Traits0
Classes1
▷ Abstract classes00.00%
▷ Concrete classes1100.00%
▷ Final classes00.00%
Methods4
▷ Static methods00.00%
▷ Public methods250.00%
▷ Protected methods00.00%
▷ Private methods250.00%
Functions13
▷ Named functions13100.00%
▷ Anonymous functions00.00%
Constants1
▷ Global constants1100.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
There were not PNG files found in your plugin