Bindings.Sqlite3

Run-Time Library Version Numbers

sqlite3_version :: CString

sqlite3_libversion :: IO CString

sqlite3_libversion_number :: CInt

Test To See If The Library Is Threadsafe

sqlite3_threadsafe :: IO CInt

Database Connection Handle

data Sqlite3

Closing A Database Connection

sqlite3_close :: Ptr Sqlite3 -> CInt

One-Step Query Execution Interface

sqlite3_exec :: Ptr Sqlite3 -> CString -> FunPtr (Ptr a -> CInt -> Ptr CString -> Ptr CString -> IO CInt) -> Ptr a -> Ptr CString -> IO CInt

Result Codes

_SQLITE_OK :: CInt

_SQLITE_ERROR :: CInt

_SQLITE_INTERNAL :: CInt

_SQLITE_PERM :: CInt

_SQLITE_ABORT :: CInt

_SQLITE_BUSY :: CInt

_SQLITE_LOCKED :: CInt

_SQLITE_NOMEM :: CInt

_SQLITE_READONLY :: CInt

_SQLITE_INTERRUPT :: CInt

_SQLITE_IOERR :: CInt

_SQLITE_CORRUPT :: CInt

_SQLITE_NOTFOUND :: CInt

_SQLITE_FULL :: CInt

_SQLITE_CANTOPEN :: CInt

_SQLITE_PROTOCOL :: CInt

_SQLITE_EMPTY :: CInt

_SQLITE_SCHEMA :: CInt

_SQLITE_TOOBIG :: CInt

_SQLITE_CONSTRAINT :: CInt

_SQLITE_MISMATCH :: CInt

_SQLITE_MISUSE :: CInt

_SQLITE_NOLFS :: CInt

_SQLITE_AUTH :: CInt

_SQLITE_FORMAT :: CInt

_SQLITE_RANGE :: CInt

_SQLITE_NOTADB :: CInt

_SQLITE_ROW :: CInt

_SQLITE_DONE :: CInt

Extended Result Codes

_SQLITE_IOERR_READ :: CInt

_SQLITE_IOERR_SHORT_READ :: CInt

_SQLITE_IOERR_WRITE :: CInt

_SQLITE_IOERR_FSYNC :: CInt

_SQLITE_IOERR_DIR_FSYNC :: CInt

_SQLITE_IOERR_TRUNCATE :: CInt

_SQLITE_IOERR_FSTAT :: CInt

_SQLITE_IOERR_UNLOCK :: CInt

_SQLITE_IOERR_RDLOCK :: CInt

_SQLITE_IOERR_DELETE :: CInt

_SQLITE_IOERR_BLOCKED :: CInt

_SQLITE_IOERR_NOMEM :: CInt

_SQLITE_IOERR_ACCESS :: CInt

_SQLITE_IOERR_CHECKRESERVEDLOCK :: CInt

_SQLITE_IOERR_LOCK :: CInt

_SQLITE_IOERR_CLOSE :: CInt

_SQLITE_IOERR_DIR_CLOSE :: CInt

Flags For File Open Operations

_SQLITE_OPEN_READONLY :: CInt

_SQLITE_OPEN_READWRITE :: CInt

_SQLITE_OPEN_CREATE :: CInt

_SQLITE_OPEN_DELETEONCLOSE :: CInt

_SQLITE_OPEN_EXCLUSIVE :: CInt

_SQLITE_OPEN_MAIN_DB :: CInt

_SQLITE_OPEN_TEMP_DB :: CInt

_SQLITE_OPEN_TRANSIENT_DB :: CInt

_SQLITE_OPEN_MAIN_JOURNAL :: CInt

_SQLITE_OPEN_TEMP_JOURNAL :: CInt

_SQLITE_OPEN_SUBJOURNAL :: CInt

_SQLITE_OPEN_MASTER_JOURNAL :: CInt

_SQLITE_OPEN_NOMUTEX :: CInt

_SQLITE_OPEN_FULLMUTEX :: CInt

Device Characteristics

_SQLITE_IOCAP_ATOMIC :: CInt

_SQLITE_IOCAP_ATOMIC512 :: CInt

_SQLITE_IOCAP_ATOMIC1K :: CInt

_SQLITE_IOCAP_ATOMIC2K :: CInt

_SQLITE_IOCAP_ATOMIC4K :: CInt

_SQLITE_IOCAP_ATOMIC8K :: CInt

_SQLITE_IOCAP_ATOMIC16K :: CInt

_SQLITE_IOCAP_ATOMIC32K :: CInt

_SQLITE_IOCAP_ATOMIC64K :: CInt

_SQLITE_IOCAP_SAFE_APPEND :: CInt

_SQLITE_IOCAP_SEQUENTIAL :: CInt

File Locking Levels

_SQLITE_LOCK_NONE :: CInt

_SQLITE_LOCK_SHARED :: CInt

_SQLITE_LOCK_RESERVED :: CInt

_SQLITE_LOCK_PENDING :: CInt

_SQLITE_LOCK_EXCLUSIVE :: CInt

Synchronization Type Flags

_SQLITE_SYNC_NORMAL :: CInt

_SQLITE_SYNC_FULL :: CInt

_SQLITE_SYNC_DATAONLY :: CInt

OS Interface Open File Handle

data Sqlite3_file

Instances

Storable Sqlite3_file

OS Interface File Virtual Methods Object

data Sqlite3_io_methods

Instances

Storable Sqlite3_io_methods

Standard File Control Opcodes

_SQLITE_FCNTL_LOCKSTATE :: CInt

_SQLITE_GET_LOCKPROXYFILE :: CInt

_SQLITE_SET_LOCKPROXYFILE :: CInt

_SQLITE_LAST_ERRNO :: CInt

Mutex Handle

data Sqlite3_mutex

OS Interface Object

data Sqlite3_vfs

Flags for the xAccess VFS method

_SQLITE_ACCESS_EXISTS :: CInt

_SQLITE_ACCESS_READWRITE :: CInt

_SQLITE_ACCESS_READ :: CInt

Initialize The SQLite Library

sqlite3_initialize :: CInt

sqlite3_shutdown :: CInt

sqlite3_os_init :: CInt

sqlite3_os_end :: CInt

Enable Or Disable Extended Result Codes

sqlite3_extended_result_codes :: Ptr Sqlite3 -> CInt -> IO CInt

Last Insert Rowid

sqlite3_last_insert_rowid :: Ptr Sqlite3 -> IO Int64

Count The Number Of Rows Modified

sqlite3_changes :: Ptr Sqlite3 -> IO CInt

Total Number Of Rows Modified

sqlite3_total_changes :: Ptr Sqlite3 -> IO CInt

Interrupt A Long-Running Query

sqlite3_interrupt :: Ptr Sqlite3 -> IO ()

Determine If An SQL Statement Is Complete

sqlite3_complete :: CString -> IO CInt

sqlite3_complete16 :: Ptr () -> IO CInt

Register A Callback To Handle SQLITE_BUSY Errors

sqlite3_busy_handler :: Ptr Sqlite3 -> FunPtr (Ptr a -> CInt -> IO CInt) -> Ptr a -> IO CInt

Set A Busy Timeout

sqlite3_busy_timeout :: Ptr Sqlite3 -> CInt -> IO CInt

Convenience Routines For Running Queries

sqlite3_get_table :: Ptr Sqlite3 -> CString -> Ptr (Ptr CString) -> Ptr CInt -> Ptr CInt -> Ptr CString -> IO CInt

sqlite3_free_table :: Ptr CString -> IO ()

Memory Allocation Subsystem

sqlite3_malloc :: CInt -> IO (Ptr ())

sqlite3_realloc :: Ptr () -> CInt -> IO (Ptr ())

sqlite3_free :: Ptr () -> IO ()

Memory Allocator Statistics

sqlite3_memory_used :: IO Int64

sqlite3_memory_highwater :: CInt -> IO Int64

Pseudo-Random Number Generator

sqlite3_randomness :: CInt -> Ptr () -> IO ()

Compile-Time Authorization Callbacks

sqlite3_set_authorizer :: Ptr Sqlite3 -> FunPtr (Ptr a -> CInt -> CString -> CString -> CString -> CString -> IO CInt) -> Ptr a -> IO CInt

Authorizer Return Codes

_SQLITE_DENY :: CInt

_SQLITE_IGNORE :: CInt

Authorizer Action Codes

_SQLITE_CREATE_INDEX :: CInt

_SQLITE_CREATE_TABLE :: CInt

_SQLITE_CREATE_TEMP_INDEX :: CInt

_SQLITE_CREATE_TEMP_TABLE :: CInt

_SQLITE_CREATE_TEMP_TRIGGER :: CInt

_SQLITE_CREATE_TEMP_VIEW :: CInt

_SQLITE_CREATE_TRIGGER :: CInt

_SQLITE_CREATE_VIEW :: CInt

_SQLITE_DELETE :: CInt

_SQLITE_DROP_INDEX :: CInt

_SQLITE_DROP_TABLE :: CInt

_SQLITE_DROP_TEMP_INDEX :: CInt

_SQLITE_DROP_TEMP_TABLE :: CInt

_SQLITE_DROP_TEMP_TRIGGER :: CInt

_SQLITE_DROP_TEMP_VIEW :: CInt

_SQLITE_DROP_TRIGGER :: CInt

_SQLITE_DROP_VIEW :: CInt

_SQLITE_INSERT :: CInt

_SQLITE_PRAGMA :: CInt

_SQLITE_READ :: CInt

_SQLITE_SELECT :: CInt

_SQLITE_TRANSACTION :: CInt

_SQLITE_UPDATE :: CInt

_SQLITE_ATTACH :: CInt

_SQLITE_DETACH :: CInt

_SQLITE_ALTER_TABLE :: CInt

_SQLITE_REINDEX :: CInt

_SQLITE_ANALYZE :: CInt

_SQLITE_CREATE_VTABLE :: CInt

_SQLITE_DROP_VTABLE :: CInt

_SQLITE_FUNCTION :: CInt

_SQLITE_SAVEPOINT :: CInt

_SQLITE_COPY :: CInt

Query Progress Callbacks

sqlite3_progress_handler :: Ptr Sqlite3 -> CInt -> FunPtr (Ptr a -> IO CInt) -> Ptr a -> IO ()

Opening A New Database Connection

sqlite3_open :: CString -> Ptr (Ptr Sqlite3) -> IO CInt

sqlite3_open16 :: Ptr () -> Ptr (Ptr Sqlite3) -> IO CInt

sqlite3_open_v2 :: CString -> Ptr (Ptr Sqlite3) -> CInt -> CString -> IO CInt

Error Codes And Messages

sqlite3_errcode :: Ptr Sqlite3 -> IO CInt

sqlite3_extended_errcode :: Ptr Sqlite3 -> IO CInt

sqlite3_errmsg :: Ptr Sqlite3 -> IO CString

sqlite3_errmsg16 :: Ptr Sqlite3 -> IO (Ptr ())

SQL Statement Object

data Sqlite3_stmt

Run-time Limits

sqlite3_limit :: Ptr Sqlite3 -> CInt -> CInt -> IO CInt

Run-Time Limit Categories

_SQLITE_LIMIT_LENGTH :: CInt

_SQLITE_LIMIT_SQL_LENGTH :: CInt

_SQLITE_LIMIT_COLUMN :: CInt

_SQLITE_LIMIT_EXPR_DEPTH :: CInt

_SQLITE_LIMIT_COMPOUND_SELECT :: CInt

_SQLITE_LIMIT_VDBE_OP :: CInt

_SQLITE_LIMIT_FUNCTION_ARG :: CInt

_SQLITE_LIMIT_ATTACHED :: CInt

_SQLITE_LIMIT_LIKE_PATTERN_LENGTH :: CInt

_SQLITE_LIMIT_VARIABLE_NUMBER :: CInt

Compiling An SQL Statement

sqlite3_prepare :: Ptr Sqlite3 -> CString -> CInt -> Ptr (Ptr Sqlite3_stmt) -> Ptr CString -> IO CInt

sqlite3_prepare_v2 :: Ptr Sqlite3 -> CString -> CInt -> Ptr (Ptr Sqlite3) -> Ptr CString -> IO CInt

sqlite3_prepare16 :: Ptr Sqlite3 -> Ptr () -> CInt -> Ptr (Ptr Sqlite3_stmt) -> Ptr (Ptr ()) -> IO CInt

sqlite3_prepare16_v2 :: Ptr Sqlite3 -> Ptr () -> CInt -> Ptr (Ptr Sqlite3_stmt) -> Ptr (Ptr ()) -> IO CInt

Retrieving Statement SQL

sqlite3_sql :: Ptr Sqlite3_stmt -> IO CString

Dynamically Typed Value Object

data Sqlite3_value

SQL Function Context Object

data Sqlite3_context

Binding Values To Prepared Statements

sqlite3_bind_blob :: Ptr Sqlite3_stmt -> CInt -> Ptr () -> CInt -> Sqlite3_destructor_type () -> IO CInt

sqlite3_bind_double :: Ptr Sqlite3_stmt -> CInt -> CDouble -> IO CInt

sqlite3_bind_int :: Ptr Sqlite3_stmt -> CInt -> CInt -> IO CInt

sqlite3_bind_int64 :: Ptr Sqlite3_stmt -> CInt -> Int64 -> IO CInt

sqlite3_bind_null :: Ptr Sqlite3_stmt -> CInt -> IO CInt

sqlite3_bind_text :: Ptr Sqlite3_stmt -> CInt -> CString -> CInt -> Sqlite3_destructor_type CString -> IO CInt

sqlite3_bind_text16 :: Ptr Sqlite3_stmt -> CInt -> Ptr () -> CInt -> Sqlite3_destructor_type () -> IO CInt

sqlite3_bind_value :: Ptr Sqlite3_stmt -> CInt -> Ptr Sqlite3_value -> IO CInt

sqlite3_bind_zeroblob :: Ptr Sqlite3_stmt -> CInt -> CInt -> IO CInt

Number Of SQL Parameters

sqlite3_bind_parameter_count :: Ptr Sqlite3_stmt -> IO CInt

Name Of A Host Parameter

sqlite3_bind_parameter_name :: Ptr Sqlite3_stmt -> CInt -> IO CString

Index Of A Parameter With A Given Name

sqlite3_bind_parameter_index :: Ptr Sqlite3_stmt -> CString -> IO CInt

Reset All Bindings On A Prepared Statement

sqlite3_clear_bindings :: Ptr Sqlite3_stmt -> IO CInt

Number Of Columns In A Result Set

sqlite3_column_count :: Ptr Sqlite3_stmt -> IO CInt

Column Names In A Result Set

sqlite3_column_name :: Ptr Sqlite3_stmt -> CInt -> IO CString

sqlite3_column_name16 :: Ptr Sqlite3_stmt -> CInt -> IO (Ptr ())

Source Of Data In A Query Result

sqlite3_column_database_name :: Ptr Sqlite3_stmt -> CInt -> IO CString

sqlite3_column_database_name16 :: Ptr Sqlite3_stmt -> CInt -> IO (Ptr ())

sqlite3_column_table_name :: Ptr Sqlite3_stmt -> CInt -> IO CString

sqlite3_column_table_name16 :: Ptr Sqlite3_stmt -> CInt -> IO (Ptr ())

sqlite3_column_origin_name :: Ptr Sqlite3_stmt -> CInt -> IO CString

sqlite3_column_origin_name16 :: Ptr Sqlite3_stmt -> CInt -> IO (Ptr ())

Declared Datatype Of A Query Result

sqlite3_column_decltype :: Ptr Sqlite3_stmt -> CInt -> IO CString

sqlite3_column_decltype16 :: Ptr Sqlite3_stmt -> CInt -> IO (Ptr ())

Evaluate An SQL Statement

sqlite3_step :: Ptr Sqlite3_stmt -> IO CInt

Number of columns in a result set

sqlite3_data_count :: Ptr Sqlite3_stmt -> IO CInt

Fundamental Datatypes

_SQLITE_INTEGER :: CInt

_SQLITE_FLOAT :: CInt

_SQLITE_BLOB :: CInt

_SQLITE_NULL :: CInt

_SQLITE3_TEXT :: CInt

Result Values From A Query

sqlite3_column_blob :: Ptr Sqlite3_stmt -> CInt -> IO (Ptr ())

sqlite3_column_bytes :: Ptr Sqlite3_stmt -> CInt -> IO CInt

sqlite3_column_bytes16 :: Ptr Sqlite3_stmt -> CInt -> IO CInt

sqlite3_column_double :: Ptr Sqlite3_stmt -> CInt -> IO CDouble

sqlite3_column_int :: Ptr Sqlite3_stmt -> CInt -> IO CInt

sqlite3_column_int64 :: Ptr Sqlite3_stmt -> CInt -> IO Int64

sqlite3_column_text :: Ptr Sqlite3_stmt -> CInt -> IO CString

sqlite3_column_text16 :: Ptr Sqlite3_stmt -> CInt -> IO (Ptr ())

sqlite3_column_type :: Ptr Sqlite3_stmt -> CInt -> IO CInt

sqlite3_column_value :: Ptr Sqlite3_stmt -> CInt -> IO (Ptr Sqlite3_value)

Destroy A Prepared Statement Object

sqlite3_finalize :: Ptr Sqlite3_stmt -> IO CInt

Reset A Prepared Statement Object

sqlite3_create_function :: Ptr Sqlite3 -> CString -> CInt -> CInt -> Ptr () -> FunPtr (Ptr Sqlite3_context -> CInt -> Ptr (Ptr Sqlite3_value) -> IO ()) -> FunPtr (Ptr Sqlite3_context -> CInt -> Ptr (Ptr Sqlite3_value) -> IO ()) -> FunPtr (Ptr Sqlite3_context -> IO ()) -> IO CInt

sqlite3_create_function16 :: Ptr Sqlite3 -> Ptr () -> CInt -> CInt -> Ptr () -> FunPtr (Ptr Sqlite3_context -> CInt -> Ptr (Ptr Sqlite3_value) -> IO ()) -> FunPtr (Ptr Sqlite3_context -> CInt -> Ptr (Ptr Sqlite3_value) -> IO ()) -> FunPtr (Ptr Sqlite3_context -> IO ()) -> IO CInt

Text Encodings

_SQLITE_UTF8 :: CInt

_SQLITE_UTF16LE :: CInt

_SQLITE_UTF16BE :: CInt

_SQLITE_UTF16 :: CInt

_SQLITE_ANY :: CInt

_SQLITE_UTF16_ALIGNED :: CInt

Obtaining SQL Function Parameter Values

sqlite3_value_blob :: Ptr Sqlite3_value -> IO (Ptr ())

sqlite3_value_bytes :: Ptr Sqlite3_value -> IO CInt

sqlite3_value_bytes16 :: Ptr Sqlite3_value -> IO CInt

sqlite3_value_double :: Ptr Sqlite3_value -> IO CDouble

sqlite3_value_int :: Ptr Sqlite3_value -> IO CInt

sqlite3_value_int64 :: Ptr Sqlite3_value -> IO Int64

sqlite3_value_text :: Ptr Sqlite3_value -> IO CString

sqlite3_value_text16 :: Ptr Sqlite3_value -> IO (Ptr ())

sqlite3_value_text16le :: Ptr Sqlite3_value -> IO (Ptr ())

sqlite3_value_text16be :: Ptr Sqlite3_value -> IO (Ptr ())

sqlite3_value_type :: Ptr Sqlite3_value -> IO CInt

sqlite3_value_numeric_type :: Ptr Sqlite3_value -> IO CInt

Obtain Aggregate Function Context

sqlite3_aggregate_context :: Ptr Sqlite3_context -> CInt -> IO (Ptr ())

User Data For Functions

sqlite3_user_data :: Ptr Sqlite3_context -> IO (Ptr ())

Database Connection For Functions

sqlite3_context_db_handle :: Ptr Sqlite3_context -> IO (Ptr Sqlite3)

Function Auxiliary Data

sqlite3_get_auxdata :: Ptr Sqlite3_context -> CInt -> IO (Ptr ())

sqlite3_set_auxdata :: Ptr Sqlite3_context -> CInt -> Ptr () -> Sqlite3_destructor_type () -> IO ()

Constants Defining Special Destructor Behavior

data Sqlite3_destructor_type a

_SQLITE_STATIC :: Sqlite3_destructor_type a

_SQLITE_TRANSIENT :: Sqlite3_destructor_type a

Setting The Result Of An SQL Function

sqlite3_result_blob :: Ptr Sqlite3_context -> Ptr () -> CInt -> Sqlite3_destructor_type () -> IO ()

sqlite3_result_double :: Ptr Sqlite3_context -> CDouble -> IO ()

sqlite3_result_error :: Ptr Sqlite3_context -> CString -> CInt -> IO ()

sqlite3_result_error16 :: Ptr Sqlite3_context -> Ptr () -> CInt -> IO ()

sqlite3_result_error_toobig :: Ptr Sqlite3_context -> IO ()

sqlite3_result_error_nomem :: Ptr Sqlite3_context -> IO ()

sqlite3_result_error_code :: Ptr Sqlite3_context -> CInt -> IO ()

sqlite3_result_int :: Ptr Sqlite3_context -> CInt -> IO ()

sqlite3_result_int64 :: Ptr Sqlite3_context -> Int64 -> IO ()

sqlite3_result_null :: Ptr Sqlite3_context -> IO ()

sqlite3_result_text :: Ptr Sqlite3_context -> CString -> CInt -> Sqlite3_destructor_type CString -> IO ()

sqlite3_result_text16 :: Ptr Sqlite3_context -> Ptr () -> CInt -> Sqlite3_destructor_type () -> IO ()

sqlite3_result_text16le :: Ptr Sqlite3_context -> Ptr () -> CInt -> Sqlite3_destructor_type () -> IO ()

sqlite3_result_text16be :: Ptr Sqlite3_context -> Ptr () -> CInt -> Sqlite3_destructor_type () -> IO ()

sqlite3_result_value :: Ptr Sqlite3_context -> Ptr Sqlite3_value -> IO ()

sqlite3_result_zeroblob :: Ptr Sqlite3_context -> CInt -> IO ()

Define New Collating Sequences

sqlite3_create_collation :: Ptr Sqlite3 -> CString -> CInt -> Ptr a -> FunPtr (Ptr a -> CInt -> Ptr () -> CInt -> Ptr () -> IO CInt) -> IO CInt

sqlite3_create_collation_v2 :: Ptr Sqlite3 -> CString -> CInt -> Ptr a -> FunPtr (Ptr a -> CInt -> Ptr () -> CInt -> Ptr () -> IO CInt) -> Sqlite3_destructor_type a -> IO CInt

sqlite3_create_collation16 :: Ptr Sqlite3 -> Ptr () -> CInt -> Ptr a -> FunPtr (Ptr a -> CInt -> Ptr () -> CInt -> Ptr () -> IO CInt) -> IO CInt

Collation Needed Callbacks

sqlite3_collation_needed :: Ptr Sqlite3 -> Ptr a -> FunPtr (Ptr a -> Ptr Sqlite3 -> CInt -> CString -> IO ()) -> IO CInt

sqlite3_collation_needed16 :: Ptr Sqlite3 -> Ptr a -> FunPtr (Ptr a -> Ptr Sqlite3 -> CInt -> Ptr () -> IO ()) -> IO CInt

Suspend Execution For A Short Time

sqlite3_sleep :: CInt -> IO CInt

Name Of The Folder Holding Temporary Files

sqlite_temp_directory :: GlobalVariable CString

Test For Auto-Commit Mode

sqlite3_get_autocommit :: Ptr Sqlite3 -> IO CInt

Find The Database Handle Of A Prepared Statement

sqlite3_db_handle :: Ptr Sqlite3_stmt -> IO (Ptr Sqlite3)

Find the next prepared statement

sqlite3_next_stmt :: Ptr Sqlite3 -> Ptr Sqlite3_stmt -> IO (Ptr Sqlite3_stmt)

Commit And Rollback Notification Callbacks

sqlite3_commit_hook :: Ptr Sqlite3 -> FunPtr (Ptr a -> IO CInt) -> Ptr a -> IO (Ptr ())

sqlite3_rollback_hook :: Ptr Sqlite3 -> FunPtr (Ptr a -> IO ()) -> Ptr a -> IO (Ptr ())

Data Change Notification Callbacks

sqlite3_update_hook :: Ptr Sqlite3 -> FunPtr (Ptr a -> CInt -> CString -> CString -> Int64 -> IO ()) -> Ptr a -> IO (Ptr ())

Enable Or Disable Shared Pager Cache

sqlite3_enable_shared_cache :: CInt -> IO CInt

Attempt To Free Heap Memory

sqlite3_release_memory :: CInt -> IO CInt

Impose A Limit On Heap Size

sqlite3_soft_heap_limit :: CInt -> IO ()

Load An Extension

sqlite3_load_extension :: Ptr Sqlite3 -> CString -> CString -> Ptr CString -> IO CInt

Enable Or Disable Extension Loading

sqlite3_enable_load_extension :: Ptr Sqlite3 -> CInt -> IO CInt

Automatically Load An Extensions

sqlite3_auto_extension :: FunPtr (IO ()) -> IO CInt

Reset Automatic Extension Loading

sqlite3_reset_auto_extension :: IO ()

A Handle To An Open BLOB

data Sqlite3_blob

Open A BLOB For Incremental I/O

sqlite3_blob_open :: Ptr Sqlite3 -> CString -> CString -> CString -> Int64 -> CInt -> Ptr (Ptr Sqlite3_blob) -> IO CInt

Close A BLOB Handle

sqlite3_blob_close :: Ptr Sqlite3_blob -> IO CInt

Return The Size Of An Open BLOB

sqlite3_blob_bytes :: Ptr Sqlite3_blob -> IO CInt

Read Data From A BLOB Incrementally

sqlite3_blob_read :: Ptr Sqlite3_blob -> Ptr () -> CInt -> CInt -> IO CInt

Write Data Into A BLOB Incrementally

sqlite3_blob_write :: Ptr Sqlite3_blob -> Ptr () -> CInt -> CInt -> IO CInt

Virtual File System Objects

sqlite3_vfs_find :: CString -> Ptr Sqlite3_vfs

sqlite3_vfs_register :: Ptr Sqlite3_vfs -> CInt -> IO CInt

sqlite3_vfs_unregister :: Ptr Sqlite3_vfs -> IO CInt

Mutexes

sqlite3_mutex_alloc :: CInt -> IO (Ptr Sqlite3_mutex)

sqlite3_mutex_free :: Ptr Sqlite3_mutex -> IO ()

sqlite3_mutex_enter :: Ptr Sqlite3_mutex -> IO ()

sqlite3_mutex_try :: Ptr Sqlite3_mutex -> IO CInt

sqlite3_mutex_leave :: Ptr Sqlite3_mutex -> IO ()

Mutex Verification Routines

sqlite3_mutex_held :: Ptr Sqlite3_mutex -> IO CInt

sqlite3_mutex_notheld :: Ptr Sqlite3_mutex -> IO CInt

Mutex Types

_SQLITE_MUTEX_FAST :: CInt

_SQLITE_MUTEX_RECURSIVE :: CInt

_SQLITE_MUTEX_STATIC_MASTER :: CInt

_SQLITE_MUTEX_STATIC_MEM :: CInt

_SQLITE_MUTEX_STATIC_MEM2 :: CInt

_SQLITE_MUTEX_STATIC_PRNG :: CInt

_SQLITE_MUTEX_STATIC_LRU :: CInt

_SQLITE_MUTEX_STATIC_LRU2 :: CInt

Retrieve the mutex for a database connection

sqlite3_db_mutex :: Ptr Sqlite3 -> IO (Ptr Sqlite3_mutex)

Low-Level Control Of Database Files

sqlite3_file_control :: Ptr Sqlite3 -> CString -> CInt -> Ptr () -> IO CInt