How to create table in sqlite3 database using Node.js ?

In this article, we are going to see how to create a table in sqlite3 database using node.js. So for this, we are going to use the run function which is available in sqlite3.

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 create a table 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