在线文档教程

首页技术教程开发文档觅分类 ICON图标

技术教程开发文档觅分类 ICON图标

Immutable 3.8.1

C界面 | C Interface

64-Bit Integer Types

A Handle To An Open BLOB

An Introduction To The SQLite C/C++ Interface

Application Defined Page Cache

Attempt To Free Heap Memory

Authorizer Action Codes

Authorizer Return Codes

Automatically Load Statically Linked Extensions

Binding Values To Prepared Statements

C/C++ Interface For SQLite Version 3

C/C++ Interface For SQLite Version 3 (old)

Cancel Automatic Extension Loading

Checkpoint a database

Checkpoint a database

Checkpoint Mode Values

Close A BLOB Handle

Closing A Database Connection

Collation Needed Callbacks

Column Names In A Result Set

Commit And Rollback Notification Callbacks

Compare the ages of two snapshot handles

Compile-Time Authorization Callbacks

Compile-Time Library Version Numbers

Compiling An SQL Statement

Configuration Options

Configure an auto-checkpoint

Configure database connections

Configuring The SQLite Library

Conflict resolution modes

Constants Defining Special Destructor Behavior

Convenience Routines For Running Queries

Copy And Free SQL Values

Count The Number Of Rows Modified

Create Or Redefine SQL Functions

Custom Page Cache Object

Custom Page Cache Object

Data Change Notification Callbacks

Database Connection Configuration Options

Database Connection For Functions

Database Connection Handle

Database Connection Status

Database Snapshot

Declare The Schema Of A Virtual Table

Declared Datatype Of A Query Result

Define New Collating Sequences

Deprecated Functions

Deprecated Soft Heap Limit Interface

Destroy A Prepared Statement Object

Destroy a snapshot

Determine if a database is read-only

Determine If A Prepared Statement Has Been Reset

Determine If An SQL Statement Is Complete

Determine If An SQL Statement Writes The Database

Determine The Virtual Table Conflict Policy

Device Characteristics

Dynamically Typed Value Object

Enable Or Disable Extended Result Codes

Enable Or Disable Extension Loading

Enable Or Disable Shared Pager Cache

Error Codes And Messages

Error Logging Interface

Evaluate An SQL Statement

Experimental Interfaces

Extended Result Codes

Extract Metadata About A Column Of A Table

File Locking Levels

Find The Database Handle Of A Prepared Statement

Find the next prepared statement

Finding The Subtype Of SQL Values

Flags For File Open Operations

Flags for the xAccess VFS method

Flags for the xShmLock VFS method

Flush caches to disk mid-transaction

Formatted String Printing Functions

Free Memory Used By A Database Connection

Function Auxiliary Data

Fundamental Datatypes

Impose A Limit On Heap Size

Index Of A Parameter With A Given Name

Initialize The SQLite Library

Interrupt A Long-Running Query

Last Insert Rowid

List Of SQLite Constants

List Of SQLite Objects

Load An Extension

Loadable Extension Thunk

Low-Level Control Of Database Files

Low-level system error code

Maximum xShmLock index

Memory Allocation Routines

Memory Allocation Subsystem

Memory Allocator Statistics

Move a BLOB Handle to a New Row

Mutex Methods Object

Mutex Verification Routines

Name Of A Host Parameter

Name Of The Folder Holding Database Files

Name Of The Folder Holding Temporary Files

Number Of Columns In A Result Set

Number of columns in a result set

Number Of SQL Parameters

Obtain Aggregate Function Context

Obtain Values For URI Parameters

Obtaining SQL Values

One-Step Query Execution Interface

Online Backup API

Online Backup Object

Open A BLOB For Incremental I/O

Opening A New Database Connection

OS Interface File Virtual Methods Object

OS Interface Open File Handle

Overload A Function For A Virtual Table

Prepared Statement Object

Prepared Statement Scan Status

Prepared Statement Scan Status Opcodes

Prepared Statement Status

Pseudo-Random Number Generator

Query Progress Callbacks

Read Data From A BLOB Incrementally

Record A Database Snapshot

Recover snapshots from a wal file

Register A Callback To Handle SQLITE_BUSY Errors

Register A Virtual Table Implementation

Reset A Prepared Statement Object

Reset All Bindings On A Prepared Statement

Reset Automatic Extension Loading

Result Values From A Query

Retrieve the mutex for a database connection

Retrieving Statement SQL

Return The Filename For A Database Connection

Return The Size Of An Open BLOB

Run-Time Library Compilation Options Diagnostics

Run-Time Library Version Numbers

Run-Time Limit Categories

Run-time Limits

Set A Busy Timeout

Set the Last Insert Rowid value

Setting The Result Of An SQL Function

Setting The Subtype Of An SQL Function

Source Of Data In A Query Result

SQL Function Context Object

SQL Trace Event Codes

SQLite Runtime Status

Standard File Control Opcodes

Start a read transaction on an historical snapshot

Status Parameters

Status Parameters for database connections

Status Parameters for prepared statements

String Comparison

String Globbing

String LIKE Matching

Suspend Execution For A Short Time

Synchronization Type Flags

Test For Auto-Commit Mode

Test To See If The Library Is Threadsafe

Testing Interface

Testing Interface Operation Codes

The C language interface to SQLite Version 2

The Carray() Table-Valued Function

The pre-update hook

Total Number Of Rows Modified

Tracing And Profiling Functions

Unlock Notification

User Data For Functions

Virtual File System Objects

Virtual Table Configuration Options

Virtual Table Constraint Operator Codes

Virtual Table Cursor Object

Virtual Table Indexing Information

Virtual Table Instance Object

Virtual Table Interface Configuration

Virtual Table Object

Virtual Table Scan Flags

Write Data Into A BLOB Incrementally

Write-Ahead Log Commit Hook

Zero Scan-Status Counters

C Interface: Session Module

数据库文件表 | Database File Format

数据类 | Datatypes

动态内存分配 | Dynamic Memory Allocation

外键约束 | Foreign Key Constraints

全文索引 | Full-Text Search

损坏方式 | How To Corrupt

语言 | Language

局限性 | Limits

锁定和并发 | Locking and Concurrency

其他 | Miscellaneous

PRAGMA Statements

查询计划程序 | Query Planner

语法图 | Syntax Diagrams

虚拟表机制 | Virtual Table Mechanism

预写日志 | Write-Ahead Logging

TensorFlow Guide

Storm入门教程

Hibernate 教程

Virtual File System Objects

Virtual File System Objects

sqlite3_vfs *sqlite3_vfs_find(const char *zVfsName
int sqlite3_vfs_register(sqlite3_vfs*, int makeDflt
int sqlite3_vfs_unregister(sqlite3_vfs*

虚拟文件系统(VFS)是SQLite用来与底层操作系统进行交互的sqlite3_vfs对象。大多数SQLite版本都有一个适用于主机的默认VFS。新的VFS可以被注册并且现有的VFS可以被注销。提供以下接口。

sqlite3_vfs_find()接口返回一个指向名字的VFS的指针。名称区分大小写。名称是零终止的UTF-8字符串。如果不匹配，则返回NULL指针。如果zVfsName为NULL，则返回默认的VFS。

新的VFS使用sqlite3_vfs_register()进行注册。如果设置了makeDflt标志，则每个新的VFS都将成为默认的VFS。相同的VFS可以多次登记而不受伤害。要将现有VFS设置为默认VFS，请使用makeDflt标志设置重新注册它。如果注册了两个具有相同名称的不同VFS，则行为未定义。如果VFS注册的名称为NULL或空字符串，则行为未定义。

使用sqlite3_vfs_unregister()接口取消注册VFS。如果默认VFS未注册，则选择另一个VFS作为默认值。新VFS的选择是任意的。

 SQLite is in the Public Domain.