We are using the sqlite npm module. It uses the sqlite3 module so we need this as well.

SQL is a a small, fast, self-contained, high-reliability, full-featured, SQL database engine. And it's easy to setup. In the future you can explore using a database like [PostgreSQL] - the principles you will learn using SQLite applies to most SQL databases.

Learn more aboute SQLite here.

Where are using the 4 sql commands select, insert, update and delete to manage a counter when a user click a button.

See the SQL commands this application is using in the table below.

To setup SQLite in your code you need this:

Import the modules:

// import sqlite modules
const sqlite3 = require('sqlite3');
const { open } = require('sqlite');

Add this code to your application.

open({
	filename: './data.db',
	driver: sqlite3.Database
}).then(async function (db) {

	// run migrations

	await db.migrate();

	// only setup the routes once the database connection has been established

})

The SQLite module has a few different methids

Migrations is an easy way to run DDL scripts on your database.

async/await is a cleaner syntax for handling asynchronous code.

You can learn more about asynchronous code in JavaScript here.

Learn more about async/await & promises here: https://www.youtube.com/embed/videoseries?list=PLVcT2txrixoVW_HZsO70gf695a1zfXNvf

callback

query(“select * from table”, function(err, result){});

promises

query(“select * from table”).then(function(result){});

async/await

const result = await query(“select * from table”);