Contributor: Theo Gravity
- Update vendor typings to use sqlite3 (#176)
Contributor: Aleksandr Ananin
Breaking Change:
- Remove
params
parameter fromexec
function (#173)
Contributor: Blake Embrey
- Support all SQL template libraries (#172)
-
Support all SQL template libraries
-
Remove sql-template-strings from lib
Contributor: Andarist
- move types condition to the front (#171)
Package should have published under 4.2.0
but was also published as 4.1.3
.
Downgrade to 4.1.2
if you are having issues and raise an issue.
Contributor: rinsuki
- Support TS 4.7+ node16/next module mode (#164)
Contributor: Theo Gravity
- Have native sqlite errors contain stack traces (#162)
This ensures that errors thrown from the sqlite driver now
have stack traces and are of an Error
type.
Thanks to @fresheneesz for initial troubleshooting and initial code to help fix the issue.
This is a minor level version update as to not break implementations that may handle errors in their own way prior to this fix.
Contributor: Theo Gravity
- Update packages, fix tests for latest jest (#159)
-
Update packages, fix tests for latest jest
-
Update node version on ci
Contributor: fresheneesz
- Updating exec to support passed in parameters like the other functions do. (#155)
Contributor: dependabot[bot]
- Bump browserslist from 4.16.3 to 4.16.6 (#145)
Bumps browserslist from 4.16.3 to 4.16.6.
Signed-off-by: dependabot[bot] [email protected]
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
Contributor: dependabot[bot]
- Bump handlebars from 4.7.6 to 4.7.7 (#141)
Bumps handlebars from 4.7.6 to 4.7.7.
Signed-off-by: dependabot[bot] [email protected]
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
Contributor: Theo Gravity
- Update packages to latest
Contributor: dependabot[bot]
- Bump y18n from 4.0.0 to 4.0.1 (#139)
Bumps y18n from 4.0.0 to 4.0.1.
Signed-off-by: dependabot[bot] [email protected]
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
Contributor: dependabot[bot]
- Bump ini from 1.3.5 to 1.3.8 (#135)
Bumps ini from 1.3.5 to 1.3.8.
Signed-off-by: dependabot[bot] [email protected]
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
Contributor: dependabot[bot]
- Bump highlight.js from 10.1.2 to 10.4.1 (#133)
Bumps highlight.js from 10.1.2 to 10.4.1.
Signed-off-by: dependabot[bot] [email protected]
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
Contributor: Tiger Oakes
- Add strict types for each() (#131)
Contributor: Tiger Oakes
- Let migrations be read manually (#132)
Contributor: Paul Kiddle
- Make down migrations optional (#129)
Contributor: Theo Gravity
- Revert filename optional; update filename checks instead (#125)
The filename
property is back to being required, but empty strings are valid values for the purpose of using an anonymous disk-based database.
Values of undefined
or null
for filename
will throw.
Contributor: Theo Gravity
- Make filename optional (#124)
This allows for the specification of an anonymous database.
Contributor: dependabot[bot]
- Bump lodash from 4.17.15 to 4.17.19 (#122)
Bumps lodash from 4.17.15 to 4.17.19.
Signed-off-by: dependabot[bot] [email protected]
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>
Contributor: Theo Gravity
- Update readme for inserting rows (#120)
@akc42 pointed out that the docs for db.run
says it returns lastId
when it should be lastID
.
Contributor: Gustavo Rodrigues
- Use HTTPS in README badges (#118)
Shields.io badges were being loaded using HTTP causing mixed-content errors in the NPM page.
Contributor: Markus Felten
- feat: provide native esm exports (#117)
Contributor: George Corney
- Move triple-slash reference so it is recognized (#115)
Contributor: Yamavol
- Fix typescript defs for sqlite3 loadExtension() (#112)
Contributor: Theo Gravity
- Throw an error if two callbacks are defined for #each()
This addresses an issue where the sqlite3
API for each()
uses
two callbacks, while this library only uses one for each()
.
An error is now thrown if two callbacks are defined when using the
sqlite
each()
method.
(In sqlite
, the second callback of sqlite3
is used to resolve the
promise.)
Contributor: jameswilddev
- Use non-default imports rather than synthetic default imports. (#110)
- Fix Typescript reference issues for sqlite3 if it is not installed (#109)
This allows the usage of the sqlite3-offline
; library in Typescript.
- Fix Typescript issue where
sql-template-strings
is a forced requirement (#108)
It should be an optional dependency and is not required for installation.
- Add management tools section to readme
New major version 4!
This version has been written in Typescript with a target of node.js v10 or greater.
If you are using an older version of node < 10, use the 3.x version of the library instead.
What's new:
- ZERO dependencies!
- This should make troubleshooting the library vs the
sqlite3
driver easier. Most issues relate to thesqlite3
driver vs the library. - Allows support for alternative drivers such as
sqlite3-offline
as long as they match thenode-sqlite3
API.
- This should make troubleshooting the library vs the
- Re-written in Typescript.
- All existing features maintained.
- Existing unit tests were cleaned up and pass, new tests added.
- Better documentation. See
README.md
. - New CI process - pull requests merged into master will run tests, build, and auto-publish to NPM.
- Parity with the
node-sqlite3
API.- Exceptions are
serialize
andparallelize
(PRs are welcomed!)
- Exceptions are
Breaking Changes:
sqlite3
is no longer a dependency of this project. You must install it first before using this wrapper library.- This allows for usage of alternative libraries.
- This means
verbose
andcache
modes must be enabled before using the library. - The
README.md
file explains how to do this.
- Opening a new database has changed. See
README.md
for example. - migrations API:
force
is now aboolean
. - Can no longer specify a custom
Promise
library. Uses nativePromise
instead.
2019-03-22
- Export class types for flow ##88
2019-02-14
- Flow: Add Flow typings ##86
2019-01-28
- Typescript: Add cached option to open function ##81
- Typescript: Merged declarations for methods that accepts both string and SQLStatements in Database ##80
- Misc: Fix small typo ##84
- Apply
npm audit
fixes (mocha
updated to latest)
2018-08-22
- Add support for ES6 tagged template strings (##66)
2018-08-22
- Change baseline
sqlite3
version from4.0.0
->^4.0.0
(##71)
2018-04-20
- Bump up baseline
sqlite3
version from3.1.13
->4.0.0
(##56)
2018-01-13
- Expose the
sqlite3##configure
method (##53) - Example fixes (##52)
- Example fixes (##49)
- Expose
sqlite3
debugging hooksk (##48) - Typescript updates (##47)
2017-11-27
- Move away from global db object in readme (##45)
- Fix typescript 2.6.1 issue where *.d.ts contains executable code when it is no longer allowed (##47)
- Fix readme typo (##46)
- Bump up baseline
sqlite3
version from3.1.8
->3.1.13
2017-05-21
- Match only “down” as separator in migration files (##32)
2017-05-01
- Added support to use the database object cache as an option (see readme)
2017-04-30
- Migration bug fixed where valid multiple dashes (eg a PEM string) was being removed (##28)
2017-03-23
- npm publish'd from the wrong area. 2.4.0 is unpublished, 2.5.0 is the latest.
2017-03-23
- Typescript updates - Make ambient declarations more useful for type inference (##26)
2017-01-31
- Fix a bug sorting of schemas during migrations (##25)
2016-12-10
- Add TypeScript definition (##21)
2016-11-10
- Update
sqlite3
package to 3.1.8 - Use
external-helpers
plugin in Babel config (ref ##12)
2016-11-02
- Fix duplicate migration application when db.migrate() is run multiple times (##19)
2016-10-26
2016-07-22
- Add named parameters support (#10)
Statement
now hassql()
,lastId()
,changes()
2016-05-21
- Add SQL-based migrations API:
db.migrate({ force: 'last' })
- Add migration files examples. See
/migrations
folder. - Add support for multiple databases:
const db = sqlite.open('db.sqlite')
- Add async wrapper for
sqlite3
Statement object
2016-05-19
- The initial release after a couple of preview versions earlier this year
- Built the project with Babel and Rollup for Node.js v3-5, Node.js v6, Node.js vNext (Harmony Modules)