Constructs a new DatabaseSync
instance.
constructor
sqlite.DatabaseSync.constructor
Not implemented in Bun
The path of the database. A SQLite database can be stored in a file or completely in memory. To use a file-backed database, the path should be a file path. To use an in-memory database, the path should be the special name ':memory:'
.
Configuration options for the database connection.
Referenced types
class URL
The URL interface represents an object providing static methods used for creating object URLs.
The
toString()
method on theURL
object returns the serialized URL. The value returned is equivalent to that of href and toJSON.
interface DatabaseSyncOptions
- allowExtension?: boolean
If
true
, theloadExtension
SQL function and theloadExtension()
method are enabled. You can callenableLoadExtension(false)
later to disable this feature. - enableDoubleQuotedStringLiterals?: boolean
If
true
, SQLite will accept double-quoted string literals. This is not recommended but can be enabled for compatibility with legacy database schemas. - enableForeignKeyConstraints?: boolean
If
true
, foreign key constraints are enabled. This is recommended but can be disabled for compatibility with legacy database schemas. The enforcement of foreign key constraints can be enabled and disabled after opening the database usingPRAGMA foreign_keys
. - open?: boolean
If
true
, the database is opened by the constructor. When this value isfalse
, the database must be opened via theopen()
method. - readOnly?: boolean
If
true
, the database is opened in read-only mode. If the database does not exist, opening it will fail. - timeout?: number
The busy timeout in milliseconds. This is the maximum amount of time that SQLite will wait for a database lock to be released before returning an error.
class DatabaseSync
This class represents a single connection to a SQLite database. All APIs exposed by this class execute synchronously.
- readonly isTransaction: boolean
Whether the database is currently within a transaction. This method is a wrapper around
sqlite3_get_autocommit()
. Closes the database connection. If the database connection is already closed then this is a no-op.
- name: string,): void;
Registers a new aggregate function with the SQLite database. This method is a wrapper around
sqlite3_create_window_function()
.When used as a window function, the
result
function will be called multiple times.import { DatabaseSync } from 'node:sqlite'; const db = new DatabaseSync(':memory:'); db.exec(` CREATE TABLE t3(x, y); INSERT INTO t3 VALUES ('a', 4), ('b', 5), ('c', 3), ('d', 8), ('e', 1); `); db.aggregate('sumint', { start: 0, step: (acc, value) => acc + value, }); db.prepare('SELECT sumint(y) as total FROM t3').get(); // { total: 21 }
@param nameThe name of the SQLite function to create.
@param optionsFunction configuration settings.
name: string,): void;Registers a new aggregate function with the SQLite database. This method is a wrapper around
sqlite3_create_window_function()
.When used as a window function, the
result
function will be called multiple times.import { DatabaseSync } from 'node:sqlite'; const db = new DatabaseSync(':memory:'); db.exec(` CREATE TABLE t3(x, y); INSERT INTO t3 VALUES ('a', 4), ('b', 5), ('c', 3), ('d', 8), ('e', 1); `); db.aggregate('sumint', { start: 0, step: (acc, value) => acc + value, }); db.prepare('SELECT sumint(y) as total FROM t3').get(); // { total: 21 }
@param nameThe name of the SQLite function to create.
@param optionsFunction configuration settings.
- ): boolean;
An exception is thrown if the database is not open. This method is a wrapper around
sqlite3changeset_apply()
.const sourceDb = new DatabaseSync(':memory:'); const targetDb = new DatabaseSync(':memory:'); sourceDb.exec('CREATE TABLE data(key INTEGER PRIMARY KEY, value TEXT)'); targetDb.exec('CREATE TABLE data(key INTEGER PRIMARY KEY, value TEXT)'); const session = sourceDb.createSession(); const insert = sourceDb.prepare('INSERT INTO data (key, value) VALUES (?, ?)'); insert.run(1, 'hello'); insert.run(2, 'world'); const changeset = session.changeset(); targetDb.applyChangeset(changeset); // Now that the changeset has been applied, targetDb contains the same data as sourceDb.
@param changesetA binary changeset or patchset.
@param optionsThe configuration options for how the changes will be applied.
@returnsWhether the changeset was applied successfully without being aborted.
Closes the database connection. An exception is thrown if the database is not open. This method is a wrapper around
sqlite3_close_v2()
.Creates and attaches a session to the database. This method is a wrapper around
sqlite3session_create()
andsqlite3session_attach()
.@param optionsThe configuration options for the session.
@returnsA session handle.
- allow: boolean): void;
Enables or disables the
loadExtension
SQL function, and theloadExtension()
method. WhenallowExtension
isfalse
when constructing, you cannot enable loading extensions for security reasons.@param allowWhether to allow loading extensions.
- 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()
.@param sqlA SQL string to execute.
- name: string,): void;
This method is used to create SQLite user-defined functions. This method is a wrapper around
sqlite3_create_function_v2()
.@param nameThe name of the SQLite function to create.
@param optionsOptional configuration settings for the function.
@param funcThe JavaScript function to call when the SQLite function is invoked. The return value of this function should be a valid SQLite data type: see Type conversion between JavaScript and SQLite. The result defaults to
NULL
if the return value isundefined
.name: string,): void;This method is used to create SQLite user-defined functions. This method is a wrapper around
sqlite3_create_function_v2()
.@param nameThe name of the SQLite function to create.
@param funcThe JavaScript function to call when the SQLite function is invoked. The return value of this function should be a valid SQLite data type: see Type conversion between JavaScript and SQLite. The result defaults to
NULL
if the return value isundefined
. - path: string): void;
Loads a shared library into the database connection. This method is a wrapper around
sqlite3_load_extension()
. It is required to enable theallowExtension
option when constructing theDatabaseSync
instance.@param pathThe path to the shared library to load.
- @param dbName
Name of the database. This can be
'main'
(the default primary database) or any other database that has been added withATTACH DATABASE
Default:'main'
.@returnsThe location of the database file. When using an in-memory database, this method returns null.
Opens the database specified in the
path
argument of theDatabaseSync
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.- sql: string
Compiles a SQL statement into a prepared statement. This method is a wrapper around
sqlite3_prepare_v2()
.@param sqlA SQL string to compile to a prepared statement.
@returnsThe prepared statement.