Database.SQLite.Simple

Examples of use

The Query type

Parameter substitution

Positional parameters

Named parameters

Type inference

Substituting a single parameter

Extracting results

Handling null values

Type conversions

Conversion to/from UTCTime

data Query

data Connection

class ToRow a

class FromRow a

data Only a

data h :. t

data SQLData

data Statement

data ColumnIndex

data NamedParam

Connections

open

close

withConnection

setTrace

Queries that return results

query

query_

queryWith

queryWith_

queryNamed

lastInsertRowId

changes

totalChanges

Queries that stream results

fold

fold_

foldNamed

Statements that do not return results

execute

execute_

executeMany

executeNamed

field

Transactions

withTransaction

withImmediateTransaction

withExclusiveTransaction

Low-level statement API for stream access and prepared statements

openStatement

closeStatement

withStatement

bind

bindNamed

reset

columnName

columnCount

withBind

nextRow

Exceptions

data FormatError

data ResultError

data SQLError

data Error