Synchronous N-API interface to SQLite
npm install @decafcode/sqliteSynchronous N-API interface to SQLite.
The version of SQLite currently bundled with this extension is 3.50.3.
- Statically links its own copy of SQLite for ease of deployment.
- Provides pre-built binaries with its npm distribution packages for ease of
deployment. The current release includes pre-built binaries for the following
JavaScript platforms:
- Node.js on 64-bit Linux
- Node.js on 64-bit Windows
- Node.js on 64-bit macOS
- SQLite INTEGERs are always returned as JavaScript BigInts and JavaScript
numbers are always bound as SQLite REALs. This prevents silent corruption of
large integral values.
- Exposes an N-API
interface to its host JavaScript runtime, which provides improved binary
portability between runtime versions compared to the original Node.js C++
extension API.
To use @decafcode/sqlite from your project simply install it using your
preferred package manager:
``
$ npm install --save @decafcode/sqlite
or
`
$ yarn add @decafcode/sqlite
TypeScript definitions with TSDoc comments are included in the package. You may
also consult the online copy of the
project's Typedoc documentation output.
See INTERNALS.md for details about the internals of this
project.
`typescript
import Database from "@decafcode/sqlite";
function loadEmployees(path: string, departmentId: bigint): Employee[] {
const db = new Database(path);
const stmt = db.prepare(
"select id, name from employee where department_id = ?"
);
const rows = stmt.all([departmentId]);
const objects = new Array();
stmt.close();
for (const row of rows) {
objects.push(new Employee(row.id, row.name));
}
db.close();
return objects;
}
``
MIT