Viewing version 2.5.14. Open the latest package page.
sqflite_common
2.5.14Dart wrapper on SQLite, a self-contained, high-reliability, embedded, SQL database engine.
Readme
sqflite common
This package is not intended for direct use.
- See sqflite for flutter mobile
- See 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 for Flutter apps and
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 adatabase_closederror, likeBatch.commit()- Debug argument check (once per type warning) also done for
rawInsert(andinsert) and the batch raw methods, likerawQuery,rawUpdateandrawDelete
2.5.13+1
- Fix web detection (
kSqfliteIsWeb) when compiled with dart2wasm: database paths were rewritten as absolute urls, which brokedatabaseExists,deleteDatabase,readDatabaseBytesandwriteDatabaseBytesinsqflite_common_ffi_web - Allow general read access to
databaseFactoryOrNull.
2.5.12
- Add
sqflite-common-apiagent skill inskills/, installable withdart run skills@ get
2.5.11
- Add
sandbox()extension method onDatabaseFactoryto create a factory where every database is located below a root path
2.5.10+1
- Add
optionstoopenDatabase
2.5.9
- Requires dart 3.12
2.5.8
- Add
rollbackActiveTransactionOnOpenopen 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
iteratemethod and exportSqfliteSqlCommandand extension helpers
2.5.6+1
- Requires dart 3.10
2.5.6
- Add
Database.setJournalModeextension 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
SqfliteOptionsin sqflite_dev
2.5.3
- Export
databaseIdandtransactionIdin logger events.
2.5.2-1
- Start support for rolled back transaction by an inner statement.
2.5.1-2
- Add
readTransactionsupport toDatabaseto allow concurrent read-only transactions (sqlite_async only)
2.5.0+2
- Dart 3 only
- Add
readDatabaseBytesandwriteDatabaseBytesfactory 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.lengthto help finding the last added operation index. - strict-casts and sdk 2.18 support
2.4.0+2
- add support for
Database.queryCursor()andDatabase.rawQueryCursor() - base experimental web support
- Support for transaction v2
2.3.0
- Add
apply()method toBatch. 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? resultinDatabaseException - Export deprecated
DatabaseFactory.debugSetLogLevelfor quick logging.
2.1.0
- Requires dart sdk 2.15
2.0.1+1
- Truncate arguments in exception
2.0.0+2
nnbdsupport- 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
Installing
export PUB_HOSTED_URL=https://pub.mirror.p-hatan.ir
flutter pub add 'sqflite_common:2.5.14'pubspec.yaml
name: sqflite_common
homepage: https://github.com/tekartik/sqflite/tree/master/sqflite_common
description: Dart wrapper on SQLite, a self-contained, high-reliability, embedded, SQL database engine.
version: 2.5.14
funding:
- https://github.com/sponsors/alextekartik
environment:
sdk: ^3.12.0
dependencies:
synchronized: ">=3.4.1 <5.0.0"
path: ">=1.8.0 <3.0.0"
meta: ">=1.14.0 <3.0.0"
dev_dependencies:
lints: ">=4.0.0"
process_run: ">=1.1.0"
http: ">=1.2.2"
test: ">=1.25.8"
test_api: ">=0.7.3"
pub_semver: ">=2.1.4"
Version history
| Version | Published | Archive | SHA-256 |
|---|---|---|---|
| 0.1.0-dev.1 | On demand | Download | f931ce84…efb2e5 |
| 0.1.0-dev.2 | On demand | Download | 468b4b9f…b11223 |
| 0.1.0-dev.3 | On demand | Download | 47b32058…ffd16d |
| 1.0.0 | On demand | Download | 11639104…4803ff |
| 1.0.0+1 | On demand | Download | fed2b61b…98b15c |
| 1.0.1-dev.1 | On demand | Download | e80a846e…118ce5 |
| 1.0.1-dev.2 | On demand | Download | 0f2d4d55…3c9909 |
| 1.0.1 | On demand | Download | 33f26b03…e61302 |
| 1.0.2 | On demand | Download | e2a4d5d1…e63c69 |
| 1.0.2+1 | On demand | Download | 7c821874…ec4150 |
| 1.0.3-dev.1 | On demand | Download | 8575cfc4…6b3cb7 |
| 1.0.3 | On demand | Download | 6d253403…263d2f |
| 1.0.3+1 | On demand | Download | 31dac537…c5e983 |
| 1.0.3+2 | On demand | Download | 07eb73a0…d8d986 |
| 1.0.3+3 | On demand | Download | cd2c3caf…7a791f |
| 2.0.0-nullsafety.0 | On demand | Download | 86a08556…8c0257 |
| 2.0.0-nullsafety.1 | On demand | Download | 445a11d1…9f0897 |
| 2.0.0-nullsafety.2 | On demand | Download | 78fc5a91…77812d |
| 2.0.0 | On demand | Download | 565175fe…1fe97c |
| 2.0.0+1 | On demand | Download | 36ea1763…70c1dd |
| 2.0.0+2 | On demand | Download | b229e2c7…ee37b9 |
| 2.0.1 | On demand | Download | 69a85df4…c64c3b |
| 2.0.1+1 | On demand | Download | 75e99c23…04d9bd |
| 2.1.0 | On demand | Download | fcc6389e…723bd9 |
| 2.2.0 | On demand | Download | c65f0031…cbea0a |
| 2.2.1 | On demand | Download | 726bb7ae…d8ba4e |
| 2.2.1+1 | On demand | Download | b504fc5b…538275 |
| 2.3.0 | On demand | Download | 0c7785be…3d54a7 |
| 2.4.0-dev.0 | On demand | Download | 70f5b87b…6aeb62 |
| 2.4.0-dev.1 | On demand | Download | 4e83d1b4…9e0478 |
| 2.4.0-dev.2 | On demand | Download | fc70953e…8ea691 |
| 2.4.0-dev.3 | On demand | Download | 0fedeb30…2f5ace |
| 2.4.0-dev.4 | On demand | Download | bb7d08a5…b0407f |
| 2.4.0-dev.5 | On demand | Download | 8a94ad33…cc4ec2 |
| 2.4.0-dev.6 | On demand | Download | 0b97e65b…14d10a |
| 2.4.0-dev.7 | On demand | Download | de37641b…e6de1c |
| 2.4.0 | On demand | Download | 4aa3b917…895276 |
| 2.4.0+2 | On demand | Download | 0c21a187…7067ab |
| 2.4.1-1 | On demand | Download | 97d92475…dd1f30 |
| 2.4.1 | On demand | Download | b2ed22d1…4b5ccd |
| 2.4.2-dev.1 | On demand | Download | 9449ce5b…c63958 |
| 2.4.2 | On demand | Download | f09c65d0…5d5f25 |
| 2.4.2+1 | On demand | Download | 5a3c29df…3c7786 |
| 2.4.2+2 | On demand | Download | bfd6973a…c5183f |
| 2.4.3-1 | On demand | Download | 88ebca9a…97300a |
| 2.4.3 | On demand | Download | 963dad8c…6bc684 |
| 2.4.4 | On demand | Download | 220831bf…6e282c |
| 2.4.5-1 | On demand | Download | a3027b1e…7000c8 |
| 2.4.5-2 | On demand | Download | ffe7c468…4e0a3b |
| 2.4.5-3 | On demand | Download | 6c65385b…3ecf21 |
| 2.4.5 | On demand | Download | e77abf6f…401555 |
| 2.4.5+1 | On demand | Download | 8f7603f3…b65b8f |
| 2.5.0-1 | On demand | Download | 9915ccdd…3d1242 |
| 2.5.0 | On demand | Download | 1b92f368…55660a |
| 2.5.0+1 | On demand | Download | 8ed04410…320803 |
| 2.5.0+2 | On demand | Download | bb4738f1…8a54a6 |
| 2.5.1-1 | On demand | Download | f3a42dd2…50bd2f |
| 2.5.1-2 | On demand | Download | 07483102…489c18 |
| 2.5.2-1 | On demand | Download | 76db4d32…b69f14 |
| 2.5.3 | On demand | Download | 28d8c66b…ec72d5 |
| 2.5.4 | On demand | Download | 3da423ce…1f16a4 |
| 2.5.4+1 | On demand | Download | c5e5b2a1…bc53c2 |
| 2.5.4+2 | On demand | Download | 7b41b6c3…55453e |
| 2.5.4+3 | On demand | Download | 4058172e…131611 |
| 2.5.4+4 | On demand | Download | 2d8e607d…71b1a4 |
| 2.5.4+5 | On demand | Download | 4468b248…0e5490 |
| 2.5.4+6 | On demand | Download | 761b9740…68f709 |
| 2.5.5 | On demand | Download | 84731e8b…ddbe8b |
| 2.5.6 | On demand | Download | 6ef422a4…ae16a6 |
| 2.5.6+1 | On demand | Download | 5e837756…9112c3 |
| 2.5.7-1 | On demand | Download | 4c4393f7…fb90e2 |
| 2.5.7-2 | On demand | Download | 6ba7abad…25aedf |
| 2.5.7-3 | On demand | Download | 8ade3837…3f0901 |
| 2.5.7 | On demand | Download | f8a08a13…875c21 |
| 2.5.8-1 | On demand | Download | c51b3b74…fd24e0 |
| 2.5.8 | On demand | Download | 1581ffbf…78b465 |
| 2.5.9 | On demand | Download | cce55807…00b014 |
| 2.5.10 | On demand | Download | 7694cb62…f7c7ef |
| 2.5.10+1 | On demand | Download | 6e9bb47c…1daece |
| 2.5.11 | On demand | Download | 5bf6a55c…624590 |
| 2.5.12 | On demand | Download | b3ebf7b3…2346d9 |
| 2.5.13 | On demand | Download | 077e38e8…6a1ea0 |
| 2.5.13+1 | On demand | Download | da542ae3…5e6629 |
| 2.5.14 | Cached · Upstream SHA-256 matched | Download | b80e94ff…32b1e0 |
Dependencies
meta "\u003e=1.14.0 \u003c3.0.0"
path "\u003e=1.8.0 \u003c3.0.0"
synchronized "\u003e=3.4.1 \u003c5.0.0"