Skip to main content

json_sqlite 0.0.6 copy "json_sqlite: ^0.0.6" to clipboard
json_sqlite: ^0.0.6 copied to clipboard

A JSON-oriented Dart interface to SQLite, with indexes and full-text search.

0.0.6 20261102 #

  • Added an example for the simplest use case.
  • Unary minus in Sql now avoids the possible generation of a comment.
  • Scheme and SchemeElements were decoupled from SQLite; they can now be reused in multiple SQLite instances.
  • Fixed pagination for multiple column ordering and added a basic test.
  • Fixed a situation where a custom where can disrupt Query logic.
  • The SQLite API is now guarded against the "failed" status.
  • Added integrity validators for Scheme and its elements.
  • ftsTerm and ftsText now normalize the input to NFC.
  • Allowed Kinds and keyids are now explicitly limited to strings and finite numbers.
  • Changing the kind of a row is now explicitly prohibited.
  • Fixed the Query seek condition to consistently avoid NULLs.
  • The FTS tokenizer can now be configured on a per-index basis.
  • The Scheme description tracking is now almost fully automatic; the exception is the SearchIndex.getters callbacks.
  • The mapping table is now configured for durable rowids.
  • Other fixes and enhancements.

0.0.5 20261004 #

  • The simplest use case that does not require processing Kinds was made possible.
  • It is now easier to use JSON values in a composite format; this is based on the Composite record and related helpers.
  • SearchQueryConverter now accepts hyphenated barewords for column names.
  • SearchQueryConverter now has a run method, which should be used instead of calling the build method directly.
  • When used via its run method, SearchQueryConverter now yields more relevant and user-friendly error messages for incorrect queries.
  • Negative distances for NEAR clauses are now rejected by SearchQueryConverter.
  • Dependency update: sqlite3 >= 3.5.0.

0.0.4 20260913 #

  • Dependencies were constrained to minimum required versions.
  • Added documentation for json_sqlite/lib/src/*.dart files.
  • Updated sqlLiteral to better support SQLite literals.
  • Changed DatabaseUpgrader to a mixin.
  • Extended FTS tokens now include P and S categories.
  • SqlExpression was renamed to Sql.
  • Updated Transaction and SQLite.apply to accumulate and write edits without reordering.
  • Updated PagedResultIterator to signal inability to advance after the last and before the first elements.
  • Updates to the SearchQueryConverter parser:
    • Hyphens within barewords are now accepted.
    • Valid bareword characters were changed: for non-ASCII Unicode BMP characters, only letters and numbers are allowed now.
    • A restriction on column filters was removed: column filters can now be used with boolean operators.
    • Wrong associativity was fixed for NOT: right associativity is incorrect for NOT; all boolean operators were made left-associative.
    • Compounds can now start with a keyword: compound barewords are now allowed to begin with "AND-", "OR-", "NOT-", and "NEAR-" (e.g., as in the "AND-OR gate" query).
    • More selective trimming is used now: visually misleading queries like "aa" *bb- cc :dd are now rejected.
    • Column negation was fixed: negation now takes into account predefined columns.
  • Other fixes.

0.0.3 20260423 #

  • Added a basic test.
  • Added the ability to create an in-memory database (SQLite.inMemory).

0.0.2 20260305 #

  • Added files to lib.
  • Dependency update: Dart SDK >= 3.10.
  • Added dartdoc_options.yaml.

0.0.1 20250919 #

  • Initial version.
1
likes
150
points
713
downloads

Documentation

API reference

Publisher

verified publisherfoodchaining.dev

Weekly Downloads

A JSON-oriented Dart interface to SQLite, with indexes and full-text search.

Repository (GitHub)
View/report issues

Topics

#database #sqlite #nosql #key-value #full-text-search

License

BSD-3-Clause (license)

Dependencies

auxiliary, characters, collection, convert, dartz, equatable, intl, logging, meta, petitparser, quiver, sqlite3, unorm_dart

More

Packages that depend on json_sqlite