Trying to get data from SQLite DB using NodeJS

Question

I'm trying to extract data from the SQLite database using NodeJS following the tutorial Following @ShadowCode answer I modified my code as follows.

const sqlite3 = require('sqlite3').verbose();

//open the database
let db = new sqlite3.Database('src/assets/academia.db');

db.run("SELECT userid as id, firstname, lastname FROM users", function(err, row){
    console.log(row.userid + " " + row.firstname + " " + row.lastname);
});

//close connection
db.close();

I get an error saying it can't read property userID. If I run the sql statement in database it runs perfectly.

TypeError: Cannot read property 'userid' of undefined
    at Statement.<anonymous> (C:\academia_2\src\get.js:7:21)
--> in Database#run('SELECT userid, firstname, lastname FROM users', [Function])

Florian sp1rit · Accepted Answer · 2019-01-28 18:57:04Z

1

Maybe your Tutorial is kinda outdated, maybe take a look at the docs sqlite3 - npm.

Look at this Snippet, for me it worked.

db.run("UPDATE tbl SET name = ? WHERE id = ?", "bar", 2);

answered Jan 28, 2019 at 18:57

Florian sp1rit

5851 gold badge7 silver badges22 bronze badges

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

1 Comment

Yury Stanev Over a year ago

Thanks I'll take look.

Collectives™ on Stack Overflow

Trying to get data from SQLite DB using NodeJS

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related