Pub Version Pub Publisher

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

This library reinterprets SQLite as a document store. Documents are stored and retrieved in a schema-less JSON format. Retrieval of JSON data is performed via primary keys, secondary indexes, or full-text search (FTS) queries. Seek-based pagination is available for large result sets. The library does not constrain the inner layout of any JSON data. The choice of which inner elements of the JSON data to index and which to expose for FTS is defined by the application. Creation and migration of the underlying SQLite schema are managed automatically.

Libraries

expr
This package library contains helpers to compose SQL and FTS constructs.
sqlite
This package library exports the core of the json_sqlite package.
uifts
This package library translates a UI-typed search query into an FTS query.