---
title: "Record insert and retrieve using sqlite database in nodejs in Windows OS 64"  
description: "In this blog, I’m explaining  record insert and retrieve  using sqlite database in nodejs.1.DataBaseConnection.js filevar sqlite3 = require('sqlite3')"  
author: "Anonymous User"  
published: 2014-01-25  
updated: 2014-09-18  
canonical: https://www.mindstick.com/blog/635/record-insert-and-retrieve-using-sqlite-database-in-nodejs-in-windows-os-64  
category: "single page app"  
tags: ["single page app"]  
reading_time: 1 minute  

---

# Record insert and retrieve using sqlite database in nodejs in Windows OS 64

In this blog, I’m explaining record insert and [retrieve](https://www.mindstick.com/forum/34400/how-to-retrieve-form-values-in-controller-action) using [sqlite database](https://www.mindstick.com/articles/1554/crud-operation-in-asp-dot-net-using-sqlite-database) in [nodejs](https://www.mindstick.com/blog/637/create-and-run-a-html-page-in-nodejs-in-windows-os).

1. DataBaseConnection.js file

```
var sqlite3 = require('sqlite3').verbose();var db = new sqlite3.Database('databases/users');db.serialize(function () {    db.run("CREATE TABLE NodeJs (Name TEXT,EmailID TEXT,City TEXT)");    var stmt = db.prepare("INSERT INTO NodeJs VALUES (?,?,?)");        stmt.run("Kamlakar Singh","kamlakarsingh4@gmail.com","Allahabad");    stmt.finalize();    db.each("SELECT rowid AS id, Name,EmailID,City FROM NodeJs", function (err, row) {        console.log(row.id + ": " + row.Name+" : "+row.EmailID+" : "+row.City);    });});db.close();
```

2. Open [command prompt](https://answers.mindstick.com/qa/51716/how-to-make-bootable-pendrive-using-cmd-windows-command-prompt) and go to your file [location](https://www.mindstick.com/blog/11636/relocating-business-or-office-to-another-location) [your project](https://www.mindstick.com/forum/156583/best-way-to-link-bootstrap-file-in-your-project).

3. [Install](https://www.mindstick.com/articles/12876/the-top-5-reasons-to-buy-and-install-a-tonneau-cover) sqlite3 like this.

Npm install sqlite3.

4. [Execute](https://www.mindstick.com/interview/49/how-can-i-execute-a-php-script-using-command-line) your file like this![Record insert and retrieve using sqlite database in nodejs in Windows OS 64](https://www.mindstick.com/blogs/a7b0cad4-0dff-4ffa-8fcb-ec803f65a6a0/images/eed0f386-0516-4363-9051-6cbd35cedc54.png)\

5. Record insert and retrieve successfully .

in my next post i'll explain about [Javascript framework and library](https://www.mindstick.com/blog/636/Javascript%20framework%20and%20library)

---

Original Source: https://www.mindstick.com/blog/635/record-insert-and-retrieve-using-sqlite-database-in-nodejs-in-windows-os-64

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.