10% next-tiny-db

Code Review | Next Tiny DB

WordPress plugin Next Tiny DB scored10%from 54 tests.

About plugin

  • Plugin page: next-tiny-db
  • Plugin version: 2.2.1
  • PHP compatiblity: 7.3+
  • PHP version: 7.4.16
  • WordPress compatibility: 5.3-6.3
  • WordPress version: 6.3.1
  • First release: Dec 2, 2022
  • Latest release: Aug 9, 2023
  • Number of updates: 21
  • Update frequency: every 11.9 days
  • Top authors: nxtweb (100%)

Code review

54 tests

User reviews

1 review

Install metrics

10+ active /156 total downloads

Benchmarks

Plugin footprint 40% from 16 tests

Installer 0% from 1 test

🔺 Critical test (weight: 50) | All plugins must install correctly, without throwing any errors, warnings, or notices
It is recommended to fix the following installer errors
  • This plugin did not install gracefully
    • > Notice in wp-content/plugins/next-tiny-db/includes/ntdb-functions.php+65
    fgets(): read of 8192 bytes failed with errno=21 Is a directory

Server metrics [RAM: ▼1.58MB] [CPU: ▼51.59ms] Passed 4 tests

This is a short check of server-side resources used by Next Tiny DB
No issues were detected with server-side resource usage
PageMemory (MB)CPU Time (ms)
Home /2.40 ▼1.066.97 ▼34.28
Dashboard /wp-admin2.42 ▼0.8810.34 ▼48.95
Posts /wp-admin/edit.php2.42 ▼0.938.80 ▼40.03
Add New Post /wp-admin/post-new.php2.42 ▼3.467.97 ▼83.08
Media Library /wp-admin/upload.php2.42 ▼0.8010.44 ▼23.66
Next Tiny DB /wp-admin/admin.php?page=ntdb-acp2.427.18
Settings /wp-admin/admin.php?page=ntdb-acp&tab=ntdb_settings2.427.22
Databases /wp-admin/admin.php?page=ntdb-acp&tab=ntdb_databases2.428.47
Help /wp-admin/admin.php?page=ntdb-acp&tab=ntdb_help2.427.40

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

Filesystem and database footprint
This plugin installed successfully
Filesystem: 13 new files
Database: no new tables, 8 new options
New WordPress options
ntdbCurrentType
widget_recent-posts
widget_theysaidso_widget
theysaidso_admin_options
db_upgraded
ntdbCurrentVersion
can_compress_scripts
widget_recent-comments

Browser metrics Passed 4 tests

Next Tiny DB: an overview of browser usage
This plugin has a minimal impact on browser resources
PageNodesMemory (MB)Script (ms)Layout (ms)
Home /3,001 ▲26615.08 ▲0.501.90 ▲0.1539.69 ▼9.56
Dashboard /wp-admin2,385 ▲1946.45 ▲0.60131.60 ▲12.0543.10 ▼2.00
Posts /wp-admin/edit.php2,288 ▲1963.35 ▲1.3354.99 ▲19.3936.04 ▲2.92
Add New Post /wp-admin/post-new.php1,547 ▲523.50 ▲5.28638.19 ▲30.0941.61 ▼10.26
Media Library /wp-admin/upload.php1,427 ▲394.25 ▲0.0378.22 ▼30.4143.40 ▼0.19
Next Tiny DB /wp-admin/admin.php?page=ntdb-acp1,0583.0142.8583.28
Settings /wp-admin/admin.php?page=ntdb-acp&tab=ntdb_settings1,0613.0539.8763.97
Databases /wp-admin/admin.php?page=ntdb-acp&tab=ntdb_databases1,0613.0239.3666.46
Help /wp-admin/admin.php?page=ntdb-acp&tab=ntdb_help1,0583.0239.7873.84

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

🔸 Tests weight: 35 | The uninstall procedure must remove all plugin files and extra database tables
The following items require your attention
  • The plugin did not uninstall gracefully
    • > Notice in wp-content/plugins/next-tiny-db/includes/ntdb-functions.php+65
    fgets(): read of 8192 bytes failed with errno=21 Is a directory
  • This plugin does not fully uninstall, leaving 8 options in the database
    • theysaidso_admin_options
    • widget_theysaidso_widget
    • ntdbCurrentType
    • can_compress_scripts
    • widget_recent-comments
    • db_upgraded
    • widget_recent-posts
    • ntdbCurrentVersion

Smoke tests 50% from 4 tests

Server-side errors 0% from 1 test

🔹 Test weight: 20 | This is a short smoke test looking for server-side errors
These server-side errors were triggered
  • 4 occurences, only the last one shown
    • > GET request to /wp-admin/admin.php?page=ntdb-acp&tab=ntdb_help
    • > Notice in wp-content/plugins/next-tiny-db/includes/ntdb-functions.php+65
    fgets(): read of 8192 bytes failed with errno=21 Is a directory
  • 4 occurences, only the last one shown
    • > GET request to /wp-admin/admin.php?page=ntdb-acp&tab=ntdb_help
    • > Notice in wp-content/plugins/next-tiny-db/includes/ntdb-acp-page.php+39
    Undefined variable: PathBD
  • 4 occurences, only the last one shown
    • > GET request to /wp-admin/admin.php?page=ntdb-acp&tab=ntdb_help
    • > Notice in wp-content/plugins/next-tiny-db/includes/ntdb-acp-page.php+76
    Undefined variable: NbRows
  • 4 occurences, only the last one shown
    • > GET request to /wp-admin/admin.php?page=ntdb-acp&tab=ntdb_help
    • > Notice in wp-content/plugins/next-tiny-db/includes/ntdb-acp-page.php+299
    Undefined variable: tmpFilePathFound

SRP 50% from 2 tests

🔹 Tests weight: 20 | A shallow check of the single-responsibility principle; PHP files should perform no action - including output of placeholder text - and trigger no errors when accessed directly
The following issues need your attention
  • 3× PHP files trigger server errors when accessed directly:
    • > PHP Fatal error
      Uncaught Error: Call to undefined function get_option() in wp-content/plugins/next-tiny-db/includes/ntdb-acp-page.php:2
    • > PHP Fatal error
      Uncaught Error: Call to undefined function plugin_dir_path() in wp-content/plugins/next-tiny-db/next-tiny-db.php:17
    • > PHP Fatal error
      Uncaught Error: Call to undefined function wp_upload_dir() in wp-content/plugins/next-tiny-db/includes/ntdb-functions.php:21

User-side errors Passed 1 test

🔹 Test weight: 20 | This is a smoke test targeting browser errors/issues
No browser issues were found

Optimizations

Plugin configuration 96% from 29 tests

readme.txt Passed 16 tests

The readme.txt file is undoubtedly the most important file in your plugin, preparing it for public listing on WordPress.org
5 plugin tags: database, csv, excel, db, spreadsheet

next-tiny-db/next-tiny-db.php 92% from 13 tests

The primary PHP file in "Next Tiny DB" version 2.2.1 is used by WordPress to initiate all plugin functionality
The following require your attention:
  • Description: Please don't use more than 140 characters for the plugin description (currently 528 characters long)

Code Analysis Passed 3 tests

File types Passed 1 test

🔸 Test weight: 35 | There should be no dangerous file extensions present in any WordPress plugin
Everything looks great! No dangerous files found in this plugin1,140 lines of code in 7 files:
LanguageFilesBlank linesComment linesLines of code
PHP411714850
PO File1241402193
CSS14370
JavaScript15127

PHP code Passed 2 tests

An short overview of logical lines of code, cyclomatic complexity, and other code metrics
This plugin has no cyclomatic complexity issues
Cyclomatic complexity
Average complexity per logical line of code0.28
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%
Functions12
▷ Named functions12100.00%
▷ Anonymous functions00.00%
Constants6
▷ Global constants6100.00%
▷ Class constants00.00%
▷ Public constants00.00%

Plugin size Passed 2 tests

Image compression Passed 2 tests

Often times overlooked, PNG files can occupy unnecessary space in your plugin
There were not PNG files found in your plugin