DatabaseSync - sqlite - Node

DatabaseSync - sqlite - Node documentation

class DatabaseSync

Usage in Deno

import { DatabaseSync } from "node:sqlite";

Deno compatibility

This module is not implemented.

This class represents a single connection to a SQLite database. All APIs exposed by this class execute synchronously.

Constructors

new



DatabaseSync(location: string,
options?: DatabaseSyncOptions,
)

Constructs a new DatabaseSync instance.

Methods



close(): void

Closes the database connection. An exception is thrown if the database is not open. This method is a wrapper around sqlite3_close_v2().



exec(sql: string): void

This method allows one or more SQL statements to be executed without returning any results. This method is useful when executing SQL statements read from a file. This method is a wrapper around sqlite3_exec().



open(): void

Opens the database specified in the location argument of the DatabaseSyncconstructor. This method should only be used when the database is not opened via the constructor. An exception is thrown if the database is already open.



prepare(sql: string): StatementSync

Compiles a SQL statement into a prepared statement. This method is a wrapper around sqlite3_prepare_v2().