sqflite_common

2.5.14

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

Download archive

Readme

sqflite common

This package is not intended for direct use.

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

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

Installing

export PUB_HOSTED_URL=https://pub.mirror.p-hatan.com
flutter pub add sqflite_common
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

VersionPublishedArchiveSHA-256
0.1.0-dev.1On demandDownloadf931ce84…efb2e5
0.1.0-dev.2On demandDownload468b4b9f…b11223
0.1.0-dev.3On demandDownload47b32058…ffd16d
1.0.0On demandDownload11639104…4803ff
1.0.0+1On demandDownloadfed2b61b…98b15c
1.0.1-dev.1On demandDownloade80a846e…118ce5
1.0.1-dev.2On demandDownload0f2d4d55…3c9909
1.0.1On demandDownload33f26b03…e61302
1.0.2On demandDownloade2a4d5d1…e63c69
1.0.2+1On demandDownload7c821874…ec4150
1.0.3-dev.1On demandDownload8575cfc4…6b3cb7
1.0.3On demandDownload6d253403…263d2f
1.0.3+1On demandDownload31dac537…c5e983
1.0.3+2On demandDownload07eb73a0…d8d986
1.0.3+3On demandDownloadcd2c3caf…7a791f
2.0.0-nullsafety.0On demandDownload86a08556…8c0257
2.0.0-nullsafety.1On demandDownload445a11d1…9f0897
2.0.0-nullsafety.2On demandDownload78fc5a91…77812d
2.0.0On demandDownload565175fe…1fe97c
2.0.0+1On demandDownload36ea1763…70c1dd
2.0.0+2On demandDownloadb229e2c7…ee37b9
2.0.1On demandDownload69a85df4…c64c3b
2.0.1+1On demandDownload75e99c23…04d9bd
2.1.0On demandDownloadfcc6389e…723bd9
2.2.0On demandDownloadc65f0031…cbea0a
2.2.1On demandDownload726bb7ae…d8ba4e
2.2.1+1On demandDownloadb504fc5b…538275
2.3.0On demandDownload0c7785be…3d54a7
2.4.0-dev.0On demandDownload70f5b87b…6aeb62
2.4.0-dev.1On demandDownload4e83d1b4…9e0478
2.4.0-dev.2On demandDownloadfc70953e…8ea691
2.4.0-dev.3On demandDownload0fedeb30…2f5ace
2.4.0-dev.4On demandDownloadbb7d08a5…b0407f
2.4.0-dev.5On demandDownload8a94ad33…cc4ec2
2.4.0-dev.6On demandDownload0b97e65b…14d10a
2.4.0-dev.7On demandDownloadde37641b…e6de1c
2.4.0On demandDownload4aa3b917…895276
2.4.0+2On demandDownload0c21a187…7067ab
2.4.1-1On demandDownload97d92475…dd1f30
2.4.1On demandDownloadb2ed22d1…4b5ccd
2.4.2-dev.1On demandDownload9449ce5b…c63958
2.4.2On demandDownloadf09c65d0…5d5f25
2.4.2+1On demandDownload5a3c29df…3c7786
2.4.2+2On demandDownloadbfd6973a…c5183f
2.4.3-1On demandDownload88ebca9a…97300a
2.4.3On demandDownload963dad8c…6bc684
2.4.4On demandDownload220831bf…6e282c
2.4.5-1On demandDownloada3027b1e…7000c8
2.4.5-2On demandDownloadffe7c468…4e0a3b
2.4.5-3On demandDownload6c65385b…3ecf21
2.4.5On demandDownloade77abf6f…401555
2.4.5+1On demandDownload8f7603f3…b65b8f
2.5.0-1On demandDownload9915ccdd…3d1242
2.5.0On demandDownload1b92f368…55660a
2.5.0+1On demandDownload8ed04410…320803
2.5.0+2On demandDownloadbb4738f1…8a54a6
2.5.1-1On demandDownloadf3a42dd2…50bd2f
2.5.1-2On demandDownload07483102…489c18
2.5.2-1On demandDownload76db4d32…b69f14
2.5.3On demandDownload28d8c66b…ec72d5
2.5.4On demandDownload3da423ce…1f16a4
2.5.4+1On demandDownloadc5e5b2a1…bc53c2
2.5.4+2On demandDownload7b41b6c3…55453e
2.5.4+3On demandDownload4058172e…131611
2.5.4+4On demandDownload2d8e607d…71b1a4
2.5.4+5On demandDownload4468b248…0e5490
2.5.4+6On demandDownload761b9740…68f709
2.5.5On demandDownload84731e8b…ddbe8b
2.5.6On demandDownload6ef422a4…ae16a6
2.5.6+1On demandDownload5e837756…9112c3
2.5.7-1On demandDownload4c4393f7…fb90e2
2.5.7-2On demandDownload6ba7abad…25aedf
2.5.7-3On demandDownload8ade3837…3f0901
2.5.7On demandDownloadf8a08a13…875c21
2.5.8-1On demandDownloadc51b3b74…fd24e0
2.5.8On demandDownload1581ffbf…78b465
2.5.9On demandDownloadcce55807…00b014
2.5.10On demandDownload7694cb62…f7c7ef
2.5.10+1On demandDownload6e9bb47c…1daece
2.5.11On demandDownload5bf6a55c…624590
2.5.12On demandDownloadb3ebf7b3…2346d9
2.5.13On demandDownload077e38e8…6a1ea0
2.5.13+1On demandDownloadda542ae3…5e6629
2.5.14Cached · Upstream SHA-256 matchedDownloadb80e94ff…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"