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

130/ 160
pub points
1.34M
downloads

We analyzed this package 21 hours ago, and awarded it 130 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

319 out of 365 API elements (87.4 %) have documentation comments.

Some symbols that are missing documentation: open.OperatingSystem, sqlite3.Database.Database.new, sqlite3.PreparedStatement.PreparedStatement.new, sqlite3.SQLITE_DELETE, sqlite3.SQLITE_INSERT.

Passed check 10/10 points: Package has an example

Partially passed report section
Platform support
10 / 20trigger folding of the section

Partially passed check 10/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

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

Note: This package supports Web but is not WASM-compatible, resulting in a partial score. See https://dart.dev/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.2.0 2.2.0
js ^0.6.4 0.6.7 0.7.2 Discontinued
meta ^1.3.0 1.18.3 1.18.3
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.23.12, Dart 3.12.0.

Check the analysis log for details.

Weekly downloads

Display as:
By versions:
451
likes
130
points
1.34M
downloads

Documentation

API reference

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

License

MIT (license)

Dependencies

collection, ffi, js, meta, path

More

Packages that depend on sqlite3