node-sqlite3
node-sqlite3 copied to clipboard
TryGhost
SQLite3 bindings for Node.js
### Summary Nowadays it is necessary to keep data safe. Is it possible to implement authentication using the password for the sqlite database? ### Proposed implementation If we use DB...
### Issue Summary When I use the REGEXP function in a query directly in sqlite 3 CLI tools it's work fine But when I try to use it with node-sqlite3...
After upgrading from node-sqlite3 4.2.0 to 5.0.0, my Jest test suite started failing because JavaScript `Date` objects were inserted into the database as strings (e.g., "Sat Jul 11 2020 17:06:27...
I've encountered different behavior regarding large numbers with node-sqlite3. I have a table like ``` CREATE TABLE IF NOT EXISTS test ( number TEXT NOT NULL ); ``` and a...
How do we make sure that db#serialize is completed before executing the start timer code again?. I see await/async with a promise to be the only option to fix this....
Errors from sql statements, when not handled in a callback, are emitted as events on the statement object. The problem is that the statement object is not accessible, when the...
All rows and columns already read should be released at https://github.com/mapbox/node-sqlite3/blob/593c9d498be2510d286349134537e3bf89401c4a/src/statement.cc#L581 even if an error occuerd.
Wrapping sqlite3 calls using node's builtin promisify results in a segfault on node 17.6.0: ```javascript const sqlite = require('sqlite3'); const util = require('util'); const db = new sqlite.Database(':memory:'); const db_get...
If I enable tracing ("db.on('trace', …)") while a database is serialized ("db.serialize()"), the first command I try to execute appears hangs indefinitely. If either tracing or serialization is off, I...
It seems that after building using the source code, it just leaves the intermediate build files everywhere including multiple copies of the compiled sqlite3 plugins, and this is causing issues...
