v0.7.2

What's Changed

• fix: Statement Finalizer causing double free when DB is explicitly closed by @DjDeveloperr in #79

Full Changelog: 0.7.1...0.7.2

v0.7.1

There was a typo in filename for Windows prebuilt binary such that it failed to load. This patch fixes it.

v0.7.0

What's Changed

• feat: add unsafeConcurrency mode by @littledivy in #65
• chore: benchmark charts by @DjDeveloperr in #66
• fix(Database): auto-finalize all open statements on Database#close by @DjDeveloperr in #70
• feat: user defined functions by @DjDeveloperr in #71
• fix: correctly pass empty strings by @nsf in #74
• chore: build sqlite binaries for windows by @DjDeveloperr in #75
• fix!: remove SQLBlob's async read/write methods because they sometime… by @DjDeveloperr in #76

New Contributors

• @nsf made their first contribution in #74

Full Changelog: 0.6.1...0.7.0

v0.6.1

There was an error in release 0.6.0 which made downloading the prebuilt binaries fail. 0.6.1 patches that.

v0.6.0

Changelog

• fix: keep reference to buffers before passing their pointers (#59)
• feat!: add Statement#value which returns only first row as array and changed Statement#get to return row as object instead (previously it returned as array which was confusing, see #58) (#60)

This release includes breaking changes to Statement#get method. For the old behavior of get method, use value instead.

v0.5.3

What's Changed

• chore: fix doc link by @web2033 in #55
• perf: use custom sqlite library on unix by @littledivy in #56

New Contributors

• @web2033 made their first contribution in #55

Full Changelog: 0.5.2...0.5.3

v0.5.2

What's Changed

• fix: accept bind parameters in Statement#get by @DjDeveloperr in #53
• perf: make bigints optional in query results as they slow down fastapi calls (off by default, turn on using int64 option when creating database object) by @DjDeveloperr in #54

Full Changelog: 0.5.1...0.5.2

v0.5.1

• fix: Database#run/exec and Statement#run now return number of changes made as well.
• perf: optimized a case when there's no bind parameters needed in Statement
• doc: add better documentation (doc.md)

v0.5.0 - Rewrite

This release contains breaking changes as a result of a rewrite.

There are a lot of changes in the API, mostly focused on making it more easier to use and performant.
The API now is similar to that of better-sqlite3.

Updates:

• Many performance optimizations, FFI layer now leverages fastapi calls. Now much more faster than x/sqlite (WASM based), and also faster than Node.js better-sqlite3.
• Methods like queryArray/Object have been removed in favor of using prepared statements (which they previously were just a wrapper of).
• Transactions API has been added.
• PreparedStatement renamed to Statement and its API has been changed quite a lot.

Check out the documentation here for this new version.

v0.4.4

What's Changed

• chore(bench): use Deno.bench by @DjDeveloperr in #35
• fix: for breaking ffi api changes & optimize some functions for fastapi by @DjDeveloperr in #43

Full Changelog: 0.4.3...0.4.4