Database.SQLite.Simple

Examples of use

The Query type

Parameter substitution

Type inference

Substituting a single parameter

Extracting results

Handling null values

Type conversions

data Query

data Connection

class ToRow a

class FromRow a

data Only a

data h :. t

data SQLData

data Statement

data ColumnIndex

Connections

open

close

withConnection

setTrace

Queries that return results

query

query_

lastInsertRowId

Statements that do not return results

execute

execute_

field

fold

fold_

Low-level statement API for stream access and prepared statements

openStatement

closeStatement

withStatement

bind

reset

columnName

withBind

nextRow

Exceptions

data FormatError

data ResultError