SQLite3

Description

sealed class Tinman.AddOns.SQLite.SQLite3

Derived from: NativeLibrary ^abstract

Full source code is included in the Tinman 3D SDK download.

A partial wrapper around the C-language Interface Specification for SQLite.
https://sqlite.org/c3ref/intro.html

The extension methods prefixed with Api* are convenience helpers that delegate to the plain SQLite functions while doing error handling. The DatasetFile, PreparedStatement and StatementCollection classes provide a simple high-level API on top of the plain SQLite functions.

See also: TinmanAddOnsModule.NativeLibraryDisable

Public / Constants

ABORT

public constant ABORT → (4:int32)

SQLITE_ABORT
https://sqlite.org/rescode.html#abort

ABORT_ROLLBACK

public constant ABORT_ROLLBACK → (516:int32)

SQLITE_ABORT_ROLLBACK
https://sqlite.org/rescode.html#abort_rollback

AUTH

public constant AUTH → (23:int32)

SQLITE_AUTH
https://sqlite.org/rescode.html#auth

AUTH_USER

public constant AUTH_USER → (279:int32)

SQLITE_AUTH_USER
https://sqlite.org/rescode.html#auth_user

BLOB

public constant BLOB → (4:int32)

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

BUSY

public constant BUSY → (5:int32)

SQLITE_BUSY
https://sqlite.org/rescode.html#busy

BUSY_RECOVERY

public constant BUSY_RECOVERY → (261:int32)

SQLITE_BUSY_RECOVERY
https://sqlite.org/rescode.html#busy_recovery

BUSY_SNAPSHOT

public constant BUSY_SNAPSHOT → (517:int32)

SQLITE_BUSY_SNAPSHOT
https://sqlite.org/rescode.html#busy_snapshot

BUSY_TIMEOUT

public constant BUSY_TIMEOUT → (773:int32)

SQLITE_BUSY_TIMEOUT
https://sqlite.org/rescode.html#busy_timeout

CANTOPEN

public constant CANTOPEN → (14:int32)

SQLITE_CANTOPEN
https://sqlite.org/rescode.html#cantopen

CANTOPEN_CONVPATH

public constant CANTOPEN_CONVPATH → (1038:int32)

SQLITE_CANTOPEN_CONVPATH
https://sqlite.org/rescode.html#cantopen_convpath

CANTOPEN_DIRTYWAL

public constant CANTOPEN_DIRTYWAL → (1294:int32)

SQLITE_CANTOPEN_DIRTYWAL
https://sqlite.org/rescode.html#cantopen_dirtywal

CANTOPEN_FULLPATH

public constant CANTOPEN_FULLPATH → (782:int32)

SQLITE_CANTOPEN_FULLPATH
https://sqlite.org/rescode.html#cantopen_fullpath

CANTOPEN_ISDIR

public constant CANTOPEN_ISDIR → (526:int32)

SQLITE_CANTOPEN_ISDIR
https://sqlite.org/rescode.html#cantopen_isdir

CANTOPEN_NOTEMPDIR

public constant CANTOPEN_NOTEMPDIR → (270:int32)

SQLITE_CANTOPEN_NOTEMPDIR
https://sqlite.org/rescode.html#cantopen_notempdir

CANTOPEN_SYMLINK

public constant CANTOPEN_SYMLINK → (1550:int32)

SQLITE_CANTOPEN_SYMLINK
https://sqlite.org/rescode.html#cantopen_symlink

CONFIG_MULTITHREAD

public constant CONFIG_MULTITHREAD → (2:int32)

SQLITE_CONFIG_MULTITHREAD
https://sqlite.org/c3ref/c_config_covering_index_scan.html

CONFIG_SERIALIZED

public constant CONFIG_SERIALIZED → (3:int32)

SQLITE_CONFIG_SERIALIZED
https://sqlite.org/c3ref/c_config_covering_index_scan.html

CONFIG_SINGLETHREAD

public constant CONFIG_SINGLETHREAD → (1:int32)

SQLITE_CONFIG_SINGLETHREAD
https://sqlite.org/c3ref/c_config_covering_index_scan.html

CONSTRAINT

public constant CONSTRAINT → (19:int32)

SQLITE_CONSTRAINT
https://sqlite.org/rescode.html#constraint

CONSTRAINT_CHECK

public constant CONSTRAINT_CHECK → (275:int32)

SQLITE_CONSTRAINT_CHECK
https://sqlite.org/rescode.html#constraint_check

CONSTRAINT_COMMITHOOK

public constant CONSTRAINT_COMMITHOOK → (531:int32)

SQLITE_CONSTRAINT_COMMITHOOK
https://sqlite.org/rescode.html#constraint_commithook

CONSTRAINT_DATATYPE

public constant CONSTRAINT_DATATYPE → (3091:int32)

SQLITE_CONSTRAINT_DATATYPE
https://sqlite.org/rescode.html#constraint_datatype

CONSTRAINT_FOREIGNKEY

public constant CONSTRAINT_FOREIGNKEY → (787:int32)

SQLITE_CONSTRAINT_FOREIGNKEY
https://sqlite.org/rescode.html#constraint_foreignkey

CONSTRAINT_FUNCTION

public constant CONSTRAINT_FUNCTION → (1043:int32)

SQLITE_CONSTRAINT_FUNCTION
https://sqlite.org/rescode.html#constraint_function

CONSTRAINT_NOTNULL

public constant CONSTRAINT_NOTNULL → (1299:int32)

SQLITE_CONSTRAINT_NOTNULL
https://sqlite.org/rescode.html#constraint_notnull

CONSTRAINT_PINNED

public constant CONSTRAINT_PINNED → (2835:int32)

SQLITE_CONSTRAINT_PINNED
https://sqlite.org/rescode.html#constraint_pinned

CONSTRAINT_PRIMARYKEY

public constant CONSTRAINT_PRIMARYKEY → (1555:int32)

SQLITE_CONSTRAINT_PRIMARYKEY
https://sqlite.org/rescode.html#constraint_primarykey

CONSTRAINT_ROWID

public constant CONSTRAINT_ROWID → (2579:int32)

SQLITE_CONSTRAINT_ROWID
https://sqlite.org/rescode.html#constraint_rowid

CONSTRAINT_TRIGGER

public constant CONSTRAINT_TRIGGER → (1811:int32)

SQLITE_CONSTRAINT_TRIGGER
https://sqlite.org/rescode.html#constraint_trigger

CONSTRAINT_UNIQUE

public constant CONSTRAINT_UNIQUE → (2067:int32)

SQLITE_CONSTRAINT_UNIQUE
https://sqlite.org/rescode.html#constraint_unique

CONSTRAINT_VTAB

public constant CONSTRAINT_VTAB → (2323:int32)

SQLITE_CONSTRAINT_VTAB
https://sqlite.org/rescode.html#constraint_vtab

CORRUPT

public constant CORRUPT → (11:int32)

SQLITE_CORRUPT
https://sqlite.org/rescode.html#corrupt

CORRUPT_INDEX

public constant CORRUPT_INDEX → (779:int32)

SQLITE_CORRUPT_INDEX
https://sqlite.org/rescode.html#corrupt_index

CORRUPT_SEQUENCE

public constant CORRUPT_SEQUENCE → (523:int32)

SQLITE_CORRUPT_SEQUENCE
https://sqlite.org/rescode.html#corrupt_sequence

CORRUPT_VTAB

public constant CORRUPT_VTAB → (267:int32)

SQLITE_CORRUPT_VTAB
https://sqlite.org/rescode.html#corrupt_vtab

DBSTATUS_CACHE_HIT

public constant DBSTATUS_CACHE_HIT → (7:int32)

SQLITE_DBSTATUS_CACHE_HIT
https://sqlite.org/c3ref/c_dbstatus_options.html

DBSTATUS_CACHE_MISS

public constant DBSTATUS_CACHE_MISS → (8:int32)

SQLITE_DBSTATUS_CACHE_MISS
https://sqlite.org/c3ref/c_dbstatus_options.html

DBSTATUS_CACHE_SPILL

public constant DBSTATUS_CACHE_SPILL → (12:int32)

SQLITE_DBSTATUS_CACHE_SPILL
https://sqlite.org/c3ref/c_dbstatus_options.html

DBSTATUS_CACHE_USED

public constant DBSTATUS_CACHE_USED → (1:int32)

SQLITE_DBSTATUS_CACHE_USED
https://sqlite.org/c3ref/c_dbstatus_options.html

DBSTATUS_CACHE_USED_SHARED

public constant DBSTATUS_CACHE_USED_SHARED → (11:int32)

SQLITE_DBSTATUS_CACHE_USED_SHARED
https://sqlite.org/c3ref/c_dbstatus_options.html

DBSTATUS_CACHE_WRITE

public constant DBSTATUS_CACHE_WRITE → (9:int32)

SQLITE_DBSTATUS_CACHE_WRITE
https://sqlite.org/c3ref/c_dbstatus_options.html

DBSTATUS_DEFERRED_FKS

public constant DBSTATUS_DEFERRED_FKS → (10:int32)

SQLITE_DBSTATUS_DEFERRED_FKS
https://sqlite.org/c3ref/c_dbstatus_options.html

DBSTATUS_LOOKASIDE_HIT

public constant DBSTATUS_LOOKASIDE_HIT → (4:int32)

SQLITE_DBSTATUS_LOOKASIDE_HIT
https://sqlite.org/c3ref/c_dbstatus_options.html

DBSTATUS_LOOKASIDE_MISS_FULL

public constant DBSTATUS_LOOKASIDE_MISS_FULL → (6:int32)

SQLITE_DBSTATUS_LOOKASIDE_MISS_FULL
https://sqlite.org/c3ref/c_dbstatus_options.html

DBSTATUS_LOOKASIDE_MISS_SIZE

public constant DBSTATUS_LOOKASIDE_MISS_SIZE → (5:int32)

SQLITE_DBSTATUS_LOOKASIDE_MISS_SIZE
https://sqlite.org/c3ref/c_dbstatus_options.html

DBSTATUS_LOOKASIDE_USED

public constant DBSTATUS_LOOKASIDE_USED → (0:int32)

SQLITE_DBSTATUS_LOOKASIDE_USED
https://sqlite.org/c3ref/c_dbstatus_options.html

DBSTATUS_SCHEMA_USED

public constant DBSTATUS_SCHEMA_USED → (2:int32)

SQLITE_DBSTATUS_SCHEMA_USED
https://sqlite.org/c3ref/c_dbstatus_options.html

DBSTATUS_STMT_USED

public constant DBSTATUS_STMT_USED → (3:int32)

SQLITE_DBSTATUS_STMT_USED
https://sqlite.org/c3ref/c_dbstatus_options.html

DONE

public constant DONE → (101:int32)

SQLITE_DONE
https://sqlite.org/rescode.html#done

EMPTY

public constant EMPTY → (16:int32)

SQLITE_EMPTY
https://sqlite.org/rescode.html#empty

ERROR

public constant ERROR → (1:int32)

SQLITE_ERROR
https://sqlite.org/rescode.html#error

ERROR_MISSING_COLLSEQ

public constant ERROR_MISSING_COLLSEQ → (257:int32)

SQLITE_ERROR_MISSING_COLLSEQ
https://sqlite.org/rescode.html#error_missing_collseq

ERROR_RETRY

public constant ERROR_RETRY → (513:int32)

SQLITE_ERROR_RETRY
https://sqlite.org/rescode.html#error_retry

ERROR_SNAPSHOT

public constant ERROR_SNAPSHOT → (769:int32)

SQLITE_ERROR_SNAPSHOT
https://sqlite.org/rescode.html#error_snapshot

FLOAT

public constant FLOAT → (2:int32)

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

FORMAT

public constant FORMAT → (24:int32)

SQLITE_FORMAT
https://sqlite.org/rescode.html#format

FULL

public constant FULL → (13:int32)

SQLITE_FULL
https://sqlite.org/rescode.html#full

INTEGER

public constant INTEGER → (1:int32)

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

INTERNAL

public constant INTERNAL → (2:int32)

SQLITE_INTERNAL
https://sqlite.org/rescode.html#internal

INTERRUPT

public constant INTERRUPT → (9:int32)

SQLITE_INTERRUPT
https://sqlite.org/rescode.html#interrupt

IOERR

public constant IOERR → (10:int32)

SQLITE_IOERR
https://sqlite.org/rescode.html#ioerr

IOERR_ACCESS

public constant IOERR_ACCESS → (3338:int32)

SQLITE_IOERR_ACCESS
https://sqlite.org/rescode.html#ioerr_access

IOERR_AUTH

public constant IOERR_AUTH → (7178:int32)

SQLITE_IOERR_AUTH
https://sqlite.org/rescode.html#ioerr_auth

IOERR_BEGIN_ATOMIC

public constant IOERR_BEGIN_ATOMIC → (7434:int32)

SQLITE_IOERR_BEGIN_ATOMIC
https://sqlite.org/rescode.html#ioerr_begin_atomic

IOERR_BLOCKED

public constant IOERR_BLOCKED → (2826:int32)

SQLITE_IOERR_BLOCKED
https://sqlite.org/rescode.html#ioerr_blocked

IOERR_CHECKRESERVEDLOCK

public constant IOERR_CHECKRESERVEDLOCK → (3594:int32)

SQLITE_IOERR_CHECKRESERVEDLOCK
https://sqlite.org/rescode.html#ioerr_checkreservedlock

IOERR_CLOSE

public constant IOERR_CLOSE → (4106:int32)

SQLITE_IOERR_CLOSE
https://sqlite.org/rescode.html#ioerr_close

IOERR_COMMIT_ATOMIC

public constant IOERR_COMMIT_ATOMIC → (7690:int32)

SQLITE_IOERR_COMMIT_ATOMIC
https://sqlite.org/rescode.html#ioerr_commit_atomic

IOERR_CONVPATH

public constant IOERR_CONVPATH → (6666:int32)

SQLITE_IOERR_CONVPATH
https://sqlite.org/rescode.html#ioerr_convpath

IOERR_CORRUPTFS

public constant IOERR_CORRUPTFS → (8458:int32)

SQLITE_IOERR_CORRUPTFS
https://sqlite.org/rescode.html#ioerr_corruptfs

IOERR_DATA

public constant IOERR_DATA → (8202:int32)

SQLITE_IOERR_DATA
https://sqlite.org/rescode.html#ioerr_data

IOERR_DELETE

public constant IOERR_DELETE → (2570:int32)

SQLITE_IOERR_DELETE
https://sqlite.org/rescode.html#ioerr_delete

IOERR_DELETE_NOENT

public constant IOERR_DELETE_NOENT → (5898:int32)

SQLITE_IOERR_DELETE_NOENT
https://sqlite.org/rescode.html#ioerr_delete_noent

IOERR_DIR_CLOSE

public constant IOERR_DIR_CLOSE → (4362:int32)

SQLITE_IOERR_DIR_CLOSE
https://sqlite.org/rescode.html#ioerr_dir_close

IOERR_DIR_FSYNC

public constant IOERR_DIR_FSYNC → (1290:int32)

SQLITE_IOERR_DIR_FSYNC
https://sqlite.org/rescode.html#ioerr_dir_fsync

IOERR_FSTAT

public constant IOERR_FSTAT → (1802:int32)

SQLITE_IOERR_FSTAT
https://sqlite.org/rescode.html#ioerr_fstat

IOERR_FSYNC

public constant IOERR_FSYNC → (1034:int32)

SQLITE_IOERR_FSYNC
https://sqlite.org/rescode.html#ioerr_fsync

IOERR_GETTEMPPATH

public constant IOERR_GETTEMPPATH → (6410:int32)

SQLITE_IOERR_GETTEMPPATH
https://sqlite.org/rescode.html#ioerr_gettemppath

IOERR_LOCK

public constant IOERR_LOCK → (3850:int32)

SQLITE_IOERR_LOCK
https://sqlite.org/rescode.html#ioerr_lock

IOERR_MMAP

public constant IOERR_MMAP → (6154:int32)

SQLITE_IOERR_MMAP
https://sqlite.org/rescode.html#ioerr_mmap

IOERR_NOMEM

public constant IOERR_NOMEM → (3082:int32)

SQLITE_IOERR_NOMEM
https://sqlite.org/rescode.html#ioerr_nomem

IOERR_RDLOCK

public constant IOERR_RDLOCK → (2314:int32)

SQLITE_IOERR_RDLOCK
https://sqlite.org/rescode.html#ioerr_rdlock

IOERR_READ

public constant IOERR_READ → (266:int32)

SQLITE_IOERR_READ
https://sqlite.org/rescode.html#ioerr_read

IOERR_ROLLBACK_ATOMIC

public constant IOERR_ROLLBACK_ATOMIC → (7946:int32)

SQLITE_IOERR_ROLLBACK_ATOMIC
https://sqlite.org/rescode.html#ioerr_rollback_atomic

IOERR_SEEK

public constant IOERR_SEEK → (5642:int32)

SQLITE_IOERR_SEEK
https://sqlite.org/rescode.html#ioerr_seek

IOERR_SHMLOCK

public constant IOERR_SHMLOCK → (5130:int32)

SQLITE_IOERR_SHMLOCK
https://sqlite.org/rescode.html#ioerr_shmlock

IOERR_SHMMAP

public constant IOERR_SHMMAP → (5386:int32)

SQLITE_IOERR_SHMMAP
https://sqlite.org/rescode.html#ioerr_shmmap

IOERR_SHMOPEN

public constant IOERR_SHMOPEN → (4618:int32)

SQLITE_IOERR_SHMOPEN
https://sqlite.org/rescode.html#ioerr_shmopen

IOERR_SHMSIZE

public constant IOERR_SHMSIZE → (4874:int32)

SQLITE_IOERR_SHMSIZE
https://sqlite.org/rescode.html#ioerr_shmsize

IOERR_SHORT_READ

public constant IOERR_SHORT_READ → (522:int32)

SQLITE_IOERR_SHORT_READ
https://sqlite.org/rescode.html#ioerr_short_read

IOERR_TRUNCATE

public constant IOERR_TRUNCATE → (1546:int32)

SQLITE_IOERR_TRUNCATE
https://sqlite.org/rescode.html#ioerr_truncate

IOERR_UNLOCK

public constant IOERR_UNLOCK → (2058:int32)

SQLITE_IOERR_UNLOCK
https://sqlite.org/rescode.html#ioerr_unlock

IOERR_VNODE

public constant IOERR_VNODE → (6922:int32)

SQLITE_IOERR_VNODE
https://sqlite.org/rescode.html#ioerr_vnode

IOERR_WRITE

public constant IOERR_WRITE → (778:int32)

SQLITE_IOERR_WRITE
https://sqlite.org/rescode.html#ioerr_write

LIMIT_ATTACHED

public constant LIMIT_ATTACHED → (7:int32)

SQLITE_LIMIT_ATTACHED
https://sqlite.org/c3ref/c_limit_attached.html

LIMIT_COLUMN

public constant LIMIT_COLUMN → (2:int32)

SQLITE_LIMIT_COLUMN
https://sqlite.org/c3ref/c_limit_attached.html

LIMIT_COMPOUND_SELECT

public constant LIMIT_COMPOUND_SELECT → (4:int32)

SQLITE_LIMIT_COMPOUND_SELECT
https://sqlite.org/c3ref/c_limit_attached.html

LIMIT_EXPR_DEPTH

public constant LIMIT_EXPR_DEPTH → (3:int32)

SQLITE_LIMIT_EXPR_DEPTH
https://sqlite.org/c3ref/c_limit_attached.html

LIMIT_FUNCTION_ARG

public constant LIMIT_FUNCTION_ARG → (6:int32)

SQLITE_LIMIT_FUNCTION_ARG
https://sqlite.org/c3ref/c_limit_attached.html

LIMIT_LENGTH

public constant LIMIT_LENGTH → (0:int32)

SQLITE_LIMIT_LENGTH
https://sqlite.org/c3ref/c_limit_attached.html

LIMIT_LIKE_PATTERN_LENGTH

public constant LIMIT_LIKE_PATTERN_LENGTH → (8:int32)

SQLITE_LIMIT_LIKE_PATTERN_LENGTH
https://sqlite.org/c3ref/c_limit_attached.html

LIMIT_SQL_LENGTH

public constant LIMIT_SQL_LENGTH → (1:int32)

SQLITE_LIMIT_SQL_LENGTH
https://sqlite.org/c3ref/c_limit_attached.html

LIMIT_TRIGGER_DEPTH

public constant LIMIT_TRIGGER_DEPTH → (10:int32)

SQLITE_LIMIT_TRIGGER_DEPTH
https://sqlite.org/c3ref/c_limit_attached.html

LIMIT_VARIABLE_NUMBER

public constant LIMIT_VARIABLE_NUMBER → (9:int32)

SQLITE_LIMIT_VARIABLE_NUMBER
https://sqlite.org/c3ref/c_limit_attached.html

LIMIT_VDBE_OP

public constant LIMIT_VDBE_OP → (5:int32)

SQLITE_LIMIT_VDBE_OP
https://sqlite.org/c3ref/c_limit_attached.html

LIMIT_WORKER_THREADS

public constant LIMIT_WORKER_THREADS → (11:int32)

SQLITE_LIMIT_WORKER_THREADS
https://sqlite.org/c3ref/c_limit_attached.html

LOCKED

public constant LOCKED → (6:int32)

SQLITE_LOCKED
https://sqlite.org/rescode.html#locked

LOCKED_SHAREDCACHE

public constant LOCKED_SHAREDCACHE → (262:int32)

SQLITE_LOCKED_SHAREDCACHE
https://sqlite.org/rescode.html#locked_sharedcache

LOCKED_VTAB

public constant LOCKED_VTAB → (518:int32)

SQLITE_LOCKED_VTAB
https://sqlite.org/rescode.html#locked_vtab

MISMATCH

public constant MISMATCH → (20:int32)

SQLITE_MISMATCH
https://sqlite.org/rescode.html#mismatch

MISUSE

public constant MISUSE → (21:int32)

SQLITE_MISUSE
https://sqlite.org/rescode.html#misuse

NOLFS

public constant NOLFS → (22:int32)

SQLITE_NOLFS
https://sqlite.org/rescode.html#nolfs

NOMEM

public constant NOMEM → (7:int32)

SQLITE_NOMEM
https://sqlite.org/rescode.html#nomem

NOTADB

public constant NOTADB → (26:int32)

SQLITE_NOTADB
https://sqlite.org/rescode.html#notadb

NOTFOUND

public constant NOTFOUND → (12:int32)

SQLITE_NOTFOUND
https://sqlite.org/rescode.html#notfound

NOTICE

public constant NOTICE → (27:int32)

SQLITE_NOTICE
https://sqlite.org/rescode.html#notice

NOTICE_RECOVER_ROLLBACK

public constant NOTICE_RECOVER_ROLLBACK → (539:int32)

SQLITE_NOTICE_RECOVER_ROLLBACK
https://sqlite.org/rescode.html#notice_recover_rollback

NOTICE_RECOVER_WAL

public constant NOTICE_RECOVER_WAL → (283:int32)

SQLITE_NOTICE_RECOVER_WAL
https://sqlite.org/rescode.html#notice_recover_wal

NULL

public constant NULL → (5:int32)

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

OK

public constant OK → (0:int32)

SQLITE_OK
https://sqlite.org/rescode.html#ok

OK_LOAD_PERMANENTLY

public constant OK_LOAD_PERMANENTLY → (256:int32)

SQLITE_OK_LOAD_PERMANENTLY
https://sqlite.org/rescode.html#ok_load_permanently

OPEN_CREATE

public constant OPEN_CREATE → (4:int32)

SQLITE_OPEN_CREATE
https://sqlite.org/c3ref/c_open_autoproxy.html

OPEN_EXRESCODE

public constant OPEN_EXRESCODE → (33554432:int32)

SQLITE_OPEN_EXRESCODE
https://sqlite.org/c3ref/c_open_autoproxy.html

OPEN_FULLMUTEX

public constant OPEN_FULLMUTEX → (65536:int32)

SQLITE_OPEN_FULLMUTEX
https://sqlite.org/c3ref/c_open_autoproxy.html

OPEN_MEMORY

public constant OPEN_MEMORY → (128:int32)

SQLITE_OPEN_MEMORY
https://sqlite.org/c3ref/c_open_autoproxy.html

OPEN_NOFOLLOW

public constant OPEN_NOFOLLOW → (16777216:int32)

SQLITE_OPEN_NOFOLLOW
https://sqlite.org/c3ref/c_open_autoproxy.html

OPEN_NOMUTEX

public constant OPEN_NOMUTEX → (32768:int32)

SQLITE_OPEN_NOMUTEX
https://sqlite.org/c3ref/c_open_autoproxy.html

OPEN_PRIVATECACHE

public constant OPEN_PRIVATECACHE → (262144:int32)

SQLITE_OPEN_PRIVATECACHE
https://sqlite.org/c3ref/c_open_autoproxy.html

OPEN_READONLY

public constant OPEN_READONLY → (1:int32)

SQLITE_OPEN_READONLY
https://sqlite.org/c3ref/c_open_autoproxy.html

OPEN_READWRITE

public constant OPEN_READWRITE → (2:int32)

SQLITE_OPEN_READWRITE
https://sqlite.org/c3ref/c_open_autoproxy.html

OPEN_SHAREDCACHE

public constant OPEN_SHAREDCACHE → (131072:int32)

SQLITE_OPEN_SHAREDCACHE
https://sqlite.org/c3ref/c_open_autoproxy.html

OPEN_URI

public constant OPEN_URI → (64:int32)

SQLITE_OPEN_URI
https://sqlite.org/c3ref/c_open_autoproxy.html

PERM

public constant PERM → (3:int32)

SQLITE_PERM
https://sqlite.org/rescode.html#perm

PREPARE_DONT_LOG

public constant PREPARE_DONT_LOG → (16:int32)

SQLITE_PREPARE_DONT_LOG
https://sqlite.org/c3ref/c_prepare_dont_log.html

PREPARE_NORMALIZE

public constant PREPARE_NORMALIZE → (2:int32)

SQLITE_PREPARE_NORMALIZE
https://sqlite.org/c3ref/c_prepare_dont_log.html

PREPARE_NO_VTAB

public constant PREPARE_NO_VTAB → (4:int32)

SQLITE_PREPARE_NO_VTAB
https://sqlite.org/c3ref/c_prepare_dont_log.html

PREPARE_PERSISTENT

public constant PREPARE_PERSISTENT → (1:int32)

SQLITE_PREPARE_PERSISTENT
https://sqlite.org/c3ref/c_prepare_dont_log.html

PROTOCOL

public constant PROTOCOL → (15:int32)

SQLITE_PROTOCOL
https://sqlite.org/rescode.html#protocol

RANGE

public constant RANGE → (25:int32)

SQLITE_RANGE
https://sqlite.org/rescode.html#range

READONLY

public constant READONLY → (8:int32)

SQLITE_READONLY
https://sqlite.org/rescode.html#readonly

READONLY_CANTINIT

public constant READONLY_CANTINIT → (1288:int32)

SQLITE_READONLY_CANTINIT
https://sqlite.org/rescode.html#readonly_cantinit

READONLY_CANTLOCK

public constant READONLY_CANTLOCK → (520:int32)

SQLITE_READONLY_CANTLOCK
https://sqlite.org/rescode.html#readonly_cantlock

READONLY_DBMOVED

public constant READONLY_DBMOVED → (1032:int32)

SQLITE_READONLY_DBMOVED
https://sqlite.org/rescode.html#readonly_dbmoved

READONLY_DIRECTORY

public constant READONLY_DIRECTORY → (1544:int32)

SQLITE_READONLY_DIRECTORY
https://sqlite.org/rescode.html#readonly_directory

READONLY_RECOVERY

public constant READONLY_RECOVERY → (264:int32)

SQLITE_READONLY_RECOVERY
https://sqlite.org/rescode.html#readonly_recovery

READONLY_ROLLBACK

public constant READONLY_ROLLBACK → (776:int32)

SQLITE_READONLY_ROLLBACK
https://sqlite.org/rescode.html#readonly_rollback

ROW

public constant ROW → (100:int32)

SQLITE_ROW
https://sqlite.org/rescode.html#row

SCHEMA

public constant SCHEMA → (17:int32)

SQLITE_SCHEMA
https://sqlite.org/rescode.html#schema

SERIALIZE_NOCOPY

public constant SERIALIZE_NOCOPY → (1:int32)

SQLITE_SERIALIZE_NOCOPY
https://sqlite.org/c3ref/c_serialize_nocopy.html

STATUS_MALLOC_COUNT

public constant STATUS_MALLOC_COUNT → (9:int32)

SQLITE_STATUS_MALLOC_COUNT
https://sqlite.org/c3ref/c_status_malloc_count.html

STATUS_MALLOC_SIZE

public constant STATUS_MALLOC_SIZE → (5:int32)

SQLITE_STATUS_MALLOC_SIZE
https://sqlite.org/c3ref/c_status_malloc_count.html

STATUS_MEMORY_USED

public constant STATUS_MEMORY_USED → (0:int32)

SQLITE_STATUS_MEMORY_USED
https://sqlite.org/c3ref/c_status_malloc_count.html

STATUS_PAGECACHE_OVERFLOW

public constant STATUS_PAGECACHE_OVERFLOW → (2:int32)

SQLITE_STATUS_PAGECACHE_OVERFLOW
https://sqlite.org/c3ref/c_status_malloc_count.html

STATUS_PAGECACHE_SIZE

public constant STATUS_PAGECACHE_SIZE → (7:int32)

SQLITE_STATUS_PAGECACHE_SIZE
https://sqlite.org/c3ref/c_status_malloc_count.html

STATUS_PAGECACHE_USED

public constant STATUS_PAGECACHE_USED → (1:int32)

SQLITE_STATUS_PAGECACHE_USED
https://sqlite.org/c3ref/c_status_malloc_count.html

STATUS_PARSER_STACK

public constant STATUS_PARSER_STACK → (6:int32)

SQLITE_STATUS_PARSER_STACK
https://sqlite.org/c3ref/c_status_malloc_count.html

STMTSTATUS_AUTOINDEX

public constant STMTSTATUS_AUTOINDEX → (3:int32)

SQLITE_STMTSTATUS_AUTOINDEX
https://sqlite.org/c3ref/c_stmtstatus_counter.html

STMTSTATUS_FILTER_HIT

public constant STMTSTATUS_FILTER_HIT → (8:int32)

SQLITE_STMTSTATUS_FILTER_HIT
https://sqlite.org/c3ref/c_stmtstatus_counter.html

STMTSTATUS_FILTER_MISS

public constant STMTSTATUS_FILTER_MISS → (7:int32)

SQLITE_STMTSTATUS_FILTER_MISS
https://sqlite.org/c3ref/c_stmtstatus_counter.html

STMTSTATUS_FULLSCAN_STEP

public constant STMTSTATUS_FULLSCAN_STEP → (1:int32)

SQLITE_STMTSTATUS_FULLSCAN_STEP
https://sqlite.org/c3ref/c_stmtstatus_counter.html

STMTSTATUS_MEMUSED

public constant STMTSTATUS_MEMUSED → (99:int32)

SQLITE_STMTSTATUS_MEMUSED
https://sqlite.org/c3ref/c_stmtstatus_counter.html

STMTSTATUS_REPREPARE

public constant STMTSTATUS_REPREPARE → (5:int32)

SQLITE_STMTSTATUS_REPREPARE
https://sqlite.org/c3ref/c_stmtstatus_counter.html

STMTSTATUS_RUN

public constant STMTSTATUS_RUN → (6:int32)

SQLITE_STMTSTATUS_RUN
https://sqlite.org/c3ref/c_stmtstatus_counter.html

STMTSTATUS_SORT

public constant STMTSTATUS_SORT → (2:int32)

SQLITE_STMTSTATUS_SORT
https://sqlite.org/c3ref/c_stmtstatus_counter.html

STMTSTATUS_VM_STEP

public constant STMTSTATUS_VM_STEP → (4:int32)

SQLITE_STMTSTATUS_VM_STEP
https://sqlite.org/c3ref/c_stmtstatus_counter.html

TEXT

public constant TEXT → (3:int32)

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

TOOBIG

public constant TOOBIG → (18:int32)

SQLITE_TOOBIG
https://sqlite.org/rescode.html#toobig

UTF16

public constant UTF16 → (4:int32)

SQLITE_UTF16
https://sqlite.org/c3ref/c_any.html

UTF16BE

public constant UTF16BE → (3:int32)

SQLITE_UTF16BE
https://sqlite.org/c3ref/c_any.html

UTF16LE

public constant UTF16LE → (2:int32)

SQLITE_UTF16LE
https://sqlite.org/c3ref/c_any.html

UTF8

public constant UTF8 → (1:int32)

SQLITE_UTF8
https://sqlite.org/c3ref/c_any.html

WARNING

public constant WARNING → (28:int32)

SQLITE_WARNING
https://sqlite.org/rescode.html#warning

WARNING_AUTOINDEX

public constant WARNING_AUTOINDEX → (284:int32)

SQLITE_WARNING_AUTOINDEX
https://sqlite.org/rescode.html#warning_autoindex

Public / Constructors

Get

public static method Get → ()

returns → SQLite3: The native library wrapper or null iff not available.

Returns the SQLite3 wrapper for the loaded SQLite3 library.

Public / Methods

BindBlob64

public method BindBlob64 → (4)

statement ⁱⁿ : IntPtr: The sqlite3_stmt* pointer.
index ⁱⁿ : int32: The parameter index.
value ⁱⁿ : IntPtr: The parameter value.
length ⁱⁿ : int64: The length in bytes.
returns → int32: The result value.

sqlite3_bind_blob64
https://sqlite.org/c3ref/bind_blob.html

BindDouble

public method BindDouble → (3)

statement ⁱⁿ : IntPtr: The sqlite3_stmt* pointer.
index ⁱⁿ : int32: The parameter index.
value ⁱⁿ : float64: The parameter value.
returns → int32: The result value.

sqlite3_bind_double
https://sqlite.org/c3ref/bind_blob.html

BindInt

public method BindInt → (3)

statement ⁱⁿ : IntPtr: The sqlite3_stmt* pointer.
index ⁱⁿ : int32: The parameter index.
value ⁱⁿ : int32: The parameter value.
returns → int32: The result value.

sqlite3_bind_int
https://sqlite.org/c3ref/bind_blob.html

BindInt64

public method BindInt64 → (3)

statement ⁱⁿ : IntPtr: The sqlite3_stmt* pointer.
index ⁱⁿ : int32: The parameter index.
value ⁱⁿ : int64: The parameter value.
returns → int32: The result value.

sqlite3_bind_int64
https://sqlite.org/c3ref/bind_blob.html

BindNull

public method BindNull → (2)

statement ⁱⁿ : IntPtr: The sqlite3_stmt* pointer.
index ⁱⁿ : int32: The parameter index.
returns → int32: The result value.

sqlite3_bind_null
https://sqlite.org/c3ref/bind_blob.html

BindParameterCount

public method BindParameterCount → (1)

statement ⁱⁿ : IntPtr: The sqlite3_stmt* pointer.
returns → int32: The result value.

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

BindParameterIndex

public method BindParameterIndex → (2)

statement ⁱⁿ : IntPtr: The sqlite3_stmt* pointer.
name ⁱⁿ : string: The parameter name.
returns → int32: The result value.

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

BindParameterName

public method BindParameterName → (2)

statement ⁱⁿ : IntPtr: The sqlite3_stmt* pointer.
index ⁱⁿ : int32: The parameter index.
returns → string: The result value.

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

BindText

public method BindText → (3)

statement ⁱⁿ : IntPtr: The sqlite3_stmt* pointer.
index ⁱⁿ : int32: The parameter index.
value ⁱⁿ : string: The parameter value.
returns → int32: The result value.

sqlite3_bind_text
https://sqlite.org/c3ref/bind_blob.html

BindValue

public method BindValue → (3)

statement ⁱⁿ : IntPtr: The sqlite3_stmt* pointer.
index ⁱⁿ : int32: The parameter index.
value ⁱⁿ : IntPtr: The parameter value.
returns → int32: The result value.

sqlite3_bind_value
https://sqlite.org/c3ref/bind_blob.html

BindZeroblob64

public method BindZeroblob64 → (3)

statement ⁱⁿ : IntPtr: The sqlite3_stmt* pointer.
index ⁱⁿ : int32: The parameter index.
length ⁱⁿ : int64: The length in bytes.
returns → int32: The result value.

sqlite3_bind_zeroblob64
https://sqlite.org/c3ref/bind_blob.html

BlobBytes

public method BlobBytes → (1)

blob ⁱⁿ : IntPtr: The sqlite3_blob* pointer.
returns → int32: The result value.

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

BlobClose

public method BlobClose → (1)

blob ⁱⁿ : IntPtr: The sqlite3_blob* pointer.
returns → int32: The result value.

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

BlobOpen

public method BlobOpen → (7)

database ⁱⁿ : IntPtr: The sqlite3* pointer.
name ⁱⁿ : string: The symbolic database name.
table ⁱⁿ : string: The table name.
column ⁱⁿ : string: The column name.
row ⁱⁿ : int64: The row identifier.
flags ⁱⁿ : int32: The set of flags.
blob ^out : IntPtr: The sqlite3_blob* pointer.
returns → int32: The result value.

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

BlobRead

public method BlobRead → (4)

blob ⁱⁿ : IntPtr: The sqlite3_blob* pointer.
buffer ⁱⁿ : IntPtr: The data buffer.
length ⁱⁿ : int32: The length in bytes.
offset ⁱⁿ : int32: The byte offset.
returns → int32: The result value.

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

BlobReopen

public method BlobReopen → (2)

blob ⁱⁿ : IntPtr: The sqlite3_blob* pointer.
row ⁱⁿ : int64: The row identifier.
returns → int32: The result value.

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

BlobWrite

public method BlobWrite → (4)

blob ⁱⁿ : IntPtr: The sqlite3_blob* pointer.
buffer ⁱⁿ : IntPtr: The data buffer.
length ⁱⁿ : int32: The length in bytes.
offset ⁱⁿ : int32: The byte offset.
returns → int32: The result value.

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

Changes64

public method Changes64 → (1)

database ⁱⁿ : IntPtr: The sqlite3* pointer.
returns → int64: The result value.

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

ClearBindings

public method ClearBindings → (1)

statement ⁱⁿ : IntPtr: The sqlite3_stmt* pointer.
returns → int32: The result value.

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

Close

public method Close → (1)

database ⁱⁿ : IntPtr: The sqlite3* pointer.
returns → int32: The result value.

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

ColumnBlob

public method ColumnBlob → (2)

statement ⁱⁿ : IntPtr: The sqlite3_stmt* pointer.
index ⁱⁿ : int32: The column index.
returns → IntPtr: The result value.

sqlite3_column_blob
https://sqlite.org/c3ref/column_blob.html

ColumnBytes

public method ColumnBytes → (2)

statement ⁱⁿ : IntPtr: The sqlite3_stmt* pointer.
index ⁱⁿ : int32: The column index.
returns → int32: The result value.

sqlite3_column_bytes
https://sqlite.org/c3ref/column_blob.html

ColumnCount

public method ColumnCount → (1)

statement ⁱⁿ : IntPtr: The sqlite3_stmt* pointer.
returns → int32: The result value.

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

ColumnDatabaseName

public method ColumnDatabaseName → (2)

statement ⁱⁿ : IntPtr: The sqlite3_stmt* pointer.
index ⁱⁿ : int32: The column index.
returns → string: The result value.

sqlite3_column_database_name
https://sqlite.org/c3ref/column_database_name.html

ColumnDecltype

public method ColumnDecltype → (2)

statement ⁱⁿ : IntPtr: The sqlite3_stmt* pointer.
index ⁱⁿ : int32: The column index.
returns → string: The result value.

sqlite3_column_decltype
https://sqlite.org/c3ref/column_decltype.html

ColumnDouble

public method ColumnDouble → (2)

statement ⁱⁿ : IntPtr: The sqlite3_stmt* pointer.
index ⁱⁿ : int32: The column index.
returns → float64: The result value.

sqlite3_column_double
https://sqlite.org/c3ref/column_blob.html

ColumnInt

public method ColumnInt → (2)

statement ⁱⁿ : IntPtr: The sqlite3_stmt* pointer.
index ⁱⁿ : int32: The column index.
returns → int32: The result value.

sqlite3_column_int
https://sqlite.org/c3ref/column_blob.html

ColumnInt64

public method ColumnInt64 → (2)

statement ⁱⁿ : IntPtr: The sqlite3_stmt* pointer.
index ⁱⁿ : int32: The column index.
returns → int64: The result value.

sqlite3_column_int64
https://sqlite.org/c3ref/column_blob.html

ColumnName

public method ColumnName → (2)

statement ⁱⁿ : IntPtr: The sqlite3_stmt* pointer.
index ⁱⁿ : int32: The column index.
returns → string: The result value.

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

ColumnOriginName

public method ColumnOriginName → (2)

statement ⁱⁿ : IntPtr: The sqlite3_stmt* pointer.
index ⁱⁿ : int32: The column index.
returns → string: The result value.

sqlite3_column_origin_name
https://sqlite.org/c3ref/column_database_name.html

ColumnTableName

public method ColumnTableName → (2)

statement ⁱⁿ : IntPtr: The sqlite3_stmt* pointer.
index ⁱⁿ : int32: The column index.
returns → string: The result value.

sqlite3_column_table_name
https://sqlite.org/c3ref/column_database_name.html

ColumnText

public method ColumnText → (2)

statement ⁱⁿ : IntPtr: The sqlite3_stmt* pointer.
index ⁱⁿ : int32: The column index.
returns → string: The result value.

sqlite3_column_text
https://sqlite.org/c3ref/column_blob.html

ColumnType

public method ColumnType → (2)

statement ⁱⁿ : IntPtr: The sqlite3_stmt* pointer.
index ⁱⁿ : int32: The column index.
returns → int32: The result value.

sqlite3_column_type
https://sqlite.org/c3ref/column_blob.html

ColumnValue

public method ColumnValue → (2)

statement ⁱⁿ : IntPtr: The sqlite3_stmt* pointer.
index ⁱⁿ : int32: The column index.
returns → IntPtr: The result value.

sqlite3_column_value
https://sqlite.org/c3ref/column_blob.html

Config

public method Config → (1)

option ⁱⁿ : int32: The SQLITE_CONFIG_* option.
returns → int32: The result value.

sqlite3_config
https://sqlite.org/c3ref/config.html

DataCount

public method DataCount → (1)

statement ⁱⁿ : IntPtr: The sqlite3_stmt* pointer.
returns → int32: The result value.

sqlite3_data_count
https://sqlite.org/c3ref/data_count.html

DbCacheflush

public method DbCacheflush → (1)

database ⁱⁿ : IntPtr: The sqlite3* pointer.
returns → int32: The result value.

sqlite3_db_cacheflush
https://sqlite.org/c3ref/db_cacheflush.html

DbHandle

public method DbHandle → (1)

statement ⁱⁿ : IntPtr: The sqlite3_stmt* pointer.
returns → IntPtr: The result value.

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

DbName

public method DbName → (2)

database ⁱⁿ : IntPtr: The sqlite3* pointer.
index ⁱⁿ : int32: The database name index.
returns → string: The result value.

sqlite3_db_name
https://sqlite.org/c3ref/db_name.html

DbReadonly

public method DbReadonly → (2)

database ⁱⁿ : IntPtr: The sqlite3* pointer.
name ⁱⁿ : string: The symbolic database name.
returns → int32: The result value.

sqlite3_db_readonly
https://sqlite.org/c3ref/db_readonly.html

DbReleaseMemory

public method DbReleaseMemory → (1)

database ⁱⁿ : IntPtr: The sqlite3* pointer.
returns → int32: The result value.

sqlite3_db_release_memory
https://sqlite.org/c3ref/db_release_memory.html

DbStatus

public method DbStatus → (5)

database ⁱⁿ : IntPtr: The sqlite3* pointer.
flags ⁱⁿ : int32: The set of flags.
current ^out : int32: The current value.
highest ^out : int32: The highest value.
reset ⁱⁿ : int32: Reset values?
returns → int32: The result value.

sqlite3_db_status
https://sqlite.org/c3ref/db_status.html

Deserialize

public method Deserialize → (5)

database ⁱⁿ : IntPtr: The sqlite3* pointer.
name ⁱⁿ : string: The symbolic database name.
buffer ⁱⁿ : IntPtr: The data buffer.
length ⁱⁿ : int64: The length in bytes.
flags ⁱⁿ : int32: The set of flags.
returns → int32: The result value.

sqlite3_deserialize
https://sqlite.org/c3ref/deserialize.html

Errcode

public method Errcode → (1)

database ⁱⁿ : IntPtr: The sqlite3* pointer.
returns → int32: The result value.

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

Errmsg

public method Errmsg → (1)

database ⁱⁿ : IntPtr: The sqlite3* pointer.
returns → string: The result value.

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

ErrorOffset

public method ErrorOffset → (1)

database ⁱⁿ : IntPtr: The sqlite3* pointer.
returns → int32: The result value.

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

Errstr

public method Errstr → (1)

error ⁱⁿ : int32: The error code.
returns → string: The result value.

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

ExpandedSql

public method ExpandedSql → (1)

statement ⁱⁿ : IntPtr: The sqlite3_stmt* pointer.
returns → string: The result value.

sqlite3_expanded_sql
https://sqlite.org/c3ref/expanded_sql.html

ExtendedErrcode

public method ExtendedErrcode → (1)

database ⁱⁿ : IntPtr: The sqlite3* pointer.
returns → int32: The result value.

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

ExtendedResultCodes

public method ExtendedResultCodes → (2)

database ⁱⁿ : IntPtr: The sqlite3* pointer.
flags ⁱⁿ : int32: The set of flags.
returns → int32: The result value.

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

Finalize

public method Finalize → (1)

statement ⁱⁿ : IntPtr: The sqlite3_stmt* pointer.
returns → int32: The result value.

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

Free

public method Free → (1)

buffer ⁱⁿ : IntPtr: The data buffer.

sqlite3_free
https://sqlite.org/c3ref/free.html

GetAutocommit

public method GetAutocommit → (1)

database ⁱⁿ : IntPtr: The sqlite3* pointer.
returns → int32: The result value.

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

HardHeapLimit64

public method HardHeapLimit64 → (1)

length ⁱⁿ : int64: The length in bytes.
returns → int64: The result value.

sqlite3_hard_heap_limit64
https://sqlite.org/c3ref/hard_heap_limit64.html

Initialize2

public method Initialize2 → ()

returns → int32: The result value.

sqlite3_initialize
https://sqlite.org/c3ref/initialize.html

Interrupt

public method Interrupt → (1)

database ⁱⁿ : IntPtr: The sqlite3* pointer.

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

IsInterrupted

public method IsInterrupted → (1)

database ⁱⁿ : IntPtr: The sqlite3* pointer.
returns → int32: The result value.

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

KeywordCheck

public method KeywordCheck → (1)

keyword ⁱⁿ : string: The SQL keyword.
returns → int32: The result value.

sqlite3_keyword_check
https://sqlite.org/c3ref/keyword_check.html

KeywordCount

public method KeywordCount → ()

returns → int32: The result value.

sqlite3_keyword_count
https://sqlite.org/c3ref/keyword_check.html

KeywordName

public method KeywordName → (3)

keyword ⁱⁿ : int32: The SQL keyword.
buffer ^out : IntPtr: The data buffer.
length ^out : int32: The length in bytes.
returns → int32: The result value.

sqlite3_keyword_name
https://sqlite.org/c3ref/keyword_check.html

LastInsertRowid

public method LastInsertRowid → (1)

database ⁱⁿ : IntPtr: The sqlite3* pointer.
returns → int64: The result value.

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

Libversion

public method Libversion → ()

returns → string: The result value.

sqlite3_libversion
https://sqlite.org/c3ref/libversion.html

LibversionNumber

public method LibversionNumber → ()

returns → int32: The result value.

sqlite3_libversion_number
https://sqlite.org/c3ref/libversion.html

Limit

public method Limit → (3)

database ⁱⁿ : IntPtr: The sqlite3* pointer.
index ⁱⁿ : int32: The parameter index.
value ⁱⁿ : int32: The parameter value.
returns → int32: The result value.

sqlite3_limit
https://sqlite.org/c3ref/limit.html

MemoryHighwater

public method MemoryHighwater → (1)

flags ⁱⁿ : int32: The set of flags.
returns → int64: The result value.

sqlite3_memory_highwater
https://sqlite.org/c3ref/memory_highwater.html

MemoryUsed

public method MemoryUsed → ()

returns → int64: The result value.

sqlite3_memory_used
https://sqlite.org/c3ref/memory_highwater.html

NextStmt

public method NextStmt → (2)

database ⁱⁿ : IntPtr: The sqlite3* pointer.
statement ⁱⁿ : IntPtr: The sqlite3_stmt* pointer.
returns → IntPtr: The result value.

sqlite3_next_stmt
https://sqlite.org/c3ref/next_stmt.html

OpenV2

public method OpenV2 → (4)

file ⁱⁿ : string: The file path.
database ^out : IntPtr: The sqlite3* pointer.
flags ⁱⁿ : int32: The set of flags.
vfs ⁱⁿ : string: Name of filesystem module.
returns → int32: The result value.

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

PrepareV3

public method PrepareV3 → (4)

database ⁱⁿ : IntPtr: The sqlite3* pointer.
sql ⁱⁿ : string: The SQL code.
flags ⁱⁿ : int32: The set of flags.
statement ^out : IntPtr: The sqlite3_stmt* pointer.
returns → int32: The result value.

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

Randomness

public method Randomness → (2)

length ⁱⁿ : int32: The length in bytes.
buffer ⁱⁿ : IntPtr: The data buffer.

sqlite3_randomness
https://sqlite.org/c3ref/randomness.html

ReleaseMemory

public method ReleaseMemory → (1)

length ⁱⁿ : int32: The length in bytes.
returns → int32: The result value.

sqlite3_release_memory
https://sqlite.org/c3ref/release_memory.html

Reset

public method Reset → (1)

statement ⁱⁿ : IntPtr: The sqlite3_stmt* pointer.
returns → int32: The result value.

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

Serialize

public method Serialize → (4)

database ⁱⁿ : IntPtr: The sqlite3* pointer.
name ⁱⁿ : string: The symbolic database name.
length ^out : int64: The length in bytes.
flags ⁱⁿ : int32: The set of flags.
returns → IntPtr: The result value.

sqlite3_serialize
https://sqlite.org/c3ref/serialize.html

SetLastInsertRowid

public method SetLastInsertRowid → (2)

database ⁱⁿ : IntPtr: The sqlite3* pointer.
row ⁱⁿ : int64: The row identifier.

sqlite3_set_last_insert_rowid
https://sqlite.org/c3ref/set_last_insert_rowid.html

Shutdown

public method Shutdown → ()

returns → int32: The result value.

sqlite3_shutdown
https://sqlite.org/c3ref/initialize.html

SoftHeapLimit64

public method SoftHeapLimit64 → (1)

length ⁱⁿ : int64: The length in bytes.
returns → int64: The result value.

sqlite3_soft_heap_limit64
https://sqlite.org/c3ref/hard_heap_limit64.html

Sourceid

public method Sourceid → ()

returns → string: The result value.

sqlite3_sourceid
https://sqlite.org/c3ref/libversion.html

Sql

public method Sql → (1)

statement ⁱⁿ : IntPtr: The sqlite3_stmt* pointer.
returns → string: The result value.

sqlite3_sql
https://sqlite.org/c3ref/expanded_sql.html

Status64

public method Status64 → (4)

flags ⁱⁿ : int32: The set of flags.
current ^out : int64: The current value.
highest ^out : int64: The highest value.
reset ⁱⁿ : int32: Reset values?
returns → int32: The result value.

sqlite3_status64
https://sqlite.org/c3ref/status.html

Step

public method Step → (1)

statement ⁱⁿ : IntPtr: The sqlite3_stmt* pointer.
returns → int32: The result value.

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

StmtBusy

public method StmtBusy → (1)

statement ⁱⁿ : IntPtr: The sqlite3_stmt* pointer.
returns → int32: The result value.

sqlite3_stmt_busy
https://sqlite.org/c3ref/stmt_busy.html

StmtExplain

public method StmtExplain → (2)

statement ⁱⁿ : IntPtr: The sqlite3_stmt* pointer.
flags ⁱⁿ : int32: The set of flags.
returns → int32: The result value.

sqlite3_stmt_explain
https://sqlite.org/c3ref/stmt_explain.html

StmtIsexplain

public method StmtIsexplain → (1)

statement ⁱⁿ : IntPtr: The sqlite3_stmt* pointer.
returns → int32: The result value.

sqlite3_stmt_isexplain
https://sqlite.org/c3ref/stmt_isexplain.html

StmtReadonly

public method StmtReadonly → (1)

statement ⁱⁿ : IntPtr: The sqlite3_stmt* pointer.
returns → int32: The result value.

sqlite3_stmt_readonly
https://sqlite.org/c3ref/stmt_readonly.html

StmtStatus

public method StmtStatus → (3)

statement ⁱⁿ : IntPtr: The sqlite3_stmt* pointer.
flags ⁱⁿ : int32: The set of flags.
reset ⁱⁿ : int32: Reset values?
returns → int32: The result value.

sqlite3_stmt_status
https://sqlite.org/c3ref/stmt_status.html

TotalChanges64

public method TotalChanges64 → (1)

database ⁱⁿ : IntPtr: The sqlite3* pointer.
returns → int64: The result value.

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

TxnState

public method TxnState → (2)

database ⁱⁿ : IntPtr: The sqlite3* pointer.
name ⁱⁿ : string: The symbolic database name.
returns → int32: The result value.

sqlite3_txn_state
https://sqlite.org/c3ref/txn_state.html

ValueBlob

public method ValueBlob → (1)

value ⁱⁿ : IntPtr: The sqlite3_value* pointer.
returns → IntPtr: The result value.

sqlite3_value_blob
https://sqlite.org/c3ref/value_blob.html

ValueBytes

public method ValueBytes → (1)

value ⁱⁿ : IntPtr: The sqlite3_value* pointer.
returns → int32: The result value.

sqlite3_value_bytes
https://sqlite.org/c3ref/value_blob.html

ValueDouble

public method ValueDouble → (1)

value ⁱⁿ : IntPtr: The sqlite3_value* pointer.
returns → float64: The result value.

sqlite3_value_double
https://sqlite.org/c3ref/value_blob.html

ValueDup

public method ValueDup → (1)

value ⁱⁿ : IntPtr: The sqlite3_value* pointer.
returns → IntPtr: The result value.

sqlite3_value_dup
https://sqlite.org/c3ref/value_dup.html

ValueEncoding

public method ValueEncoding → (1)

value ⁱⁿ : IntPtr: The sqlite3_value* pointer.
returns → int32: The result value.

sqlite3_value_encoding
https://sqlite.org/c3ref/value_encoding.html

ValueFree

public method ValueFree → (1)

value ⁱⁿ : IntPtr: The sqlite3_value* pointer.

sqlite3_value_free
https://sqlite.org/c3ref/value_dup.html

ValueFrombind

public method ValueFrombind → (1)

value ⁱⁿ : IntPtr: The sqlite3_value* pointer.
returns → int32: The result value.

sqlite3_value_frombind
https://sqlite.org/c3ref/value_blob.html

ValueInt

public method ValueInt → (1)

value ⁱⁿ : IntPtr: The sqlite3_value* pointer.
returns → int32: The result value.

sqlite3_value_int
https://sqlite.org/c3ref/value_blob.html

ValueInt64

public method ValueInt64 → (1)

value ⁱⁿ : IntPtr: The sqlite3_value* pointer.
returns → int64: The result value.

sqlite3_value_int64
https://sqlite.org/c3ref/value_blob.html

ValueNochange

public method ValueNochange → (1)

value ⁱⁿ : IntPtr: The sqlite3_value* pointer.
returns → int32: The result value.

sqlite3_value_nochange
https://sqlite.org/c3ref/value_blob.html

ValueNumericType

public method ValueNumericType → (1)

value ⁱⁿ : IntPtr: The sqlite3_value* pointer.
returns → int32: The result value.

sqlite3_value_numeric_type
https://sqlite.org/c3ref/value_blob.html

ValueText

public method ValueText → (1)

value ⁱⁿ : IntPtr: The sqlite3_value* pointer.
returns → string: The result value.

sqlite3_value_text
https://sqlite.org/c3ref/value_blob.html

ValueType

public method ValueType → (1)

value ⁱⁿ : IntPtr: The sqlite3_value* pointer.
returns → int32: The result value.

sqlite3_value_type
https://sqlite.org/c3ref/value_blob.html

Public / Attributes

IsAvailable

public static attribute IsAvailable → (get)

value : bool: true if the library is available,
false if not, i.e. Get will return null.

Checks if the SQLite3 library is available.

Extensions

ApiErrorThrow

_2 overloads

public static method ApiErrorThrow¹ → (3)

source ⁱⁿ : string @ Tag: The error source tag.
path ⁱⁿ : Path: The database file path.
database ⁱⁿ : IntPtr: The database object.
returns → IOException: The ready-to-throw exception.

Wraps the current database error message in an exception.

See also: SQLite3.Errmsg

public static method ApiErrorThrow² → (5)

source ⁱⁿ : string @ Tag: The error source tag.
path ⁱⁿ : Path: The database file path.
function ⁱⁿ : string: The failed function code.
error ⁱⁿ : int32: The error code.
database ^opt : IntPtr = default(IntPtr): The sqlite3* pointer, if available.
returns → IOException: The ready-to-throw exception.

Wraps the current database error message in an exception.

See also: SQLite3.Errstr
SQLite3.Errmsg

ApiExecuteStatement

_2 overloads

public static method ApiExecuteStatement¹ → (2)

file ⁱⁿ : Path: [not-null]
The database file path or Path.Unknown.
statement ⁱⁿ : IntPtr: The statement object.

Executes the given prepared statement ⁱⁿ.

This method is a shortcut to SQLite3.PrepareV3, SQLite3.Step and SQLite3.Finalize.

IOException: If an I/O error has occurred.

public static method ApiExecuteStatement² → (3)

file ⁱⁿ : Path: [not-null]
The database file path or Path.Unknown.
database ⁱⁿ : IntPtr: The database object.
sql ⁱⁿ : string: [not-null]
The SQL code.

Executes the given sql ⁱⁿ statement.

This method is a shortcut to SQLite3.PrepareV3, SQLite3.Step and SQLite3.Finalize.

IOException: If an I/O error has occurred.

ApiPrepareStatement

public static method ApiPrepareStatement → (4)

file ⁱⁿ : Path: [not-null]
The database file path or Path.Unknown.
database ⁱⁿ : IntPtr: The database object.
sql ⁱⁿ : string: [not-null]
The SQL code.
persistent ⁱⁿ : bool: Use SQLite3.PREPARE_PERSISTENT?
returns → IntPtr: The sqlite3_sttmt* pointer.

Prepares the given sql ⁱⁿ statement.

This method is a shortcut to SQLite3.PrepareV3.

IOException: If an I/O error has occurred.

SQLite3

Description

Public / Constants

ABORT

ABORT_­ROLLBACK

AUTH

AUTH_­USER

BLOB

BUSY

BUSY_­RECOVERY

BUSY_­SNAPSHOT

BUSY_­TIMEOUT

CANTOPEN

CANTOPEN_­CONVPATH

CANTOPEN_­DIRTYWAL

CANTOPEN_­FULLPATH

CANTOPEN_­ISDIR

CANTOPEN_­NOTEMPDIR

CANTOPEN_­SYMLINK

CONFIG_­MULTITHREAD

CONFIG_­SERIALIZED

CONFIG_­SINGLETHREAD

CONSTRAINT

CONSTRAINT_­CHECK

CONSTRAINT_­COMMITHOOK

CONSTRAINT_­DATATYPE

CONSTRAINT_­FOREIGNKEY

CONSTRAINT_­FUNCTION

CONSTRAINT_­NOTNULL

CONSTRAINT_­PINNED

CONSTRAINT_­PRIMARYKEY

CONSTRAINT_­ROWID

CONSTRAINT_­TRIGGER

CONSTRAINT_­UNIQUE

CONSTRAINT_­VTAB

CORRUPT

CORRUPT_­INDEX

CORRUPT_­SEQUENCE

CORRUPT_­VTAB

DBSTATUS_­CACHE_­HIT

DBSTATUS_­CACHE_­MISS

DBSTATUS_­CACHE_­SPILL

DBSTATUS_­CACHE_­USED

DBSTATUS_­CACHE_­USED_­SHARED

DBSTATUS_­CACHE_­WRITE

DBSTATUS_­DEFERRED_­FKS

DBSTATUS_­LOOKASIDE_­HIT

DBSTATUS_­LOOKASIDE_­MISS_­FULL

DBSTATUS_­LOOKASIDE_­MISS_­SIZE

DBSTATUS_­LOOKASIDE_­USED

DBSTATUS_­SCHEMA_­USED

DBSTATUS_­STMT_­USED

DONE

EMPTY

ERROR

ERROR_­MISSING_­COLLSEQ

ERROR_­RETRY

ERROR_­SNAPSHOT

FLOAT

FORMAT

FULL

INTEGER

INTERNAL

INTERRUPT

IOERR

IOERR_­ACCESS

IOERR_­AUTH

IOERR_­BEGIN_­ATOMIC

IOERR_­BLOCKED

IOERR_­CHECKRESERVEDLOCK

IOERR_­CLOSE

IOERR_­COMMIT_­ATOMIC

IOERR_­CONVPATH

IOERR_­CORRUPTFS

IOERR_­DATA

IOERR_­DELETE

IOERR_­DELETE_­NOENT

IOERR_­DIR_­CLOSE

IOERR_­DIR_­FSYNC

IOERR_­FSTAT

ABORT_ROLLBACK

AUTH_USER

BUSY_RECOVERY

BUSY_SNAPSHOT

BUSY_TIMEOUT

CANTOPEN_CONVPATH

CANTOPEN_DIRTYWAL

CANTOPEN_FULLPATH

CANTOPEN_ISDIR

CANTOPEN_NOTEMPDIR

CANTOPEN_SYMLINK

CONFIG_MULTITHREAD

CONFIG_SERIALIZED

CONFIG_SINGLETHREAD

CONSTRAINT_CHECK

CONSTRAINT_COMMITHOOK

CONSTRAINT_DATATYPE

CONSTRAINT_FOREIGNKEY

CONSTRAINT_FUNCTION

CONSTRAINT_NOTNULL

CONSTRAINT_PINNED

CONSTRAINT_PRIMARYKEY

CONSTRAINT_ROWID

CONSTRAINT_TRIGGER

CONSTRAINT_UNIQUE

CONSTRAINT_VTAB

CORRUPT_INDEX

CORRUPT_SEQUENCE

CORRUPT_VTAB

DBSTATUS_CACHE_HIT

DBSTATUS_CACHE_MISS

DBSTATUS_CACHE_SPILL

DBSTATUS_CACHE_USED

DBSTATUS_CACHE_USED_SHARED

DBSTATUS_CACHE_WRITE

DBSTATUS_DEFERRED_FKS

DBSTATUS_LOOKASIDE_HIT

DBSTATUS_LOOKASIDE_MISS_FULL

DBSTATUS_LOOKASIDE_MISS_SIZE

DBSTATUS_LOOKASIDE_USED

DBSTATUS_SCHEMA_USED

DBSTATUS_STMT_USED

ERROR_MISSING_COLLSEQ

ERROR_RETRY

ERROR_SNAPSHOT

IOERR_ACCESS

IOERR_AUTH

IOERR_BEGIN_ATOMIC

IOERR_BLOCKED

IOERR_CHECKRESERVEDLOCK

IOERR_CLOSE

IOERR_COMMIT_ATOMIC

IOERR_CONVPATH

IOERR_CORRUPTFS

IOERR_DATA

IOERR_DELETE

IOERR_DELETE_NOENT

IOERR_DIR_CLOSE

IOERR_DIR_FSYNC

IOERR_FSTAT

IOERR_FSYNC

IOERR_GETTEMPPATH

IOERR_LOCK

IOERR_MMAP

IOERR_NOMEM

IOERR_RDLOCK

IOERR_READ

IOERR_ROLLBACK_ATOMIC

IOERR_SEEK

IOERR_SHMLOCK

IOERR_SHMMAP

IOERR_SHMOPEN

IOERR_SHMSIZE

IOERR_SHORT_READ

IOERR_TRUNCATE

IOERR_UNLOCK

IOERR_VNODE

IOERR_WRITE

LIMIT_ATTACHED

LIMIT_COLUMN