Database.SQLite3.Direct

https://www.sqlite.org/c3ref/open.html

https://www.sqlite.org/c3ref/open.html

https://www.sqlite.org/c3ref/close.html

https://www.sqlite.org/c3ref/errcode.html

https://www.sqlite.org/c3ref/errcode.html

https://www.sqlite.org/c3ref/errcode.html

https://www.sqlite.org/c3ref/extended_result_codes.html

https://www.sqlite.org/c3ref/profile.html

Enable/disable tracing of SQL execution. Tracing can be disabled by setting Nothing as the logger callback.

Warning: If the logger callback throws an exception, your whole program will crash. Enable only for debugging!

https://www.sqlite.org/c3ref/get_autocommit.html

Return True if the connection is in autocommit mode, or False if a transaction started with BEGIN is still active.

Be warned that some errors roll back the transaction automatically, and that ROLLBACK will throw an error if no transaction is active. Use getAutoCommit to avoid such an error:

 autocommit <- getAutoCommit conn
 when (not autocommit) $
     exec conn "ROLLBACK"

https://www.sqlite.org/c3ref/enable_shared_cache.html

Enable or disable shared cache for all future connections.

https://www.sqlite.org/c3ref/exec.html

Like exec, but invoke the callback for each result row.

If the callback throws an exception, it will be rethrown by execWithCallback.

https://www.sqlite.org/c3ref/prepare.html

If the query contains no SQL statements, this returns Right Nothing.

https://www.sqlite.org/c3ref/db_handle.html

https://www.sqlite.org/c3ref/step.html

https://www.sqlite.org/c3ref/step.html

Faster step for statements that don't callback to Haskell functions (e.g. by using custom SQL functions).

https://www.sqlite.org/c3ref/reset.html

Warning:

• If the most recent step call failed, this will return the corresponding error.

• This does not reset the bindings on a prepared statement. Use clearBindings to do that.

https://www.sqlite.org/c3ref/finalize.html

Warning: If the most recent step call failed, this will return the corresponding error.

https://www.sqlite.org/c3ref/clear_bindings.html

Set all parameters in the prepared statement to null.

https://www.sqlite.org/c3ref/sql.html

Return a copy of the original SQL text used to compile the statement.

https://www.sqlite.org/c3ref/bind_parameter_count.html

This returns the index of the largest (rightmost) parameter. Note that this is not necessarily the number of parameters. If numbered parameters like ?5 are used, there may be gaps in the list.

See ParamIndex for more information.

https://www.sqlite.org/c3ref/bind_parameter_name.html

https://www.sqlite.org/c3ref/bind_parameter_index.html

https://www.sqlite.org/c3ref/column_count.html

https://www.sqlite.org/c3ref/column_name.html

https://www.sqlite.org/c3ref/enable_load_extension.html

Enable or disable extension loading.

https://www.sqlite.org/c3ref/last_insert_rowid.html

https://www.sqlite.org/c3ref/changes.html

Return the number of rows that were changed, inserted, or deleted by the most recent INSERT, DELETE, or UPDATE statement.

https://www.sqlite.org/c3ref/total_changes.html

Return the total number of row changes caused by INSERT, DELETE, or UPDATE statements since the Database was opened.

https://sqlite.org/c3ref/create_function.html

Create a custom SQL function or redefine the behavior of an existing function.

Like createFunction except that it creates an aggregate function.

Delete an SQL function (scalar or aggregate).

https://www.sqlite.org/c3ref/create_collation.html

Delete a collation.

https://www.sqlite.org/c3ref/interrupt.html

Cause any pending operation on the Database handle to stop at its earliest opportunity. This simply sets a flag and returns immediately. It does not wait for the pending operation to finish.

You'll need to compile with -threaded for this to do any good. Without -threaded, FFI calls block the whole RTS, meaning interrupt would never run at the same time as step.

https://www.sqlite.org/c3ref/blob_open.html

Open a blob for incremental I/O.

https://www.sqlite.org/c3ref/blob_close.html

https://www.sqlite.org/c3ref/blob_reopen.html

https://www.sqlite.org/c3ref/blob_bytes.html

https://www.sqlite.org/c3ref/blob_read.html

https://www.sqlite.org/c3ref/blob_write.html

https://www.sqlite.org/c3ref/backup_finish.html#sqlite3backupinit

https://www.sqlite.org/c3ref/backup_finish.html#sqlite3backupfinish

https://www.sqlite.org/c3ref/backup_finish.html#sqlite3backupstep

https://www.sqlite.org/c3ref/backup_finish.html#sqlite3backupremaining

https://www.sqlite.org/c3ref/backup_finish.html#sqlite3backuppagecount

https://www.sqlite.org/c3ref/c_blob.html

The context in which a custom SQL function is executed.

The arguments of a custom SQL function.

The type of blob handles used for incremental blob I/O

A handle for an online backup process.