deno-sqlite

• Add isClosed property to the database handle

• Upgrade SQLite version to 3.42.0

• fix a bug where transactions can leave the database in auto commit mode

• Upgrade SQLite version to 3.41.2

• Add a serialize function which returns a Uint8Array representing the database
• Add a deserialize function which reads a Uint8Array into a database

• Add expandSql function to prepared queries which returns the query SQL, substituting provided parameters for their placeholders
• Add support for user defined (scalar) SQL functions; this adds a createFunction and deleteFunction API to the database class
• Improve the SQLite warm binary size by stripping debug symbols in the release build
• Improve wording of documentation and expand on existing documentation with more examples
• Fix some mistakes in example code contained in the documentation

• Deprecate one and oneEntry methods on query
• Add first and firstEntry query methods
• Update and add internal tests
• Update documentation

• Bump the SQLite version to 3.39.2
• Bump the WASI compiler version to 16.0

• Upgrade SQLite to version 3.38.3

• fixes issues that dead-lock the library on Windows when running with --unstable

• Add execute function for running multiple statements in a single query

• Added experimental support for using the library in web-browsers (this changes some internals)
• Updated documentation

• add transaction API

• Add file locking on --unstable

• Export SqliteError as a value so that it can be used in contexts like: error instanceof SqliteError

• Update bundled version of SQLite

• Improved types for prepared queries
• Export the RowObject type

• Updated query and preparedQuery API (query is mostly, but not fully, compatible with the previous versions)
• New API for retrieving rows as objects containing key value pairs
• Performance improvements to queries and prepared queries
• localtime in SQL now respects the devices local-time available in JS

Api Changes

• Add open options to the database, read-only, read-write, and read-write-create are supported
• Add a columns accessor to prepared queries

Fixes

• Fixes a potential memory leak
• Use new Deno apis to allow SQLite to sync files correctly

• Fix issues when binding BitInt values