phorm_sqlite 1.6.0 copy "phorm_sqlite: ^1.6.0" to clipboard
phorm_sqlite: ^1.6.0 copied to clipboard

Published 9 hours ago • verified publisherinterlib.dev• Latest: 1.6.1
SDKFlutter
PlatformAndroidiOSLinuxmacOSWindows
→

Metadata

The SQLite driver and connection manager implementation for the PHORM.

More...

Changelog #

1.6.0 #

  • New: automatic additive migrations — DB(autoMigrate: true) (also on DB.autoVersion). On every open, each registered table's live schema is compared with its generated CREATE TABLE schema; missing tables, columns, indexes and triggers are created automatically — no version bump needed for additive model changes. Destructive or ambiguous changes (dropped/renamed columns, type changes, NOT NULL without a DEFAULT, UNIQUE/ PRIMARY KEY additions) are never applied: they are logged with a suggestion to write an explicit TableMigration. Off by default; explicit migrations keep working alongside and remain the tool for data transforms.
  • Re-enabled most very_good_analysis lints for lib/ (generated *.g.dart files are excluded from analysis). Internal cleanups with no behavior changes: on Object catch clauses, removed unnecessary awaits, single changeStream tear-off subscription.

1.5.1 #

  • Bundled phorm core bumped to ^1.4.1: WhereBuilder now escapes columns structurally via the dialect instead of regex replacement over the generated SQL, fixing mis-escaping when a column name coincided with a word inside the SQL template (e.g. a column named LOWER or DATE) and properly escaping SqlFunctionColumn inner columns.

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).

← Metadata

1
likes
160
points
870
downloads
screenshot

Documentation

API reference

Publisher

verified publisherinterlib.dev

Weekly Downloads

Metadata

The SQLite driver and connection manager implementation for the PHORM.

Homepage
Repository (GitHub)
View/report issues

Topics

#orm #sqlite #database #sql

License

MIT (license)

Dependencies

flutter, meta, path, path_provider, phorm, sqlite3, sqlite3_flutter_libs, sqlite3_web

More

Packages that depend on phorm_sqlite

Back