在线文档教程

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

Test To See If The Library Is Threadsafe

Test To See If The Library Is Threadsafe

int sqlite3_threadsafe(void

当且仅当由于SQLITE_THREADSAFE编译时选项被设置为0而忽略了忽略代码才编译SQLite时，sqlite3_threadsaf()函数返回零。

可以使用或不使用互斥锁来编译SQLite。当SQLITE_THREADSAFE C预处理器宏为1或2时，启用互斥锁并且SQLite是线程安全的。当SQLITE_THREADSAFE宏为0时，互斥体被省略。没有互斥锁，从多个线程同时使用SQLite是不安全的。

启用互斥体会导致可衡量的性能损失。所以如果速度是最重要的，那么禁用互斥体就有意义了。但为了最大限度的安全，应该启用互斥锁。默认行为是为了启用互斥锁。

应用程序可以使用此接口来确保它所链接的SQLite版本是使用所需的SQLITE_THREADSAFE宏设置编译的。

此接口仅报告SQLITE_THREADSAFE标志的编译时互斥设置。如果SQLite是与SQLITE_THREADSAFE编译= 1或= 2则互斥默认启用但可以使用一个呼叫到sqlite3_config()与动词SQLITE_CONFIG_SINGLETHREAD，SQLITE_CONFIG_MULTITHREAD，或SQLITE_CONFIG_SERIALIZED是完全或部分关闭。sqlite3_threadsafe()函数的返回值仅显示线程安全性的编译时设置，而不是sqlite3_config()对该设置的任何运行时更改。换句话说，sqlite3_threadsafe()的返回值不会因调用sqlite3_config()而改变。

有关其他信息，请参阅线程模式文档。