Skip to main content
DatabaseSync - node__sqlite.d.ts - Node documentation
class DatabaseSync

Usage in Deno

```typescript import { DatabaseSync } from "node:node__sqlite.d.ts"; ```
> [!WARNING] Deno compatibility > This module is not implemented. This class represents a single [connection](https://www.sqlite.org/c3ref/sqlite3.html) to a SQLite database. All APIs exposed by this class execute synchronously.

Constructors

new
DatabaseSync(
location: string,
)
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()`](https://www.sqlite.org/c3ref/close.html).
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()`](https://www.sqlite.org/c3ref/exec.html).
open(): void
Opens the database specified in the `location` argument of the `DatabaseSync`constructor. 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](https://www.sqlite.org/c3ref/stmt.html). This method is a wrapper around [`sqlite3_prepare_v2()`](https://www.sqlite.org/c3ref/prepare.html).