CREATE SQLITE DATABASE NODE JS HOW TO

If an error occurred, the error object is not null, otherwise, it is null. The callback function has the error object as the first parameter. The sqlite3.Database() accepts a callback function that will be called when the database opened successfully or when an error occurred. The sqlite3.Database() returns a Database object and opens the database connection automatically. Second, create a Database object: let db = new sqlite3.Database( ':memory:') Code language: JavaScript ( javascript )

Notice that the execution mode is set to verbose to produce long stack traces. To open a database connection to an in-memory database, you use the following steps.įirst, import the sqlite3 module: const sqlite3 = require( 'sqlite3').verbose() Code language: JavaScript ( javascript ) Second, call the Database() function of the sqlite3 module and pass the database information such as database file, opening mode, and a callback function.To connect to an SQLite database, you need to: You can use npm to do so using the following command: > npm install sqlite3 Code language: JavaScript ( javascript )Īfter installing the sqlite3 module, you are ready to connect to an SQLite database from a Node.js application. To interact with the SQLite database, you need to download and install sqlite3 module.

CREATE SQLITE DATABASE NODE JS HOW TO

Summary: in this tutorial, you will learn how to connect to an SQLite database from Node.js applications.

Create sqlite database node js