SQLite Documentation
Introduction
1.
Categorical Index Of SQLite Documents
2.
Overview Documents
2.1.
About SQLite
2.2.
Appropriate Uses For SQLite
2.3.
Distinctive Features Of SQLite
2.4.
How SQLite Is Tested
2.5.
SQLite Is Public Domain
2.6.
Frequently Asked Questions
2.7.
Books About SQLite
2.8.
Alphabetical List Of SQLite Documents
2.9.
Website Keyword Index
2.10.
Permuted Title Index
3.
SQLite Programming Interfaces
3.1.
SQLite In 5 Minutes Or Less
3.2.
An Introduction To The SQLite C/C++ Interface
3.3.
How To Compile SQLite
3.4.
C-language Interface Specification for SQLite
3.5.
SQLite Result Codes
3.6.
The Tcl interface to the SQLite library
3.7.
SQL As Understood By SQLite
3.8.
PRAGMA Statements
3.9.
SQL As Understood By SQLite
3.10.
SQL As Understood By SQLite
3.11.
SQL As Understood By SQLite
3.12.
The JSON1 Extension
3.13.
Datatypes In SQLite Version 3
4.
SQLite Features and Extensions
4.1.
SQLite And 8+3 Filenames
4.2.
Autoincrement In SQLite
4.3.
Using the SQLite Online Backup API
4.4.
Command Line Shell For SQLite
4.5.
The Error And Warning Log
4.6.
SQLite Foreign Key Support
4.7.
SQLite FTS3 and FTS4 Extensions
4.8.
Appendix A: Search Application Tips
4.9.
Indexes On Expressions
4.10.
Internal Versus External BLOBs in SQLite
4.11.
Limits In SQLite
4.12.
Memory-Mapped I/O
4.13.
SQLite And Multiple Threads
4.14.
NULL Handling in SQLite Versus Other Database Engines
4.15.
Partial Indexes
4.16.
The SQLite R*Tree Module
4.17.
Run-Time Loadable Extensions
4.18.
Shared Cache Mode
4.19.
Using the sqlite3_unlock_notify() API
4.20.
URI Filenames
4.21.
The WITHOUT ROWID Optimization
4.22.
Write-Ahead Logging
5.
Advocacy
5.1.
SQLite As An Application File Format
5.2.
Well-Known Users of SQLite
6.
SQLite Technical/Design Documentation
6.1.
How To Corrupt An SQLite Database File
6.2.
SQLite's Use Of Temporary Disk Files
6.3.
In-Memory Databases
6.4.
Atomic Commit In SQLite
6.5.
Dynamic Memory Allocation In SQLite
6.6.
Custom Builds Of SQLite
6.7.
Locking And Concurrency In SQLite Version 3
6.8.
Isolation In SQLite
6.9.
The SQLite Query Planner
6.10.
The Next Generation Query Planner
6.11.
The Architecture Of SQLite
6.12.
The SQLite Virtual Machine
6.13.
The SQLite OS Interface or "VFS"
6.14.
The Virtual Table Mechanism Of SQLite
6.15.
The SQLite Database File Format
6.16.
1.0 Compilation Options For SQLite
7.
Upgrading SQLite, Backwards Compatibility
7.1.
Moving From SQLite 3.5.9 to 3.6.0
7.2.
Moving From SQLite 3.4.2 to 3.5.0
7.3.
Release History
7.4.
File Format Changes in SQLite
7.5.
Maintaining Private Branches Of SQLite
8.
Obsolete Documents
8.1.
An Asynchronous I/O Module For SQLite
8.2.
The C language interface to SQLite Version 2
8.3.
Datatypes In SQLite Version 2
8.4.
The Virtual Database Engine of SQLite
8.5.
SQLite Version 3 Overview
8.6.
C/C++ Interface For SQLite Version 3
8.7.
Database Speed Comparison
Powered by
GitBook
SQLite Documentation
Upgrading SQLite, Backwards Compatibility