在线文档教程
首页 技术教程 开发文档 觅分类 ICON图标
技术教程 开发文档 觅分类 ICON图标
Bootstrap 4
Bootstrap 3
C
C++
Clojure 1.8
Codeigniter 3
CSS
Docker 17
Electron
Elixir 1.5
Erlang 20
Eslint
Express
Git
Go
HTML
HTTP
Immutable 3.8.1
JavaScript
Lodash 4
Lua 5.3
Nginx
PHP
Phpunit 6
Python
React
React native
Redis
Redux
Ruby 2.4
Sass
Scikit image
Socket.IO
Sqlite
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
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
Function Flags
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
Introduction
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 Handle
Mutex Methods Object
Mutex Types
Mutex Verification Routines
Mutexes
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
Prepare Flags
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 Codes
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
SQL Trace Hook
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
Text Encodings
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
CLI
数据库文件表 | Database File Format
数据类 | Datatypes
动态内存分配 | Dynamic Memory Allocation
外键约束 | Foreign Key Constraints
全文索引 | Full-Text Search
损坏方式 | How To Corrupt
JSON
语言 | Language
局限性 | Limits
锁定和并发 | Locking and Concurrency
其他 | Miscellaneous
PRAGMA Statements
查询计划程序 | Query Planner
R*Tree Module
RBU Extension
语法图 | Syntax Diagrams
Tcl Interface
虚拟表机制 | Virtual Table Mechanism
预写日志 | Write-Ahead Logging
SVG
TensorFlow Guide
Typescript
Underscore
Vue 2
Webpack
Xslt & Xpath
Yarn
RxJS 5
Rollup.js
Babel
Parcel
MobX
Koa
Angular
Gulp
Grunt
Stylelint
Standard JS
Element UI
iView UI
Lavas
Mint UI
PostCSS
ThinkJS
Nest
npm
Node.js教程
JSON教程
Groovy教程
vb.net教程
Storm入门教程
Hibernate 教程
Slick教程
MongoDB教程
Yii 2.0

Checkpoint Mode Values

Checkpoint Mode Values

#define SQLITE_CHECKPOINT_PASSIVE  0  /* Do as much as possible w/o blocking */
#define SQLITE_CHECKPOINT_FULL     1  /* Wait for writers, then checkpoint */
#define SQLITE_CHECKPOINT_RESTART  2  /* Like FULL but wait for for readers */
#define SQLITE_CHECKPOINT_TRUNCATE 3  /* Like RESTART but also truncate WAL */

这些常量为作为第三个参数传递给sqlite3_wal_checkpoint_v2()接口的“检查点模式”定义所有有效值。有关每个检查点模式的含义，请参阅sqlite3_wal_checkpoint_v2()文档。

参见对象、常量和函数列表。

 SQLite is in the Public Domain.

https://sqlite.org/c3ref/c_checkpoint_full.html

  • 黔ICP备2021005045号