sqlite-execute-tag

Execute SQL statements against an sqlite3 database.

Usage no npm install needed!

<script type="module">
  import sqliteExecuteTag from 'https://cdn.skypack.dev/sqlite-execute-tag';
</script>

README

sqlite-execute-tag

Execute SQL statements against an sqlite3 database.

See package sql-execute-tag for the API.

import sqlite3Db from 'sqlite-execute-tag';

const sql = slite3Db('/path/to/database/file.db');

const [row] = await sql`SELECT * FROM my_table LIMIT 1`;
const rows = await sql`SELECT * FROM my_table`;
await sql`INSERT INTO good_numbers (number) VALUES (${69}), (${420}), (${1312})`;