sqlite3 1.7.2

• Optimizations in the wasm-based file system.
• Fix the mutex parameter not doing anything in the FFI-based implementation.

sqlite3 1.7.1

sqlite3 1.7.1

• Allow binding BigInts to statements and functions. They must still be representable as a 64-bit int, but this closes a compatibility gap between the web and the native implementations.
• Use ABI-specific integer types internally.

sqlite3_flutter_libs 0.5.7

• Update to sqlite3 version 3.38.5

sqlite3_flutter_libs 0.5.6

• Upgrade sqlite3 to version 3.38.3.

sqlite3 1.7.0

• Add support for application-defined window functions. To register a custom window function, implement WindowFunction and register your function with database.registerAggregateFunction.
• Breaking (For the experimental package:sqlite3/wasm.dart library):
  • The IndexedDB implementation now stores data in 4k blocks instead of full files.
  • Removed IndexedDbFileSystem.load. Use IndexedDbFileSystem.open instead.
  • An IndexedDbFileSystem now stores all files, the concept of a persistence root has been removed. To access independent databases, use two IndexedDbFileSystems with a different database name.

sqlite3 1.6.4

• Add FileSystem.listFiles() to list all files in a virtual WASM file system.

sqlite3 1.6.2

This patch release fixes the behavior of CURRENT_TIME, CURRENT_DATE and CURRENT_TIMESTAMP in the WebAssembly backend.

sqlite3 1.6.1

sqlite3 1.6.1, sqlite3_flutter_libs 0.5.5

When running through Flutter, these releases add native support for running on Linux and Windows. No custom setup is needed anymore!

sqlite3 1.6.0

• Very experimental web support, based on compiling sqlite3 to web assembly with a custom file system implementation.

The new web version is available through the package:sqlite3/wasm.dart library. An example on how to use that library is available here. The web version has an interface compatible to the existing FFI API.
Using the new web version requires a custom sqlite3 version compiled to WebAssembly, those modules are attached to GitHub releases of the sqlite3 package.

sqlite3_flutter_libs 0.5.4

• Update sqlite to version 3.38.0

sqlite3 1.5.1

1.5.1

• Fix checkNoTail throwing for harmless whitespace or comments following a SQL statement.
• Fix a native null-pointer dereference when calling prepare with a statement exclusively containing whitespace or comments.
• Fix a potential out-of-bounds read when preparing statements.