@sqlbraid/sqlite

SQLite dialect and adapters for many JavaScript environments.

npm install @sqlbraid/sqlite

Use the adapter subpath for your environment. This table shows each granular package path and the equivalent sqlbraid facade path:

| Adapter | @sqlbraid/sqlite import | sqlbraid facade import | Physical API and notes | | :------------- | :-------------------------------- | :------------------------ | :-------------------------------------------------------------------------------- | | Node SQLite | @sqlbraid/sqlite/node-sqlite | sqlbraid/node-sqlite | Node DatabaseSync; synchronous calls; exact INTEGER strings; native iterate() | | better-sqlite3 | @sqlbraid/sqlite/better-sqlite3 | sqlbraid/better-sqlite3 | Synchronous and event-loop blocking; safeIntegers(true); native iteration | | libSQL | @sqlbraid/sqlite/libsql | sqlbraid/libsql | @libsql/client; requires intMode: "string"; no stream fallback | | SQLite WASM | @sqlbraid/sqlite/wasm | sqlbraid/sqlite-wasm | SQLite WASM OO1 | | Cloudflare D1 | @sqlbraid/sqlite/d1 | sqlbraid/d1 | Cloudflare Workers |

If the adapter needs an external driver or client, install it separately. node:sqlite is part of Node. The Worker runtime supplies Cloudflare D1.

The package root @sqlbraid/sqlite gives the SQLite dialect. The optional @sqlbraid/sqlite/inspector subpath gives metadata inspection. It requires the optional @sqlbraid/metadata peer. It is not a query adapter.

Key Details

• Data types: Exact INTEGER values are decimal strings when the selected adapter supports this. This prevents loss of precision.
• Async API: All adapters use the same async Database API. This is also true when the driver is synchronous.

See the SQLBraid documentation for details.

See the full package map and driver support matrix.