Usage in Deno
import { DatabaseSync } from "node:sqlite";
This module is not implemented.
This class represents a single connection to a SQLite database. All APIs exposed by this class execute synchronously.
DatabaseSync(location: string,options?: DatabaseSyncOptions,)
Constructs a new DatabaseSync instance.
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().