Database.SQLite3

Connection management

open

close

Simple query execution

exec

execPrint

execWithCallback

type ExecCallback

Statement management

prepare

prepareUtf8

step

reset

finalize

clearBindings

Parameter and column information

bindParameterCount

bindParameterName

columnCount

columnName

Binding values to a prepared statement

bindSQLData

bind

bindNamed

bindInt

bindInt64

bindDouble

bindText

bindBlob

bindZeroBlob

bindNull

Reading the result row

column

columns

typedColumns

columnType

columnInt64

columnDouble

columnText

columnBlob

Result statistics

lastInsertRowId

changes

Create custom SQL functions

createFunction

createAggregate

deleteFunction

Extract function arguments

funcArgCount

funcArgType

funcArgInt64

funcArgDouble

funcArgText

funcArgBlob

Set the result of a function

funcResultSQLData

funcResultInt64

funcResultDouble

funcResultText

funcResultBlob

funcResultZeroBlob

funcResultNull

getFuncContextDatabase

Create custom collations

createCollation

deleteCollation

Interrupting a long-running query

interrupt

interruptibly

Incremental blob I/O

blobOpen

blobClose

blobReopen

blobBytes

blobRead

blobReadBuf

blobWrite

Online Backup API

backupInit

backupFinish

backupStep

backupRemaining

backupPagecount

Types

data Database

data Statement

data SQLData

data SQLError

data ColumnType

data FuncContext

data FuncArgs

data Blob

data Backup

Results and errors

data StepResult

data BackupStepResult

data Error

Special integers

data ParamIndex

data ColumnIndex

type ColumnCount

data ArgCount

type ArgIndex