Database handle. To create a database handle, use open. The resources behind the handle are automatically destroyed when there are no remaining references to the Database, so Squeather provides no close function.

Opens a new Database. The openFlags are used.

Whether to create a new database if it does not already exist.

Whether to use multi-thread mode or serialized mode, see

https://www.sqlite.org/threadsafe.html

It is not possible to use the SQLite single-thread mode.

Whether to use shared cache or private cache mode, see

https://www.sqlite.org/sharedcache.html

Various options when opening a database.

Default settings for OpenFlags, where the writeMode is ReadWrite Create, threadMode is Serialized, cacheMode is Private, and all other flags are set to False.

Opens a new Database, with settings specified with openFlags.

Evaluate one or more SQL statements. There is no way to obtain the results; for that you will need execute or executeNamed. There is no way to use SQL parameters; for that you will need executeNamed.

Various types of SQL data; used both when obtaining query results and when providing named parameters.

Execute a query without any parameters. Executes only one query - there is no need to terminate it with a semicolon, although you can. If you use a semicolon-separated list of queries, only the first query will be run. There is no way to use SQL parameters; for that you will need executeNamed.

Execute a query with named parameters. Executes only one query - there is no need to terminate it with a semicolon, although you can. If you use a semicolon-separated list of queries, only the first query will be run.

Like executeNamed but also returns the names of the columns in addition to the SQL results.

Get the rowid of the most recent successful INSERT.

Count the number of rows modified by the most recent INSERT, UPDATE, or DELETE statement.

Backup source

Backup destination

Use the SQLite backup API to copy the content of one database to another. Can be used to safely copy databases while they are in use, or to copy in-memory databases to or from persistent files.

Statement handle. To create a statement handle, use prepare. The resources behind the Statement are automatically destroyed when there are no remaining references to the Statement, so Squeather provides no finalize function.

Result from applying step to a Statement.

Prepares a statement. The corresponding C SQLite function allows you to pass in a multi-statement SQL text, and retrieve the unused portion for later use. Squeather does not allow this. Squeather will prepare only the first statement.

The number of columns that a given Statement will return. Works regardless of whether step has been applied or not; however, just because this returns a positive value does not mean that step will ever actually return a Row.

Gets the name of a column. The name is the value of the AS clause if it exists, or is an undefined string otherwise.

Gets all column names, in order.

Bind multiple named parameters to a Statement.

Evaluate a prepared statement. Returns Row if the Statement has returned a row of data. In that case, use column or columns to get individual columns or all columns, respectively. Returns Done if there is no data to retrieve. In that case, step should not be called again without first calling reset.

Retrieves a column with a given index from the Statement. Assumes that step was already called and that it returned Row.

Return all available columns, in order, from a Statement on which step returned Row. You should already have applied step.

Retrieves all remaining rows from a Statement. Applies step for you for as many times as needed.

Resets a Statement so it may be re-executed. Does not clear bindings. In SQLite, sqlite3_reset returns an error code if the most recent step statement returned an error. reset does not do this. It does not check the error code returned by sqlite3_reset.

Clears all bindings on the Statement.

Errors produced by the underlying SQLite3 C library.

Errors produced by the Squeather library (as opposed to being caused directly by the underlying SQLite3 C library.)

Exceptions. Squeather indicates all errors (even those arising from possible bugs) by throwing exceptions of this type.

Returns a string which is the version number for SQLite used to build this library. SQLite is embedded into the library, so the only way to change the SQLite version is to recompile the library.