Learn
Learn Node SQLite
Opening A Database

Throughout this lesson, we’re going to access an SQLite database with temperature data for countries over the last 150 years. We’re going to take this data, collect it per year in a JavaScript object, average it, and save it into a new SQL database!

To get these two worlds to communicate, we will be importing a package into our JavaScript code. This package will allow us to open the channels of communication with our SQLite database. Once we do that, we can start writing SQL directly in our JavaScript!

The first order of business is to import the module that will facilitate this connection. Recall that to import a module in JavaScript we can use require() like so:

const sqlite3 = require('sqlite3');

The code above gives us a JavaScript object, called sqlite3 that we can interact with via methods. The first method we’re going to use on sqlite3 is going to be the method that opens up a new database. In SQLite, a database corresponds to a single file, so the only argument required to open this database is the path to the file that SQLite will use to save the database.

const db = new sqlite3.Database('./db.sqlite');

This code will create a new database file, in the current folder, named db.sqlite. Then we’ll have a database to interact with!

Instructions

1.

Require the sqlite3 package and save it in a const named sqlite3

2.

Open the database by invoking a new sqlite3.Database and providing the path to your database file (db.sqlite). Assign this to the variable db.

Folder Icon

Sign up to start coding

Already have an account?