sqlite_handler 2.0.0 copy "sqlite_handler: ^2.0.0" to clipboard
sqlite_handler: ^2.0.0 copied to clipboard

A modern, lightweight and feature-rich SQLite database handler for Flutter with support for migrations, encryption, and advanced query building.

140/ 160
pub points
42
downloads

We analyzed this package 34 hours ago, and awarded it 140 pub points (of a possible 160):

Passed report section
Follow Dart file conventions
30 / 30trigger folding of the section

Passed check 10/10 points: Provide a valid pubspec.yaml

Passed check 5/5 points: Provide a valid README.md

Passed check 5/5 points: Provide a valid CHANGELOG.md

Passed check 10/10 points: Use an OSI-approved license

Detected license: BSD-3-Clause.

Passed report section
Provide documentation
20 / 20trigger folding of the section

Passed check 10/10 points: 20% or more of the public API has dartdoc comments

175 out of 215 API elements (81.4 %) have documentation comments.

Some symbols that are missing documentation: database_helper, database_helper.DBHelper.DBHelper.new, database_helper.DBHelper.fromMap, database_helper.DBHelper.table, database_helper.DatabaseException.DatabaseException.new.

Passed check 10/10 points: Package has an example

Failed report section
Platform support
20 / 20trigger folding of the section

Passed check 20/20 points: Supports 6 of 6 possible platforms (iOS, Android, Web, Windows, macOS, Linux)

  • ✓ Android

  • ✓ iOS

  • ✓ Windows

  • ✓ Linux

  • ✓ macOS

  • ✓ Web

These issues are present but do not affect the score, because they may not originate in your package:

Package does not support platform `Windows`.

Because:

  • package:sqlite_handler/database/database_helper.dart that imports:
  • package:sqflite/sqflite.dart that declares support for platforms: Android, iOS, macOS.
Package does not support platform `Linux`.

Because:

  • package:sqlite_handler/database/database_helper.dart that imports:
  • package:sqflite/sqflite.dart that declares support for platforms: Android, iOS, macOS.
Package does not support platform `Web`.

Because:

  • package:sqlite_handler/database/database_helper.dart that imports:
  • package:sqflite/sqflite.dart that declares support for platforms: Android, iOS, macOS.

Passed check 0/0 points: WASM compatibility

This package is compatible with runtime wasm, and will be rewarded additional points in a future version of the scoring model.

See https://dart.cn/web/wasm for details.

Failed check 0/0 points: Swift Package Manager support

Package does not support the Swift Package Manager on macOS

It does not contain macos/sqlite_handler/Package.swift.

This package for iOS or macOS does not support the Swift Package Manager. It will not receive full points in a future version of the scoring model.

See https://docs.flutter.dev/to/spm for details.

Failed report section
Pass static analysis
30 / 50trigger folding of the section

Failed check 30/50 points: code has no errors, warnings, lints, or formatting issues

Found 34 issues. Showing the first 2:

WARNING: Unused import: '../core/extensions/enumations.dart'.

lib/database/database_helper.dart:5:8

  ╷
5 │ import '../core/extensions/enumations.dart';
  │        ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  ╵

To reproduce make sure you are using the lints_core and run flutter analyze lib/database/database_helper.dart

WARNING: The value of the field '_query' isn't used.

lib/database/database_helper.dart:10:10

   ╷
10 │   String _query = "";
   │          ^^^^^^
   ╵

To reproduce make sure you are using the lints_core and run flutter analyze lib/database/database_helper.dart

Passed report section
Support up-to-date dependencies
40 / 40trigger folding of the section

Passed check 10/10 points: All of the package dependencies are supported in the latest version

Package Constraint Compatible Latest Notes
crypto ^3.0.6 3.0.7 3.0.7
path ^1.9.1 1.9.1 1.9.1
plugin_platform_interface ^2.1.8 2.1.8 2.1.8
sqflite ^2.4.2 2.4.2 2.4.2
Transitive dependencies
Package Constraint Compatible Latest Notes
characters - 1.4.0 1.4.1
collection - 1.19.1 1.19.1
material_color_utilities - 0.11.1 0.13.0
meta - 1.17.0 1.17.0
platform - 3.1.6 3.1.6
sqflite_android - 2.4.2+2 2.4.2+2
sqflite_common - 2.5.6 2.5.6
sqflite_darwin - 2.4.2 2.4.2
sqflite_platform_interface - 2.4.0 2.4.0
synchronized - 3.4.0 3.4.0
typed_data - 1.4.0 1.4.0
vector_math - 2.2.0 2.2.0

To reproduce run dart pub outdated --no-dev-dependencies --up-to-date --no-dependency-overrides.

Passed check 10/10 points: Package supports latest stable Dart and Flutter SDKs

Passed check 20/20 points: Compatible with dependency constraint lower bounds

pub downgrade does not expose any static analysis error.

Analyzed with Pana 0.23.1, Flutter 3.38.0, Dart 3.10.0-290.4.beta.

Check the analysis log for details.

Weekly downloads

Display as:
By versions:
3
likes
140
points
42
downloads

Publisher

verified publishermabdulmonem.com

Weekly Downloads

A modern, lightweight and feature-rich SQLite database handler for Flutter with support for migrations, encryption, and advanced query building.

Repository (GitHub)
View/report issues

Documentation

API reference

License

BSD-3-Clause (license)

Dependencies

crypto, flutter, flutter_web_plugins, path, plugin_platform_interface, sqflite

More

Packages that depend on sqlite_handler

Packages that implement sqlite_handler