Class sqlite3
Lightweight SQLite database interface
This module is only available from web process Lua states.
This module provides Lua access to SQLite databases. These are used
for a number of purposes by the default modules, including storing
user bookmarks, cookies, and browsing history.
Opening a database
To create a new sqlite3 instance and connect to a database, use the
sqlite3 constructor:
local db = sqlite3{ filename = "path/to/database.db" }
Methods
Compile and execute the SQL query string query against the database.
The sqlite3 instance must have been opened successfully.
Parameters
-
A SQL query, comprised of one or more SQL statements.
-
bindings
Type: table
Optional
Default:
{}
A table of values to bind to each SQL statement.
Return Values
-
table
A table representing the query result.
Close a database and release related resources.
Compile a SQL statement into a newly-created sqlite3::statement instance.
Parameters
Return Values
-
sqlite3::statement
A newly-created instance representing a compiled statement.
Get the number of rows that were added, removed, or changed by the
most recently executed INSERT, UPDATE or DELETE statement.
Return Values
-
number
The number of modified rows.
Properties
The path to the database that the sqlite3 instance is connected to.
Attribution