# sqflite_common 2.5.14

Dart wrapper on SQLite, a self-contained, high-reliability, embedded, SQL database engine.




## Installing
```
export PUB_HOSTED_URL=https://pub.mirror.p-hatan.ir
flutter pub add sqflite_common
```
Published: 2026-10-13T17:27:53.603640Z
Expected archive SHA-256: b80e94ff0d551d5f1f8c7d14348d29b576cca3ae30f6e195a7c380552c32b1e0

Available in cache; verification: upstream_checksum
## Direct dependencies
- meta: >=1.14.0 <3.0.0
- path: >=1.8.0 <3.0.0
- synchronized: >=3.4.1 <5.0.0

## Package README (untrusted upstream documentation)
# sqflite common

This package is not intended for direct use.
* See [sqflite](https://pub.dev/packages/sqflite) for flutter mobile
* See [sqflite_common_ffi](https://pub.dev/packages/sqflite_common_ffi) for Desktop
and unit test

One exception to import `sqflite_common/sqlite_api.dart` is that you have logic
which is shared across Flutter apps and desktop binaries, and you want to make
your shared logic platform-agnostic. In this case, you can import the
`sqflite_common/sqlite_api.dart` directly in your Dart package for shared logic
and import it in your platform-dependent packages (e.g. using
[sqflite](https://pub.dev/packages/sqflite) for Flutter apps and
[sqflite_common_ffi](https://pub.dev/packages/sqflite_common_ffi) for desktop
binaries).

## Changelog
## 2.5.14

* Fix hang when closing a query cursor before its end inside a transaction
  (`sqflite_common_ffi`, Android)
* `Batch.apply()` on a closed database fails with a `database_closed` error, like
  `Batch.commit()`
* Debug argument check (once per type warning) also done for `rawInsert` (and `insert`)
  and the batch raw methods, like `rawQuery`, `rawUpdate` and `rawDelete`

## 2.5.13+1

* Fix web detection (`kSqfliteIsWeb`) when compiled with dart2wasm: database paths were
  rewritten as absolute urls, which broke `databaseExists`, `deleteDatabase`,
  `readDatabaseBytes` and `writeDatabaseBytes` in `sqflite_common_ffi_web`
* Allow general read access to `databaseFactoryOrNull`.

## 2.5.12

* Add `sqflite-common-api` agent skill in `skills/`, installable with `dart run skills@ get`

## 2.5.11

* Add `sandbox()` extension method on `DatabaseFactory` to create a factory
  where every database is located below a root path

## 2.5.10+1

* Add `options` to `openDatabase`

## 2.5.9

* Requires dart 3.12

## 2.5.8

* Add `rollbackActiveTransactionOnOpen` open options for native implementation when using singleInstance.
  in release mode by default it will no more rollback active transactions on opening the DB

## 2.5.7

* Add `iterate` method and export `SqfliteSqlCommand` and extension helpers

## 2.5.6+1

* Requires dart 3.10

## 2.5.6

* Add `Database.setJournalMode` extension helper method.
* Requires dart 3.8

## 2.5.5

* Requires dart 3.7

## 2.5.4+6

* Remove dependency on `dart:html`
* Add more keywords to escape from sqlite.org
* Export deprecated `SqfliteOptions` in sqflite_dev

## 2.5.3

* Export `databaseId` and `transactionId` in logger events.

## 2.5.2-1

* Start support for rolled back transaction by an inner statement.

## 2.5.1-2

* Add `readTransaction` support to `Database` to allow concurrent read-only transactions (sqlite_async only)
 
## 2.5.0+2

* Dart 3 only
* Add `readDatabaseBytes` and `writeDatabaseBytes` factory methods.

## 2.4.5+1

* Add global API from sqflite (openDatabase, deleteDatabase, databaseFactory...) from sqflite
* Fixes SqlBuilder for query with offset without limit.

## 2.4.4

* Dart 3 support

## 2.4.3

* add minimum support for SQLite uri (https://www.sqlite.org/uri.html)

## 2.4.2+2

* add experimental logger support.

## 2.4.1

* add support for `Batch.length` to help finding the last added operation index.
* strict-casts and sdk 2.18 support

## 2.4.0+2

* add support for `Database.queryCursor()` and `Database.rawQueryCursor()`
* base experimental web support
* Support for transaction v2

## 2.3.0

- Add `apply()` method to `Batch`. It will execute statements in that batch
  without starting a new transaction.

## 2.2.1+1

* Add debug tag to database factory

## 2.2.0

* Export `Object? result` in `DatabaseException`
* Export deprecated `DatabaseFactory.debugSetLogLevel` for quick logging.

## 2.1.0

* Requires dart sdk 2.15

## 2.0.1+1

* Truncate arguments in exception

## 2.0.0+2

* `nnbd` support
* Fix transaction ref counting on begin transaction failure

## 1.0.3+2

* Don't lock globally during open but lock per database full path.
 
## 1.0.2+1

* Don't create a transaction during openDatabase if not needed.

## 1.0.1

* Export `DatabaseException.getResultCode()`.

## 1.0.0+1

* Initial revision from sqflite 1.2.2+1