在线文档教程

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

SQLite Runtime Status

SQLite Runtime Status

int sqlite3_status(int op, int *pCurrent, int *pHighwater, int resetFlag
int sqlite3_status64(
  int op,
  sqlite3_int64 *pCurrent,
  sqlite3_int64 *pHighwater,
  int resetFlag

这些接口用于检索有关SQLite性能的运行时状态信息，并可以选择重置各种高水位标记。第一个参数是要测量的特定参数的整数代码。已识别的整数代码格式为SQLITE_STATUS _....参数的当前值返回* pCurrent。最高记录值在* pH值水中返回。如果resetFlag为true，那么在写入* pHighwater后将重置最高记录值。有些参数不记录最高值。对于这些参数，没有任何内容写入* pHighwater，并且resetFlag被忽略。其他参数仅记录高位标记而不记录当前值。对于这些后面的参数，没有任何内容写入* pCurrent。

sqlite3_status() 和sqlite3_status64() 例程在成功时返回SQLITE_OK，并在失败时返回非零错误代码。

如果当前值或高位标记太大而不能用32位整数表示，则由sqlite3_status() 返回的值未定义。