node-sqlite3
node-sqlite3 copied to clipboard
SQLite3 bindings for Node.js
I created [emnapi](https://github.com/toyobayashi/emnapi) for porting Node.js addons written in Node-API to Emscripten WebAssembly. I successfully built this project to wasm, all test cases passed ~~except the one related to `async_hooks`,...
This PR introduces the ability to use an instance of sqlite3.Database to perform backups using the Online Backup API. This PR is a work in progress until `yarn test` runs...
This PR allows the eager start of the next queued query execution in Statement::All - before the JS callback execution. In some cases, it could double performance by allowing parallel...
Well this is not full ready yet, but I'd like to bring some discussions: 1. To use SQLite int64 instead of int32, because JS Number type is always 64 bits;...
Introduce a refcount for cached `Database` entries so that calling `close()` on the `Database` returned from `cached.Database()` does not invalidate existing or future uses of the same cached `Database`. This...
Fixes #658 Currently, promisifying `db.run()` results in a loss of information of `lastID` and `changes`. In this PR, I customized the promisification of `db.run()` using `util.promisify.custom` to solve the problem.
I'm the developer of [Tad](https://github.com/antonycourtney/tad), a fast, free CSV file viewer and pivot-table based UI for exploring and analyzing tabular data, implemented in JavaScript. Tad works by immediately importing target...
Synchronous methods are very useful for batch scripts. I think supporting both of synchronous version and asynchronous one is so good.
I tried to add tables for two days. The query was: ```javascript db.run(` PRAGMA foreign_keys = ON; CREATE TABLE pkgs( .... ); CREATE TABLE subs( ... ); `); ``` And...
### Summary I am having a report with error message mentioning `SQLITE_IOERR`. However, I cannot find the exact reason why application fails to use a database. There are number of...