How to use sqlite in angularjs application

Question

I have to used below code for using sqlite inside angulajs.but i got error like, Module name "sqlite3" has not been loaded yet for context: _. Use require([]) please help me

 var sqlite3 = require('sqlite3').verbose();
var db = new sqlite3.Database('mydb.sqlite');
db.serialize(function() {
    console.log("A");
    db.run("CREATE TABLE if not exists lorem (info TEXT)");
    var stmt = db.prepare("INSERT INTO lorem VALUES (?)");
    for (var i = 0; i < 10; i++) {
        stmt.run("Ipsum " + i);
    }
    stmt.finalize();
    db.each("SELECT rowid AS id, info FROM lorem", function(err, row) {
        console.log(row.id + ": " + row.info);
    });
});
db.close();

web app or mobile app?

Niraj
– Niraj

2016-09-22 06:47:52 +00:00
Commented Sep 22, 2016 at 6:47 — Niraj
– Niraj, Commented Sep 22, 2016 at 6:47
webapplication only.....

user2447562
– user2447562

2016-09-22 06:50:09 +00:00
Commented Sep 22, 2016 at 6:50 — user2447562
– user2447562, Commented Sep 22, 2016 at 6:50

Community · Accepted Answer · 2017-05-23 10:34:11Z

1

You cannot use sqlite3 in angularjs web application directly, because angularjs is client-side frontend framework, and sqlite is a database and a part of the backend.

So you can only use sqlite in your application via backend services implemented on the server side (nodejs, java, ...). And if you need browser data storage mechanism, you can use IndexedDB.

See the similar question here.

edited May 23, 2017 at 10:34

CommunityBot

11 silver badge

answered Sep 22, 2016 at 7:08

mv200580

7421 gold badge6 silver badges14 bronze badges

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

1 Comment

mv200580 Over a year ago

You can take working example from here. It's work for me, but I had to change version for sqlite3 to * (latest) in package.json, because it was the problem with my environment (node 4.4.3, npm 2.15.1).

Collectives™ on Stack Overflow

How to use sqlite in angularjs application

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related