sqflite 2.4.0

Flutter plugin for SQLite, a self-contained, high-reliability, embedded, SQL database engine.

2.4.0

• Make sqflite a federated plugin including sqflite_android and sqflite_darwin (iOS/macOS) plugins

2.3.3+2

• Remove android v1 embedding support
• Use compileSdk 34 on Android
• sdk: >= 3.3.0

2.3.2

• Shared iOS/MacOS darwin implementation
• Remove FMDB podspec dependency

2.3.1

• Add iOS/MacOS privacy manifest

2.3.0

• Dart 3 only

2.2.8+4

• Android: Adds a namespace for compatibility with AGP 8.0.
• Android: Use compile SDK 33
• Export global sqflite API
• iOS set minimum deployment target to 11.0

2.2.7

• Dart 3 support

2.2.6

• uri support for supported implementations.

2.2.5

• Fix concurrency issue in database worker pool ([e-mail])
• add android setLocale API call support.

2.2.4+1

• Experimental logger support.

2.2.3-1

• strict-casts and sdk 2.18 support

2.2.2

• Fix iOS/MacOS FMDB include for non-swift project

2.2.1

• Allow multiple threads on Android, thanks to zhenpingcui

2.2.1-1

• Fix iOS/MacOS FMDB include

2.2.0+3

• Implements Database.queryCursor() and Database.rawQueryCursor()
• Dependency update
• Initial support of cross isolate safe
• Transaction v2 update

2.1.0+1

• Android: fix parameter binding for non string parameters
• Android: fix unit test

2.0.4-dev.1

• Android: Allow turning on WAL in the manifest.

2.0.3+1

• MacOS: Fix crash when an invalid number of parameters is specified in the query

2.0.3

• iOS/Android: Flutter 3.0 support, makes all the channel calls happen on thread pool instead of the UI thread
• iOS/MacOS: make close happen in a background thread

2.0.2+1

• Android build: remove jcenter, compile sdk set to 31

2.0.1

• Bump default android thread priority to THREAD_PRIORITY_DEFAULT

2.0.0+4

• nnbd support

1.3.2+3

• iOS/macOS: Update FMDB to 2.7.5+
• android: Update gradle to 6.5
• fix logs on iOS

1.3.1+2

• add databaseFactory setter to change the default sqflite factory.
• Fix empty Blob returned as null on MacOS/iOS
• Test using integration_test

1.3.0+2

• Add sqflite_common dependency

1.2.2+1

• Fix iOS warning on FMDB import
• Support pedantic 1.9
• Check arguments in debug mode (print errors only)

1.2.1

• Support Android embedding v2
• Add private mixin
• Support iOS/MacOS incremental build

1.2.0

• Add MacOS support

1.1.8

• support deleteDatabase after hot-restart. Existing, if any, single instance database ìs closed before deletion

1.1.7+3

• Bump flutter/dart dependency version (1.9.1/2.5.0)
• Fix hot and warm restart for opened databases on Android
• Add code documentation, code coverage and build badges
• Fix ios example build

1.1.6+5

• Open database in a background thread on Android.
• Prevent database deletion on Android when opening a corrupted database in read-only.
• Fix hot restart ROLLBACK warning
• Fix indexed parameter binding on iOS

1.1.5

• Add databaseExists as a top level function
• handle relative path in databaseExists and deleteDatabase
• Supports hot-restart while in a transaction on iOS and Android by recovering the database from the native world and executing ROLLBACK to prevent SQLITE_BUSY error
• If in a transaction, execute ROLLBACK before closing to prevent SQLITE_BUSY error

1.1.4

• Make all db operation happen in a separate thread on iOS

1.1.3

• Fix deadlock issue on iOS when using isolates

1.1.2

• Sqflite now uses a thread handler with a background thread priority by default on Android

1.1.1

• Use mixin and extract non flutter code into sqlite_api.dart
• Deprecate SqfliteOptions which is only used internally

1.1.0

• Breaking change. Migrate from the deprecated original Android Support Library to AndroidX. This shouldn't result in any functional changes, but it requires any Android apps using this plugin to also migrate if they're using the original support library.

  You might say thay version should be bumped to 2.0.0, however it is just a tooling issue, code is not changed. This is a copy of the changes made in the flutter plugins

1.0.0

• Upgrade 0.13.0 version as 1.0.0
• Remove deprecated API (applyBatch, apply)

0.13.0

• Add support for continueOrError for batches

0.12.0

• iOS objective C prefix added to prevent conflict
• on iOS create the directory of the database if it does not exist

0.11.2

• add Database.isOpen which becomes false once the database is closed

0.11.1

• add Sqflite.hex to allow querying on blob fields

0.11.0

• add getDatabasesPath to use as the base location to create a database
• Warning: database are now single instance by default (based on path), to use the old behavior use singleInstance = false when opening a database
• dart2 stable support

0.10.0

• Preparing for 1.0
• Remove deprecated methods (re-entrant transactions)
• Add Transaction.batch
• Show developer warning to prevent deadlock

0.9.0

• Support for in-memory database (:memory: path)
• Support for single instance
• new database factory for handling the new options

0.8.9

• Upgrade to sdk 27

0.8.8

• Allow testing for constraint exception

0.8.6

• better sql error report
• catch android native errors
• no longer print an error when deleting a database fails

0.8.4

• Add read-only support using openReadOnlyDatabase

0.8.3

• Allow running a batch during a transaction using Transaction.applyBatch
• Restore Batch.commit to use outside a transaction

0.8.2

• Although already in a transaction, allow creating nested transactions during open

0.8.1

• New Transaction mechanism not using Zone (old one still supported for now)
• Start using Batch.apply instead of Batch.commit
• Deprecate Database.inTransaction and Database.synchronized so that Zones are not used anymore

0.7.1

• add Batch.query, Batch.rawQuery and Batch.execute
• pack query result as colums/rows instead of List

0.7.0

• Add support for --preview-dart-2

0.6.2+1

• Add longer description to pubspec.yaml

0.6.2

• Fix travis warning

0.6.1

• Add Flutter SDK constraint to pubspec.yaml

0.6.0

• add support for onConfigure to allow for database configuration

0.5.0

• Escape table and column name when needed in insert/update/query/delete
• Export ConflictAlgorithm, escapeName, unescapeName in new sql.dart

0.4.0

• Add support for Batch (insert/update/delete)

0.3.1

• Remove temp concurrency experiment

0.3.0

2018/01/04

• Breaking change. Upgraded to Gradle 4.1 and Android Studio Gradle plugin 3.0.1. Older Flutter projects need to upgrade their Gradle setup as well in order to use this version of the plugin. Instructions can be found here.

0.2.4

• Dependency on synchronized updated to >=1.1.0

0.2.3

• Make Android sends the reponse in the same thread then the caller to prevent unexpected behavior when an error occured

0.2.2

• Fix unchecked warning on Android

0.2.0

• Use NSOperationQueue for all db operation on iOS
• Use ThreadHandler for all db operation on Android

0.0.3

• Add exception handling

0.0.2

• Add sqlite helpers based on Razvan Lung suggestions

0.0.1

• Initial experimentation