SQLite Client for Node.js Apps

Installation

Install `sqlite3`

Install `sqlite`

Usage

Opening the database

Without caching

With caching

Enable verbose / debug mode

Tracing SQL errors

With a custom driver

Opening multiple databases

`open` config params

Getting a single row

Getting many rows

Inserting rows

Updating rows

Prepared statement

`each()`

Get the driver instance

Closing the database

ES6 tagged template strings

Migrations

Typescript tricks

Import interfaces from sqlite

Specify typings for a specific database driver

Use generics to get better typings on your rows

Get example

All example

API Documentation

Management Tools

Alternative SQLite libraries

References

License