84% sqlite-database-integration

Code Review | SQLite Database Integration

WordPress plugin SQLite Database Integration scored84%from 54 tests.

About plugin

  • Plugin page: sqlite-database-i...
  • Plugin version: 2.1.2
  • PHP compatiblity: 5.6+
  • PHP version: 7.4.16
  • WordPress compatibility: 6.0-6.4
  • WordPress version: 6.3.1
  • First release: Jan 17, 2023
  • Latest release: Oct 18, 2023
  • Number of updates: 11
  • Update frequency: every 25.0 days
  • Top authors: aristath (100%)

Code review

54 tests

User reviews

4 reviews

Install metrics

200+ active /4,971 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
Installer ran successfully

Server metrics [RAM: ▲0.06MB] [CPU: ▼5.28ms] Passed 4 tests

Analyzing server-side resources used by SQLite Database Integration
This plugin has minimal impact on server resources
PageMemory (MB)CPU Time (ms)
Home /3.54 ▲0.0836.05 ▼2.20
Dashboard /wp-admin3.37 ▲0.0344.65 ▼14.88
Posts /wp-admin/edit.php3.43 ▲0.0748.52 ▲3.45
Add New Post /wp-admin/post-new.php5.96 ▲0.0790.91 ▼2.88
Media Library /wp-admin/upload.php3.30 ▲0.0733.99 ▼1.14
SQLite integration /wp-admin/options-general.php?page=sqlite-integration3.2629.60

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

Filesystem and database footprint
No storage issues were detected
Filesystem: 18 new files
Database: no new tables, 6 new options
New WordPress options
db_upgraded
can_compress_scripts
theysaidso_admin_options
widget_recent-posts
widget_theysaidso_widget
widget_recent-comments

Browser metrics Passed 4 tests

This is an overview of browser requirements for SQLite Database Integration
There were no issues detected in relation to browser resource usage
PageNodesMemory (MB)Script (ms)Layout (ms)
Home /2,847 ▲8614.33 ▲0.071.92 ▲0.3840.41 ▼0.36
Dashboard /wp-admin2,221 ▲415.61 ▲0.0890.82 ▲2.5244.43 ▲4.14
Posts /wp-admin/edit.php2,123 ▲231.98 ▼0.0140.64 ▲4.1540.19 ▲5.70
Add New Post /wp-admin/post-new.php1,542 ▲1623.30 ▼0.33642.87 ▼30.4352.16 ▼5.83
Media Library /wp-admin/upload.php1,426 ▲234.21 ▲0.0395.29 ▲0.2245.45 ▲0.27
SQLite integration /wp-admin/options-general.php?page=sqlite-integration7972.0023.7925.93

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
You still need to fix the following
  • Zombie WordPress options were found after uninstall: 6 options
    • theysaidso_admin_options
    • can_compress_scripts
    • widget_recent-posts
    • widget_theysaidso_widget
    • widget_recent-comments
    • db_upgraded

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 | It is important to ensure that your PHP files perform no action when accessed directly, respecting the single-responsibility principle
Please fix the following
  • 9× PHP files trigger errors when accessed directly with GET requests:
    • > PHP Fatal error
      Uncaught Error: Call to undefined function register_deactivation_hook() in wp-content/plugins/sqlite-database-integration/deactivate.php:68
    • > PHP Warning
      Use of undefined constant ABSPATH - assumed 'ABSPATH' (this will throw an Error in a future version of PHP) in wp-content/plugins/sqlite-database-integration/constants.php on line 39
    • > PHP Warning
      Use of undefined constant ABSPATH - assumed 'ABSPATH' (this will throw an Error in a future version of PHP) in wp-content/plugins/sqlite-database-integration/constants.php on line 39
    • > PHP Fatal error
      Uncaught Error: Call to undefined function add_filter() in wp-content/plugins/sqlite-database-integration/health-check.php:62
    • > PHP Fatal error
      Uncaught Error: Class 'wpdb' not found in wp-content/plugins/sqlite-database-integration/wp-includes/sqlite/class-wp-sqlite-db.php:14
    • > PHP Fatal error
      Uncaught Error: Call to undefined function add_action() in wp-content/plugins/sqlite-database-integration/admin-notices.php:73
    • > PHP Fatal error
      Uncaught Error: Call to undefined function add_action() in wp-content/plugins/sqlite-database-integration/activate.php:22
    • > PHP Fatal error
      Uncaught Error: Call to undefined function add_action() in wp-content/plugins/sqlite-database-integration/admin-page.php:23
    • > PHP Fatal error
      Uncaught Error: Call to undefined function add_action() in wp-content/plugins/sqlite-database-integration/admin-page.php:23

User-side errors Passed 1 test

🔹 Test weight: 20 | A shallow check that no browser errors were triggered
No browser errors were detected

Optimizations

Plugin configuration 96% from 29 tests

readme.txt Passed 16 tests

Perhaps the most important file in your plugin readme.txt gets parsed in order to generate the public listing of your plugin
2 plugin tags: database, performance

sqlite-database-integration/load.php 92% from 13 tests

The main PHP script in "SQLite Database Integration" version 2.1.2 is automatically included on every request by WordPress
You should first fix the following items:
  • Main file name: Please rename the main PHP file in this plugin to the plugin slug ("sqlite-database-integration.php" instead of "load.php")

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
Success! There were no dangerous files found in this plugin5,244 lines of code in 15 files:
LanguageFilesBlank linesComment linesLines of code
PHP157902,7995,244

PHP code Passed 2 tests

A short review of cyclomatic complexity and code structure
There were no cyclomatic complexity issued detected
Cyclomatic complexity
Average complexity per logical line of code0.46
Average class complexity115.33
▷ Minimum class complexity16.00
▷ Maximum class complexity349.00
Average method complexity4.76
▷ Minimum method complexity1.00
▷ Maximum method complexity64.00
Code structure
Namespaces0
Interfaces0
Traits0
Classes6
▷ Abstract classes00.00%
▷ Concrete classes6100.00%
▷ Final classes00.00%
Methods177
▷ Static methods95.08%
▷ Public methods11464.41%
▷ Protected methods10.56%
▷ Private methods6235.03%
Functions17
▷ Named functions1270.59%
▷ Anonymous functions529.41%
Constants55
▷ Global constants916.36%
▷ Class constants4683.64%
▷ Public constants46100.00%

Plugin size Passed 2 tests

Image compression Passed 2 tests

All PNG images should be compressed to minimize bandwidth usage for end users
PNG images were not found in this plugin