sqlite3 1.11.2 copy "sqlite3: ^1.11.2" to clipboard
sqlite3: ^1.11.2 copied to clipboard

Provides lightweight yet convenient bindings to SQLite by using dart:ffi

140/ 160
pub points
746k
downloads

We analyzed this package 3 days 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: MIT.

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

322 out of 368 API elements (87.5 %) have documentation comments.

Some symbols that are missing documentation: open.OperatingSystem, sqlite3.Database.Database.new, sqlite3.PreparedStatement.PreparedStatement.new, sqlite3.Sqlite3.Sqlite3.new, sqlite3.common.CommmonSqlite3.

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 not compatible with platform Web

Because:

  • package:sqlite3/sqlite3.dart that imports:
  • package:sqlite3/src/ffi/api.dart that imports:
  • package:sqlite3/src/ffi/implementation.dart that imports:
  • package:sqlite3/src/ffi/sqlite3.g.dart that imports:
  • dart:ffi

Failed check 0/0 points: WASM compatibility

Package not compatible with runtime wasm

Because:

  • package:sqlite3/sqlite3.dart that imports:
  • package:sqlite3/src/ffi/api.dart that imports:
  • package:sqlite3/src/ffi/implementation.dart that imports:
  • package:sqlite3/src/ffi/sqlite3.g.dart that imports:
  • dart:ffi

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

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

Partially passed report section
Pass static analysis
40 / 50trigger folding of the section

Partially passed check 40/50 points: code has no errors, warnings, lints, or formatting issues

Found 9 issues. Showing the first 2:

INFO: 'elementAt' is deprecated and shouldn't be used. Use operator + instead.

lib/src/ffi/bindings.dart:302:13

    ╷
302 │         sql.elementAt(byteOffset).cast(),
    │             ^^^^^^^^^
    ╵

To reproduce make sure you are using the lints_core and run dart analyze lib/src/ffi/bindings.dart

INFO: 'elementAt' is deprecated and shouldn't be used. Use operator + instead.

lib/src/ffi/bindings.dart:317:13

    ╷
317 │         sql.elementAt(byteOffset).cast(),
    │             ^^^^^^^^^
    ╵

To reproduce make sure you are using the lints_core and run dart analyze lib/src/ffi/bindings.dart

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

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

Package Constraint Compatible Latest Notes
collection ^1.15.0 1.19.1 1.19.1
ffi >=1.2.1 <3.0.0 2.1.4 2.1.4
js ^0.6.4 0.6.7 0.7.2 Discontinued
meta ^1.3.0 1.17.0 1.17.0
path ^1.8.0 1.9.1 1.9.1

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

The constraint `^0.6.4` on js does not support the stable version `0.7.0`.

Try running dart pub upgrade --major-versions js to update the constraint.

The package has one or more discontinued direct dependencies.

Discontinued packages are no longer maintained, and can end up being a liability.

Consider migrating away from these dependencies:

  • js.

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.22.23, Dart 3.9.3.

Check the analysis log for details.

Weekly downloads

Display as:
By versions:
414
likes
140
points
746k
downloads

Publisher

verified publishersimonbinder.eu

Weekly Downloads

Provides lightweight yet convenient bindings to SQLite by using dart:ffi

Repository (GitHub)
View/report issues

Topics

#sql #database #ffi

Documentation

API reference

License

MIT (license)

Dependencies

collection, ffi, js, meta, path

More

Packages that depend on sqlite3