Skip to content
Related Articles

Related Articles

How to update data in sqlite3 using Node.js ?

View Discussion
Improve Article
Save Article
  • Difficulty Level : Medium
  • Last Updated : 07 Sep, 2022
View Discussion
Improve Article
Save Article

In this article, we are going to see how to update data in the sqlite3 database using node.js. So for this, we are going to use the run function which is available in sqlite3. This function will help us to run the queries for updating the data.

SQLite is a self-contained, high-reliability, embedded, public-domain, SQL database engine. It is the most used database engine in the world. Let’s understand How to update data in a sqlite3 database using Node.js.

Below is the step by step implementation:

Step 1: Setting up the NPM package of the project using the following command:

npm init -y

Step 2: Install Dependencies using the following command:

npm install express sqlite3

Project structure: It will look like the following.

Step 3: Here, we created a basic express server that renders GeeksforGeeks on the browser screen.

index.js

 

Step 4: Importing ‘sqlite3’ into our project using the following syntax. There are lots of features in the sqlite3 module.

const sqlite3 = require('sqlite3');

Step 5: Now write a query for updating data in sqlite3.

/* Here GFG is table name */
var updateQuery = 'UPDATE GFG SET NAME = "Updated_Name"';

Step 6: Here we are going to use a Run method which is available in sqlite3.

index.js

 

Step to Run Server: Run the server using the following command from the root directory of the project:

node index.js

Output:

Reference: https://www.npmjs.com/package/sqlite3

My Personal Notes arrow_drop_up
Recommended Articles
Page :

Start Your Coding Journey Now!