How To Use SQLite with Node.js on Ubuntu 22.04

Commands Used
FIRST
mkdir name
cd name
npm init -y
npm install sqlite3

SECOND

const sqlite3 = require("sqlite3").verbose();

function createDbConnection() {
const db = new sqlite3.Database(filepath, (error) = {
if (error) {
}
createTable(db);
});
return db;
}

function createTable(db) {
CREATE TABLE sharks
(
ID INTEGER PRIMARY KEY AUTOINCREMENT,
name VARCHAR(50) NOT NULL,
color VARCHAR(50) NOT NULL,
weight INTEGER NOT NULL
);
`);
}

ls
const fs = require("fs");
const sqlite3 = require("sqlite3").verbose();

function createDbConnection() {
return new sqlite3.Database(filepath);
} else {
const db = new sqlite3.Database(filepath, (error) = {
if (error) {
}
createTable(db);
});
return db;
}
}

function createTable(db) {
CREATE TABLE sharks
(
ID INTEGER PRIMARY KEY AUTOINCREMENT,
name VARCHAR(50) NOT NULL,
color VARCHAR(50) NOT NULL,
weight INTEGER NOT NULL
);
`);
}

THIRD

const db = require("./db");

function insertRow() {
`INSERT INTO sharks (name, color, weight) VALUES (?, ?, ?)`,
[name, color, weight],
function (error) {
if (error) {
}
}
);
}

insertRow();

FOURTH

const db = require("./db");

function selectRows() {
if (error) {
}
});
}

selectRows();

FIFTH

const db = require("./db");

function updateRow() {
`UPDATE sharks SET name = ? WHERE id = ?`,
[name, id],
function (error) {
if (error) {
}
}
);
}

updateRow();

SIXTH

const db = require("./db");

async function deleteRow() {
if (error) {
}
});
}

deleteRow();

Useful Links