sqlite

Connecting JavaScript and SQLite with ADBC

Instructions

Prerequisites

1. Install Node.js (version 22 or later)

   • Alternatively, you can use Bun or Deno

2. Install dbc

3. Install SQLite

   • On macOS, if you have Homebrew installed, run brew install sqlite

Connect to SQLite

1. Install the SQLite ADBC driver:

   dbc install sqlite

2. Install dependencies:

   npm --prefix .. install

3. Customize the script main.js as needed

   • Change the uri in databaseOptions to the location of the SQLite database file you want to query, or keep it set to games.sqlite to use the database file included with this example
   • If you changed the database file, also change the SQL SELECT statement in conn.query()

4. Run the script:

   Node.js:

   node main.js

   Bun:

   bun run main.js

   Deno:

   deno run --allow-ffi --allow-env main.js