NewYour coding agent can read the release notes before it upgrades.Set up the MCP server β
pub.dev
pub.dev, #3749 most downloaded on pub.dev
The typesafe, reactive, and lightweight SQLite abstraction for your Flutter applications. This library is the runtime dependency.
Latest stable
8.0.0
Last release 22 days ago
31 Oct 2026
Release timing varies
gaps range from 2 weeks to 8 months
Nearly every release is documented
notes for 13 of 13 stable releases
Nothing withdrawn
no release was ever pulled
1 years old
13 releases Β· first in 2025
Drag across the ruler to compare, or tap a release to open it.
sqlite3: Upgraded to sqflite_common_ffi 2.4, sqflite_common_ffi_web 1.2 and sqlite3 3, which bundle SQLite with the app by hooks and choose the SQLite
sqflite_common_ffi 2.4, sqflite_common_ffi_web 1.2 and sqlite3 3, which bundle SQLite with the app by hooks and choose the SQLite library per platform by the hooks of the pubspec.yaml (bundled, system or encrypted builds) instead of sqlite3_flutter_libs. The bundled builds don't support FTS3 and FTS4, which @Fts3 and @Fts4 entities require, see Platform Supportsource: system for these platforms, see Platform Supportfroom, froom_ffi and the example raised to >=3.12.0, as required by the sqflite packages>=3.10.0, as required by the versions of dart_style supporting analyzer 11^0.45.1 in froom_common and froom_generator, raising the minimum Dart SDK of froom_common to >=3.10.0>=11.0.0 <15.0.0 and build >=4.0.0 <6.0.0, so it works with the latest build_runner, freezed and json_serializable@fts5/@Fts5() entities stored in FTS5 tables, which the SQLite builds bundled by sqlite3 support, with tokenizer, tokenizerArgs, prefixes and notIndexed; their primary key is the rowid, which queries have to select explicitly, as the code generation checksfroom_ffi compile, as getDatabasePath() of their builders moved to froom_commonMissingSqliteModuleException explaining how to fix it when the SQLite library lacks a module like FTS4password() of their builder, using encrypted builds of SQLite like SQLite3MultipleCiphers or SQLCipher; opening fails with a DatabaseEncryptionException for wrong passwords, unencrypted databases and SQLite builds without encryption, and with an ArgumentError for empty passwords, which would store the database unencryptedDatabaseFactory of a database with databaseFactory() of its builder, e.g. the FFI one on Android and iOS instead of the sqflite plugindatabaseFactory not initializedimport 'package:froom/sqflite.dart' as sqflite; instead of depending on sqflitedart:io, so froom compiles for the web@AutoMigration, generated from the schemas exported to froom_schemas (with automatic migrations or @Database(exportSchema: true)), including @RenameTable, @RenameColumn, @DeleteTable and @DeleteColumn specs, AutoMigrationSpec.onPostMigrate and @providedAutoMigrationSpecYour coding agent can read these notes before it upgrades. Set up the MCP server β
migrations: Migrations run with foreign keys disabled, so foreign key actions like ON DELETE CASCADE don't run during migrations; opening the database
ON DELETE CASCADE don't run during migrations; opening the database fails if the migrations add foreign key violations (#178)fallbackToDestructiveMigration()); of several migrations starting at the same version, only the one reaching the highest version runs^11.0.0 for Flutter 3.47 / Dart 3.13>=3.9.0@upsert / @Upsert annotation mirroring Room's @Upsert (#2)
@Upsert(entity: X), only inserting or updating the columns they contain-1 for updated onesvoid use batched native INSERT ... ON CONFLICT DO UPDATE on SQLite 3.24.0 and aboveclearAllTables() to delete all rows of all entity tables, like Room (#163)@ColumnInfo(defaultValue: ...) for SQL default values of columns, like Room (#165)fallbackToDestructiveMigration() to the database builder and Callback.onDestructiveMigration, recreating the database when there is no migration, like Room (#167)Index.where for partial indices (#172)null as NULL (#174)0 of a non-nullable auto generated int primary key is treated as unset when inserting (#177)TypeConverter or extend it indirectly (#182)lower(email) (#194)// ignore_for_file: type=lint (#162)INSERT, UPDATE and DELETE statements of @Query methods update streams declared in other DAOs too (#169)NULL (#173)(a, b) > (:list), including List<Object> (#180)@transaction on query and change methods no longer generates them twice (#185)IF NOT EXISTS like tables (#187)@transaction methods with nullable return values generate compiling code (#188)@Entity(primaryKeys: ...) that don't exist instead of ignoring them (#189)double values are read correctly when SQLite returns integers, e.g. for COALESCE(SUM(x), 0) (#191)databaseBuilder() for a custom database location (#179)@Fts3/@Fts4 entities (#190)ci: Updated CI Docker image from dart:3.7.2 to dart:3.9.0
^10.0.0dart:3.7.2 to dart:3.9.0FieldElement API stubs for analyzer 10.x compatibility (declaringFormalParameter, isOriginDeclaration, isOriginDeclaringFormalParameter, isOriginEnumValues, isOriginExtensionTypeRecoveryRepresentation, isOriginGetterSetter)froom_generator: Updated fakes for analyzer 9.x API compatibility (isDeprecatedWithKind)
isDeprecatedWithKind)>=3.9.0queryableName (#161)froom_generator: Migrated from analyzer element2 API to element API for improved compatibility
dependencies: Remove unnecessary Flutter and flutter_test dependencies from pubspec.yaml
platform_detection: Replace kIsWeb with custom _kIsWeb for better platform detection in sqflite database factory
type_utils: Use TypeChecker.typeNamed instead of deprecated fromRuntime for improved compatibility
### Changes * Update README.md
### Fix * Fix froom_common meta version ### Changes * Update readme.md
### Changes * add publish-kit
π docs(README): update install instructions and dependency versions in README and README_zh π docs(CHANGELOG): add 2.0.1 entry for froom_common packag
π docs(README): update install instructions and dependency versions in README and README_zh
π docs(CHANGELOG): add 2.0.1 entry for froom_common package release
π docs(publishing): add package publish order
β¬οΈ deps(pubspec): update meta dependency to ^1.16.0 in froom
Initial release of froom_common package
One column per month.