Error creating database with JS, Node and SQlite3

Question

I just want to start off by saying that I have found out Stack questions that are similar if not the same, but the answers there don't work.

I am just wanting to make a smallish database so I can query all of my items in storage. I thought I would try out SQLite because people say that it is easy to use and lightweight.

Here is the question/answer that doesn't work: sqlite3 create database with callback using node and here is the reference from sqlitetutorial.net

Here is my code and the errors I am getting. I don't understand why it is not just creating a new database.

'use strict'

// Open the database in memory
const sqlite3 = require('sqlite3').verbose();

let db = new sqlite3.Database('/db/storage.db', (err) => {
    if (err) {
        console.error(err.message);
    } else {
        console.log('Connected to the in memory SQlite database.')
    }
});


// Close the database
db.close((err) => {
    if (err) {
      return console.error(err.message);
    }
    console.log('Close the database connection.');
});

Then the error message is

SQLITE_CANTOPEN: unable to open database file
Segmentation fault (core dumped)

Or then if I use the sqlite3.OPEN_CREATE parameter, I get this error.

SQLITE_MISUSE: bad parameter or other API misuse
Segmentation fault (core dumped) code here

So I don't entirely know what's wrong here, as it's just my first hour messing around with it but it seems many others have had this issue.

I'd also like to know why OPEN_CREATE causes an error. Wish this library had more resources to develop it. — A13X
– A13X, Commented Aug 16, 2024 at 3:59

ConnerWithAnE · Accepted Answer · 2021-08-23 00:56:26Z

0

I figured out the issue and it is a really simple one. It was just me not paying attention to directory locations. When declaring the database the dot NEEDS to be there.

let db = new sqlite3.Database('./db/storage.db', (err) => {
    if (err) {
        console.error(err.message);
    } else {
        // do stuff
    }
});

edited Aug 23, 2021 at 0:56

answered Aug 22, 2021 at 2:12

ConnerWithAnE

1,16813 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Error creating database with JS, Node and SQlite3

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related