在线文档教程

首页技术教程开发文档觅分类 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 教程

Experimental Interfaces

实验界面

实验和弃用的接口

SQLite接口可以细分为三类：

Stable

2. Experimental

3. Deprecated

稳定的接口将以向后兼容的方式无限期地保持。仅使用稳定接口的应用程序应始终能够在不做任何更改的情况下重新链接到较新版本的SQLite。

实验界面可能会改变。升级到较新版本的SQLite时，可能需要修改使用实验接口的应用程序，尽管这很少见。当新接口添加到SQLite时，它们通常以实验性接口开始。接口使用一段时间后，开发人员确信接口设计合理且值得长期支持，接口标记为稳定。

已弃用的接口已被更好的完成同样事情的方法取代，应该在新的应用程序中避免。为了向后兼容，继续支持不推荐使用的接口。在将来的某个时候，可能会删除不推荐使用的接口。

关键点：

实验接口可随时更改和/或删除。

不推荐使用的接口不应在新代码中使用，并可能在将来的某些版本中删除。

 SQLite is in the Public Domain.