@sqltags/sqlite
v0.0.26
Published
SQLite driver for sqltags (@sqltags/core) 🔧✨ Safely create & execute parameterized SQL queries using template strings
Downloads
10
Maintainers
Readme
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}`;