sqlite3

• Fix WasmSqlite3.loadFromUrl silently dropping request headers and a custom WASM loader.
• Fix OPFS atomics VFS causing IO errors for files larger than 2GB.
• Upgrade SQLCipher to 4.18.0.

This release upgrades SQLite to 3.53.4 and SQLite3 Multiple Ciphers to 2.5.0.

Full Changelog: sqlite3-3.5.0...sqlite3-3.5.1

• Add CommonPreparedStatement.raw and RawPreparedStatement, providing raw access to prepared statements. On the web, this also allows binding JS big integers directly.

• Add VirtualFileSystemFileV1, allowing VFS implementations in Dart to implement xFileControl and xSectorSize.
• Enable SQLITE_ENABLE_BATCH_ATOMIC_WRITE to support atomic writes on compatible VFS implementations.
• IndexedDB fileystem: Add writeAutomatically option. When disabled, writes are not automatically persisted and one needs to call flush manually. This explicit control can make database access more efficient in some cases.
• IndexedDB filesystem: Restructure IndexedDB code to use much fewer transactions, improving performance.
• Update SQLite to 3.53.3, SQLite3 Multiple Ciphers to 2.3.6 and SQLCipher to 4.17.0.
• Mark a few functions as isLeaf, reducing the native overhead of calling them.
• Reset statements after execute and select.
• Allow custom download URLs for pre-compiled binaries through the url_pattern user-define.

• Build hook: Fix assets being re-downloaded too often.

• Restore support for SQLCipher (thanks to @davidmartos96!).
• Fix crash when loading IndexedDB databases with blocks past the file length (#380).
• Don't uninstall update hooks when closing databases if no update hooks were installed by this package.

• Support package:native_toolchain_c versions 0.18.x and 0.19.x.
• Support hooks versions 2.x.
• Upgrade to SQLite version 3.53.1.
• Allow disabling BigInt support via -Dsqlite3.dartbigints=false, which can be used to reduce code size on the web if nothing else uses BigInt values.

• Avoid memory leaks when tempDirectory is set multiple times.
• Update to SQLite 3.53.0 and SQLite3 Multiple Ciphers version 2.3.3.

• Web: Add WasmModuleLoader API to customize how WebAssembly modules are loaded.
• Hook: Improve error message for failing downloads.

• Add package:sqlite3/unstable/ffi_bindings.dart providing low-level access to generated libsqlite3 bindings.
• Add PreparedStatement.leak to transfer ownership of a prepared statement into native code.
• Add Database.statementFromPointer, which can be used to access a statement prepared in native code from Dart.

• Update to sqlite version 3.52.0.

• Expose the address of sqlite3_close_v2 as static field on Sqlite3 class.
• Allow wrapping databases without closing them with the borrowed parameter on Sqlite3.fromPointer.
• Add Database.leak(), which extracts a sqlite3* pointer and disables finalizers.

• Build hook: Ensure we use consistent filenames to fix issues on Apple platforms.

• Build hook: Fix paths not resolving on Windows when building from source.

• Update to SQLite version 3.51.2.

• Database.select() will now throw an exception if the SQL string contains invalid text after the first statement.
• Build hook: Support OS-specific names when using source: system.

• Hooks: Respect HTTPS_PROXY and related environment variables when downloading SQLite (requires Dart 3.11 or later).
• Update SQLite to version 3.51.1.

• Build hook: Allow using name key with source: system to load SQLite libraries under a different name (e.g. name: sqlcipher to load SQLCipher).
• Wasm: Fix an internal memory corruption issue when more than 16 Dart handles are referenced from C.

• Build hook: Use clang from XCode when pre-compiling SQLite for iOS and macOS.

• Breaking change: Use build hooks to load SQLite instead of DynamicLibrary.
  • The SQLite library can only be customized with user defines.
  • You should drop your dependencies on sqlite3_flutter_libs and sqlcipher_flutter_libs when upgrading.
  • You can also remove dependencies on sqlite3_native_assets, since that package is now part of package:sqlite3.
• Breaking change: Parameters to SqliteExceptions are now named.
• Deprecated dispose() on CommonDatabase and CommonPreparedStatement. Use close() instead.
• On native platforms, use native finalizers to reliably clear statements and databases.
• On the web, use regular finalizers more consistently.
• Refactor binding text and blob values to reduce the chance of memory leaks.
• On the web, use externrefs to call Dart functions from compiled WebAssembly sources.
• Add busyHandler setter to install a custom sqlite3_busy_handler on databases.

• SimpleOpfsFileSystem: Allow opening with readwrite-unsafe, which can be used to implement multi-tab OPFS databases on Chrome with an outer locking scheme.

• Allow iterating over statements after SQLITE_BUSY errors.

• Fix a bug introduced in version 2.9.1 where the SQLite framework provided by sqlite3_flutter_libs would not load correctly on iOS.

• Check for error codes when binding values to prepared statements.
• Flutter: Fix loading SwiftPM libraries from sqlite3_flutter_libs.

• Add CommonDatabase.updatesSync, a synchronous variant of the updates stream.

• Support creating changesets and patchsets via the session extension.
• Add the SubtypedValue extension type to allow returning values with a subtype.
• Add the subtypeOf method to the SqliteArguments interface passed to user-defined functions. It returns the subtype assigned to an argument.
• Web: Refactor SQLite bindings to make them easier for compilers to optimize.

• jsonb codec: Refuse to encode NaN values since recent SQLite versions reject them.

• Export package:sqlite3/native_assets.dart, making it easier for libraries to support both the regular sqlite3 getter and the upcoming sqlite3NativeAssets variant.
• Fix dereferencing null pointer when reading file names for temporary files in native VFS implementation.

• On Windows, try loading winsqlite3.dll as a fallback if loading sqlite3.dll fails.

• Prepare support for accessing SQLite through native assets. This is available as a preview through package:sqlite3_native_assets.

• Web: Support localtime datetime modifier in SQLite.
• Introduce topics to dartdoc documentation.
• Report locations of syntax errors in SqliteException.

• Web: Fix update events not being delivered in some shared worker setups.

• Web: Fix a crash when using version 2.7.0 of this package with an older WebAssembly bundle. Note: Version 2.7.0 has been retracted from pub.dev for this reason.

• Add support for commit and rollback hooks as well as a predicate that can revert transactions. Thanks to @jackd!

• Fix out-of-bound reads in the xWrite implementation of the OPFS-locks based file-system implementation when writing more than 64 KiB in one operation.
• Support SQLite libraries compiled with SQLITE_OMIT_AUTOINIT.

• Add SimpleOpfsFileSystem.deleteFromStorage to delete OPFS-based file systems.
• Add jsonb, a Dart Codec converting Dart object from and to SQLite JSONB values.
• Experimentally support encryption on the web through SQLite Multiple Ciphers. The readme provides more information on how to use encryption on the web.

• Allow registering custom virtual file systems on all platforms. Previously, this was only supported on the web.
• IndexedDB file system: Store ArrayBuffers instead of Blobs when it looks like storing blobs would cause issues.

• Web: Improve performance of in-memory and IndexedDB file system implementations.

• WebAssembly: Call _initialize function of sqlite3 module if one is present.
• Support version 1.0.0 of package:web.

• Fix a bug in the OPFS-locks implementation causing a deadlock when the xSleep VFS call is issued.
• Fix selecting large integers (being represented as a BigInt in Dart) not working when compiled with dartdevc.

• Add a temporary workaround for a Dart bug causing spurious exceptions when databases are closed and a debugger is attached.

• Migrate away from legacy web APIs: dart:html, dart:js, dart:indexeddb and package:js are no longer imported from this package.
• Experimentally support being compiled to WebAssembly. Strong caveats apply, please check #230 before relying on this!

• Fix string and blob arguments to prepared statements never being deallocated (#225).

• Allow version 0.7.x of the js package.
• Reduce size of sqlite3.wasm bundle by removing symbols not referenced in Dart.

• Add isReadOnly and isExplain getters to prepared statements.
• Set NativeCallable.keepIsolateAlive to false for callables managed by this package.

• Add the autocommit getter on databases wrapping sqlite3_get_autocommit.
• Improve the error message in the exception when opening a database fails.

• Add updatedRows getter to eventually replace getUpdatedRows() method.
• Clarify documentation on lastInsertRowId and updatedRows.
• Allow customizing the amount of pages to lock at a time in backup. A larger amount will result in better backup performance.
• Use NativeCallables for user-defined functions, collations and update streams.

• Add config getter to CommonDatabase to access sqlite3_db_config.

• Breaking: The WASM implementation no longer registers a default virtual file system. Instead, registerVirtualFileSystem needs to be used to add desired file system implementations.
• Breaking: Fix a typo, CommmonSqlite3 is now called CommonSqlite3.
• Breaking: Introduce class modifiers on classes of this package that aren't meant to be extended or implemented by users.
• Add PreparedStatement.reset().
• Add the CustomStatementParameter class which can be passed as a statement parameter with a custom sqlite3_bind_* call.
• Add the StatementParameters class and executeWith/selectWith methods on CommonPreparedStatement. They can be used to control whether values are bound by index or by name. The selectMap and executeMap methods have been deprecated.

• Report correct column names for statements that have been re-compiled due to schema changes.