@sqltags/sqlite

SqlTags SQLite driver

This is the SQLite driver for the @sqltags/core library.

Please refer to the @sqltags/core project README for more information.

What is SqlTags?

🔧✨ Safely create & execute parameterized SQL queries using template strings.

const [user] = await sql`SELECT * FROM users WHERE id = ${userId}`;

Results in the following query:

SELECT * FROM users WHERE id = ?
-- with parameters: [123]

Installation & Usage

Install:

npm install sqlite3 @sqltags/sqlite

Create a SQLite database connection, then create a SQL tag using the connection:

import s from 'sqlite3';
import { createSqliteTag } from '@sqltags/sqlite';

const db = new s.Database(':memory:');
const sql = createSqliteTag(db);

Query:

const [user] = await sql`SELECT * FROM users WHERE id = ${userId}`;