fastify-sqlite

Fastify plugin to connect to a SQLite3 database. Under the hood, this plugin uses sqlite3.

Install

npm install fastify-sqlite

Compatibility

Plugin version	Fastify version
^1.0.0	^4.0.0

Usage

1const fastifySqlite = require('fastify-sqlite')
2
3async function main () {
4  const app = fastify()
5  app.register(fastifySqlite, {
6    dbFile: 'foo.db'
7  })
8  await app.ready()
9
10  app.sqlite.all('SELECT * FROM myTable', (err, rows) => {
11    // do something
12  })
13}
14main()

Checkout the sqlite3 documentation to see all the available methods.

Note that Promise APIs are not supported by the sqlite3 module by default. By using the promiseApi option, the sqlite wrapper will be used to enhance the Database instance. It has many convenient utilities such as migration support.

Options

You can pass the following options to the plugin:

1await app.register(require('fastify-sqlite'), {
2  promiseApi: true, // the DB instance supports the Promise API. Default false
3  name: 'mydb', // optional decorator name. Default null
4  verbose: true, // log sqlite3 queries as trace. Default false
5  dbFile: ':memory:', // select the database file. Default ':memory:'
6  mode: fastifySqlite.sqlite3.OPEN_READONLY 
7    // how to connecto to the DB, Default: OPEN_READWRITE | OPEN_CREATE | OPEN_FULLMUTEX
8})
9
10// usage WITH name option
11await app.sqlite.myDb.all('SELECT * FROM myTable')

License

Copyright Manuel Spigolon, Licensed under MIT.