I'm trying to insert many different rows into an sqlite database using a single operation. Each of the rows has multiple columns, and I have the data represented as an array of arrays. I've read t...

In node-sqlite3, if the db is currently in serialized mode, will the next statement wait before the callback of the previous statement finishes, or will the callback run at the same time as the nex...

I'm struggling with some basic async/await problem in node.js using node-sqlite3. My objective is to select some value from SQLite DB, check it for some condition and take some actions in case the ...

I was trying to install the npm, but I keep getting this error that I think is related to the hummus module: npm WARN deprecated [email protected]: Please update to ini >=1.3.6 to avoid a p...

I have created an electron project which is working fine but when I try to package an electron app using electron packager and then run it. I am facing an exception Uncaught Exception: Error: Canno...

I'm using better-sqlite3 on Node, but I suspect my questions are applicable to node-sqlite3 as well. I basically have 2 simple questions, relating to a server-rendered website: Do I need to explic...

I am using the sqlite3 NPM package. I would like store JSON in one of my database columns. I understand that SQLite itself is able to store JSON https://www.sqlite.org/json1.html, but I am not nece...

I'm trying to get nexe working with a node program that uses sqlite3. When I try I get this at runtime: package.json must declare these properties: binary.module_name binary.module_path binary.hos...

Recently I'm learning to use node and node-sqlite3 to manipulate sqlite3, here is a sample. var sqlite3 = require('sqlite3'); var db = new sqlite3.Database(':memory:'); db.serialize(function() { ...

I want to insert rows into a SQLite3 table using the knex.raw method. Unfortunately I get a 'SQLITE_RANGE' error, which makes my test fail. I have verified the bindings passed to the raw query in t...

Question Is there a way to install node-sqlite3 for multiple platforms I am targeting in my app without running standalone build for just every target platform combination? Context In my Node.js...

My problem is to figure out when to close a database connection from an expressjs backend to a sqlite database. What I basically want to achieve is a database connection which is open during the ...