Database.SQLite3.Bindings.Types

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

CDatabase = sqlite3

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

CStatement = sqlite3_stmt

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

CValue = sqlite3_value

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

CContext = sqlite3_context

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

CBlob = sqlite3_blob

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

CBackup = sqlite3_backup

Index of a parameter in a parameterized query. Parameter indices start from 1.

When a query is prepared, SQLite allocates an array indexed from 1 to the highest parameter index. For example:

>Right stmt <- prepare conn "SELECT ?1, ?5, ?3, ?"
>bindParameterCount stmt
ParamIndex 6

This will allocate an array indexed from 1 to 6 (? takes the highest preceding index plus one). The array is initialized with null values. When you bind a parameter with bindSQLData, it assigns a new value to one of these indices.

See https://www.sqlite.org/lang_expr.html#varparam for the syntax of parameter placeholders, and how parameter indices are assigned.

Index of a column in a result set. Column indices start from 0.

Number of columns in a result set.

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

Ptr CDestructor = sqlite3_destructor_type

Tells SQLite3 that the content pointer is constant and will never change

Tells SQLite3 to make its own private copy of the data

Number of arguments of a user defined SQL function.

Index of an argument to a custom function. Indices start from 0.

Tells SQLite3 that the defined custom SQL function is deterministic.

The Database.SQLite3 and Database.SQLite3.Direct modules use higher-level representations of some types than those used in the FFI signatures (Database.SQLite3.Bindings). This typeclass helps with the conversions.