#CREATE SQLITE DATABASE NODE JS HOW TO#

In this tutorial, you have learned how to insert one or more rows into an SQLite table from a Node.js application. SQLite is a great database for embedded use cases. It inserted 5 rows into the langs table which is what we expected. Rows inserted 5 Code language: JavaScript ( javascript ) In this section, we will create database, establish, and close a connection with Create a new nodejs project cd sqliteBasicsnpm init -ynpm i sqlite3. Let’s run the insert-many.js program to see how it works. In nodejs, we have a module that gives us all the features we need to interact with an SQLite database. To execute an INSERT statement, you use the run() method of the Database object: db.run(sql, params, function( err)`) Now, we are ready to insert data into the langs table. Let db = new sqlite3.Database( './db/sample.db') ĭb.run( 'CREATE TABLE langs(name text)')

You can run the program to create the sample.db database and langs table as follows: const sqlite3 = require( 'sqlite3').verbose() In the sample.db database, we create a table called langs for storing programming languages: db.run( 'CREATE TABLE langs(name text)') let db = new sqlite3.Database( './db/sample.db') When you open a database connection in the default mode, the database is created if it does not exist. To insert data into an SQLite table from a Node.js application, you follow these steps:įor the demonstration, we will create a new database named sample.db in the db folder. Summary: in this tutorial, you will learn how to insert one or more row into an SQLite table from a Node.js application.

Create sqlite database node js