Where communities thrive

  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
Repo info
  • Nov 10 23:10
    dependabot[bot] labeled #101
  • Nov 10 23:10
    dependabot[bot] opened #101
  • Nov 10 23:10

    dependabot[bot] on npm_and_yarn

    Bump diff from 3.2.0 to 3.5.0 … (compare)

  • Nov 10 23:10
    dependabot[bot] labeled #100
  • Nov 10 23:10
    dependabot[bot] opened #100
  • Nov 10 23:10

    dependabot[bot] on npm_and_yarn

    Bump growl from 1.9.2 to 1.10.5… (compare)

  • Nov 10 23:10
    dependabot[bot] labeled #99
  • Nov 10 23:10
    dependabot[bot] opened #99
  • Nov 10 23:10

    dependabot[bot] on npm_and_yarn

    Bump js-yaml from 3.12.0 to 3.1… (compare)

  • Nov 10 23:09

    theogravity on master

    Update README.md It took me so… Merge pull request #98 from air… (compare)

  • Nov 10 23:09
    theogravity closed #98
  • Nov 09 19:56
    msikma commented #39
  • Nov 09 19:55
    msikma commented #39
  • Nov 01 16:06
    airportyh opened #98
  • Oct 29 19:14
    zwhitchcox opened #97
  • Sep 26 23:35
    slorenzo commented #85
  • Sep 26 15:45
    scottdotjs edited #96
  • Sep 26 15:45
    scottdotjs opened #96
  • Sep 21 21:34
    aashna208 opened #95
  • Sep 21 21:32
    aashna208 commented #85
Robert Jane
i was wondering why this doesn't work...
    var getMember = (day, guild) => {
        db.all('SELECT * FROM gk WHERE weekday = ? AND guild = ?', day, guild).then(members => {
            return members;
Question - does database.each() work with this or do I have to use .all() and loop through the resulting array in the promise myself?
Hey everyone
I'm not sure if this might be more of a Node.js question or an SQLite question, but how would one go about neatly opening their database and assigning it to a variable?
@Aetheryx db = require('sqlite'); db.open('path/to/file/here/database.sqlite');
This message was deleted
@ThePsionic Please tell me you're kidding.
I was up till like 2am trying to figure out something decent. I thought the only way to get the db was the promise returned by sqlite.open. http://i.imgur.com/phNAqDx.png
^ That's how it was looking when I went to sleep. xD
Thanks though.
James Kiefer
i think an example showing how to use query.stmt.lastID could be beneficial for noobs like me
stupid question, trying to figure out how to call db.get in a loop while preserving variables
seems all iterations complete with the final loop variable
Konstantin Tarkus
@SpacemannFinn did you try something like this:
(async () => {
  for (const item of items) {
    await db.get(..);
Nick Buchanan
Does anyone know if Spatialite integration has been attempted with this Node SQLite binding? I am aware of https://github.com/zhm/node-spatialite but it has not been updated in a year and change. Thanks.
Wésley Queiroz

anyone knows any lib for node where is an api abstraction on top of sqlite for ease of use?

I'm thinking in some "mongodb like" queries to use in sqlite databases

أحمد السيد
Sven Neuhaus
so what's the deal with "import", I need nodejs 9.x to use it, right? 8.x won't do?
Theo Gravity
I think import is under an experimental flag under 8.x. I personally use babel to work with imports for now. I wouldn't use 9.x in a production environment - odd numbered node versions are not for production use
@wescoder I use this for postgres, it has sqlite support but unsure to what extent - Try knex.js paired with objection.js (really lightweight orm)
Wésley Queiroz
Thanks @theogravity I'll check it out.
By reading the docs it seems to be what I'm looking for.
Nat Karmios
Hey all, quick question, is there something in particular I'm supposed to do in order to get the package working with Electron/Webpack?
Joe Becher
Is there an example for using this module that doesn't involve async/await? I'm not sure how to use const dbPromise = sqlite.open('./database.sqlite', { Promise }); otherwise.
:point_up: July 10, 2017 7:33 PM Looks like what I need as well, thanks :)
Joe Becher
Nope. https://pastebin.com/jB9DKrZb Can someone please explain why this is returning instantly? I get I should not get here , but never Database open
أحمد السيد
hi guys
i need some help here in sqlite module can someone help me?
Anyone had issue with trying to install sqlite3 into npm?

heres what I am trying to do and first line of error
C:\Users\Steve\quotes-api>npm install sqlite3 --save

sqlite3@4.0.0 install C:\Users\Steve\quotes-api\node_modules\sqlite3
node-pre-gyp install --fallback-to-build

node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v4.0.0/node-v64-win32-x64.tar.gz

anyone's here?
i want to ask
Hi, I am new to SQLite and want to ask if it is possible to bulk import data from another SQLite DB, or a file to an in-memory SQLite DB running in a nodejs process - can the nodejs process execute A SQL command or does the node-sqlite module have a method to bulk import?
Philipp Kursawe
is there an extension to hash rows when they are updated?
Joe Becher
I'm trying to export my sqlite.open result connection as a reusable connection so I don't have connect each time. Any thoughts on the best way? I keep ending up with a promise, not an sqlite.Database object
Benjamin Pasero
Hey, first time user of sqlite module, QQ: I see most methods I can run return a promise. What is the contract here, do I need to await each method I call before I should call the next? In other words, which methods are fine if they run in parallel and do I even need to care about the finishing of the execution at all?
Scott Oloier
so...this looks dead based on the amount of questions I see vs. answers
but sqlite3 installs and builds fine on Node11, and a standalone file will execute correctly, howeverwhen building my project I'll get an "Error: The module '\path\to\project\node_modules\sqlite3\lib\binding\node-v64-win32-x64\node_sqlite3.node' - however, my build resulted in a node-v67-win32-x64 node parent directory
so the NODE_MODULE_VERSION is set wrong...or something
can someone help me with the file storage, i keep trying, but it does not want to work
if i use nexe to build files
How to deal with this problem
Hi, I am trying to use node-sqlite with electron 3.1.6 on macOS but it would default to node binaries and not use electron binaries. Is there a solution for that problem?
This message was deleted