Releases: WiseLibs/better-sqlite3
v2.3.1
v2.3.0
This release fixes a few minor bugs, significantly improves overall performance, and introduces the db.register()
method, which allows you to define custom SQL functions.
0d4e336 added the db.register() method, allowing you to register custom SQL functions
f3daddb prepared statements and transactions can now be reused even after the table schema changes
6fff040 pluck() and safeIntegers() can no longer be invoked within an each() callback function
v2.2.0
v2.1.0
v2.0.0
v1.4.0
v1.3.9
v1.3.8
v1.3.6
v1.3.1
3779fc9 read-only statements that do not return data can now be executed with .run()
This removes the .readonly
property and introduces the .returnsData
property as its replacement. Statements are no longer semantically segregated based on whether they modify data, but rather whether they return data. There are two major reasons for this:
- It makes more sense to
.prepare('BEGIN;').run()
than to.prepare('BEGIN;').get()
- Both
CREATE TABLE foo (bar)
andCREATE TABLE IF NOT EXISTS foo (bar)
should use the same execution method (.run()
)