phorm_sqlite 1.5.0

The SQLite driver and connection manager implementation for the PHORM.

Changelog

1.5.0

• BREAKING: bundled phorm core bumped to ^1.4.0 — automatic timestamps (created_at, updated_at, deleted_at) are now written in UTC instead of local time. New records sort consistently across devices/timezones; rows written by earlier versions keep their local-time values.
• Migration applied_at timestamps are now written in UTC as well.

1.4.1

• Raise the default DB.isolateThreshold from 50 to 2000. Result-set parsing only moves to a background isolate once inline parsing would risk a dropped frame; below that the isolate spawn + row copy was pure overhead. See benchmark/parse_benchmark.dart in the phorm package for the measurements.
• Document the isolateThreshold tuning knob in the README.

1.4.0

• Upgrade to sqlite3 ^3.3.4, sqlite3_flutter_libs ^0.6.0 and sqlite3_web ^0.9.2. Migrate the isolate backends off the deprecated dispose() in favor of close(). Raises the Dart SDK floor to >=3.10.0 (required by sqlite3_web 0.9).
• Add topics to pubspec.yaml for pub.dev discoverability.
• Note: the phorm_generator dev-dependency is temporarily pinned to <1.4.0, as generator 1.4.0 pulls analyzer 13 (meta ^1.18.3) which conflicts with the meta version pinned by the current Flutter SDK.

1.3.0

• Auto-generated pivot tables (from @ManyToMany(createPivot: true)) are now created on database upgrade as well, not only on first creation: any IF NOT EXISTS-guarded statement in a table's schema is re-applied when the owning table already exists.
• Added an informational log line when a pivot table is created alongside its model table (e.g. Also creating pivot table: user_roles).

1.2.0

• Bumped phorm dependency to ^1.2.0 (and phorm_generator dev dependency to ^1.2.0), exposing the new @Schema(generateFullService: ...) option.
• Bumped sqlite3_web to ^0.4.1.

1.1.0

• Bumped phorm dependency to ^1.1.0 and phorm_generator (dev) to ^1.1.0.
• Version bump to keep all PHORM packages in sync.

1.0.3

• Version bump to keep all PHORM packages in sync.

1.0.2

• Updated SDK environment constraint to >=3.7.0 <4.0.0

1.0.1

• Updated README with badges
• Removed commented workspace resolution configuration

1.0.0

• First stable release of the PHORM SQLite Driver.
• Implements phorm runtime database execution layer on top of sqlite3.
• Dedicated multi-thread background isolate executor ensuring synchronous SQLite operations never block the main/UI thread.
• Out-of-the-box Flutter Web support via WebAssembly (sqlite3_web) and persistent IndexedDB file system.
• Transparent database versioning and smart idempotent migration lifecycle tracking via the __phorm_migrations table.
• High-performance slow query tracer and console loggers.
• Built-in SQLCipher encryption support for Native (iOS, Android, Desktop) platforms.
• Native Dart SqlFunction registration (including regexp support).