sqlite_plus_orm 0.1.6

Typed queries, JSON documents, search, vectors, and migrations for sqlite_plus.

Changelog

0.1.6

Depends on sqlite_plus 0.1.6. pub.dev already serves 0.1.5.

• @DbDocument(), the module constants, search, and nearest in the notes below are in this upload.
• DbSet.openMemory opens a memory database, creates that table, and returns the set. DbSet.openDbFile does the same for a file. A missing file and a missing -journal are created. On the Web openDbFile throws UnsupportedError.

0.1.4

Depends on sqlite_plus 0.1.6. These notes shipped in 0.1.6.

• @DbDocument() stores one object as JSON text. Codecs.document calls fromJson and toJson. row.card.path(r'$.title') binds json_extract. A returned row is decoded. The other rows stay text.
• The model schema records "document": true for that column. The SQL type stays TEXT. A String column still uses @DbJson.
• DbModules, DbTokenizers, and DbVectorMetrics are documented String constants. DbVectorLimits documents 1 and 4096. The annotation fields stay strings, so a missing name can still be written by hand.
• @DbEntity(module:, tokenizer:) creates fts5, rtree, or vec0. An unknown module is rejected. A tokenizer belongs on fts5.
• @DbVector(dimensions) stores List<double> as little-endian float32. The default metric is l2.
• search queries an FTS5 table. nearest writes column MATCH ? AND k = ? and orders by distance.
• sqlite_plus_arabic and sqlite_plus_vec are registered by the application. This package does not import them.

0.1.3

Depends on sqlite_plus 0.1.3. pub.dev already serves 0.1.2.

• @DbScalar() on an instance method or getter reads mapped fields. selectWhere((row) => row.twice() > 20) runs that body for each row. The context registers table_method on the connection.
• A column, a JSON path, or a call accepts the engine scalars: abs, upper, lower, length, trim, substr, replace, round, coalesce, ifNull, concat, sign, floor, ceil, sqrt, date, time, dateTime, unixEpoch, and julianDay.

0.1.2

Depends on sqlite_plus 0.1.2. The page uses the Linux release-build sample and the new logo.

0.1.1

The package page leads with a save, a revision, and a JSON path. Depends on sqlite_plus 0.1.1.

0.1.0

Release number. Depends on sqlite_plus 0.1.0.

0.0.3

Release number. Depends on sqlite_plus 0.0.3.

0.0.2

Published release. Depends on sqlite_plus 0.0.2.

0.0.1-dev.1

First pre-release.

• Typed queries, change tracking, relationships, and reviewed migrations.
• The reading-log example ships with the package.