SQLite
C Api
- 64-Bit Integer Types
- A Handle To An Open BLOB
- Add Content To A Dynamic String
- Allowed return values from sqlite3_txn_state()
- Application Defined Page Cache.
- Attempt To Free Heap Memory
- Authorizer Action Codes
- Authorizer Return Codes
- Automatically Load Statically Linked Extensions
- Autovacuum Compaction Amount Callback
- Bind array values to the CARRAY table-valued function
- Binding Values To Prepared Statements
- Cancel Automatic Extension Loading
- Change The EXPLAIN Setting For A Prepared Statement
- 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
- Constraint values in xBestIndex()
- Convenience Routines For Running Queries
- Copy And Free SQL Values
- Count The Number Of Rows Modified
- Create A New Dynamic String Object
- Create and Destroy VFS Filenames
- Create Or Redefine SQL Functions
- Custom Page Cache Object
- Custom Page Cache Object
- Data Change Notification Callbacks
- Database Connection Client Data
- Database Connection Configuration Options
- Database Connection For Functions
- Database Connection Handle
- Database Connection Status
- Database File Corresponding To A Journal
- Database Snapshot
- Datatypes for the CARRAY table-valued function
- Declare The Schema Of A Virtual Table
- Declared Datatype Of A Query Result
- Define New Collating Sequences
- Deprecated Functions
- Deprecated Soft Heap Limit Interface
- Deprecated Tracing And Profiling Functions
- Deserialize a database
- 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 a virtual table query is DISTINCT
- Determine If An SQL Statement Is Complete
- Determine If An SQL Statement Writes The Database
- Determine If Virtual Table Column Access Is For UPDATE
- Determine The Collation For a Virtual Table Constraint
- Determine the transaction state of a database
- Determine The Virtual Table Conflict Policy
- Device Characteristics
- Dynamic String Object
- 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
- File Name
- Finalize A Dynamic String
- Find all elements on the right-hand side of an IN constraint.
- 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 sqlite3_deserialize()
- Flags for sqlite3_serialize
- Flags for sqlite3_setlk_timeout()
- 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
- Identify and handle IN constraints in xBestIndex
- 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 Functions
- 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 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
- Prepared Statement Scan Status Opcodes
- Prepared Statement Status
- Pseudo-Random Number Generator
- Query Progress Callbacks
- Query The EXPLAIN Setting For A Prepared Statement
- 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
- Remove Unnecessary Virtual Table Implementations
- Report the internal text encoding state of an sqlite3_value object
- 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 Schema Name 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
- Serialize a database
- Set A Busy Timeout
- Set Error Code And Message
- Set the Last Insert Rowid value.
- Set the Setlk Timeout
- 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 Keyword Checking
- SQL Trace Event Codes
- SQL Trace Hook
- SQLite Runtime Status
- Standard File Control Opcodes
- Start a read transaction on an historical snapshot
- Status Of A Dynamic String
- 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 pre-update hook.
- Total Number Of Rows Modified
- Translate filenames
- 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
- Win32 Directory Types
- Win32 Specific Interface
- Write Data Into A BLOB Incrementally
- Write-Ahead Log Commit Hook
- Zero Scan-Status Counters
Guides
- 35% Faster Than The Filesystem
- 8+3 Filenames
- About SQLite
- Add a 64-bit integer to a changegroup
- Add a blob to a changegroup
- Add A Changeset To A Changegroup
- Add a NULL to a changegroup
- Add a Schema to a Changegroup
- Add A Single Change To A Changegroup
- Add a text value to a changegroup
- Add an double to a changegroup
- Advance A Changeset Iterator
- Alphabetical List Of SQLite Documents
- An Introduction To The SQLite C/C++ Interface
- Application-Defined SQL Functions
- Apply A Changeset To A Database
- Appropriate Uses For SQLite
- Architecture of SQLite
- Atomic Commit In SQLite
- Attach A Table To A Session Object
- Automatic Undo/Redo With SQLite
- Backlink Crossreference
- Begin adding a change to a changegroup
- Benefits of SQLite As A File Format
- Books About SQLite
- Bridging Tcl and JSON with the SQLite Extension
- C/C++ Interface For SQLite Version 3 (old)
- Change in Default Page Size in SQLite Version 3.12.0
- Changegroup Handle
- Changeset Iterator Handle
- Clustered Indexes and the WITHOUT ROWID Optimization
- Code Of Conduct
- Code Of Ethics
- Compile-time Options
- Concatenate Two Changeset Objects
- Configure a changegroup object
- Configure a changeset rebaser object.
- Configure a Session Object
- Configure global parameters
- Constants Passed To The Conflict Handler
- Constants Returned By The Conflict Handler
- Constraint Conflict Resolution in SQLite
- Create a changeset rebaser object.
- Create A New Changegroup Object
- Create A New Session Object
- Create An Iterator To Traverse A Changeset
- Custom Builds Of SQLite
- Database File Format
- Database File Format
- Database Remote-Copy Tool For SQLite
- Datatypes In SQLite
- Datatypes In SQLite version 2
- Defense Against The Dark Arts
- Delete A Changegroup Object
- Delete a changeset rebaser object.
- Delete A Session Object
- Determine The Number Of Foreign Key Constraint Violations
- Deterministic SQL Functions
- Distinctive Features Of SQLite
- Dynamic Memory Allocation In SQLite
- Enable Or Disable A Session Object
- EXPLAIN QUERY PLAN
- Features Of SQLite
- File Format Changes in SQLite
- File Locking And Concurrency In SQLite Version 3
- Finalize A Changeset Iterator
- Finish adding one-at-at-time changes to a changegroup
- Flags for sqlite3changeset_apply_v2
- Flags for sqlite3changeset_start_v2
- Floating Point Numbers
- Full-Featured SQL
- Generate A Changeset From A Session Object
- Generate A Patchset From A Session Object
- Generated Columns
- High Reliability
- Hints for Debugging SQLite
- History Of SQLite Releases
- How SQLite Is Tested
- How SQLite Works
- How To Compile SQLite
- How To Corrupt An SQLite Database File
- How To Download Canonical SQLite Source Code
- Implementation Limits For SQLite
- Imposter Tables
- In-Memory Databases
- Indexes On Expressions
- Internal Versus External BLOBs
- Introduction
- Invalid UTF Policy
- Invert A Changeset
- Isolation In SQLite
- Javascript Required
- Keyword Crossreference
- List Of SQLite Constants
- List Of SQLite Functions
- List Of SQLite Objects
- List Of Virtual Tables
- Load The Difference Between Tables Into A Session
- LoC Recommended Storage Format
- Long Term Support
- Maintaining Private Branches Of SQLite
- Many Small Queries Are Efficient In SQLite
- Measuring and Reducing CPU Usage in SQLite
- Memory-Mapped I/O
- Most Widely Deployed SQL Database Engine
- No Title
- NUL Characters In Strings
- NULL Handling in SQLite
- Obtain A Composite Changeset From A Changegroup
- Obtain Conflicting Row Values From A Changeset Iterator
- Obtain new.* Values From A Changeset Iterator
- Obtain old.* Values From A Changeset Iterator
- Obtain The Current Operation From A Changeset Iterator
- Obtain The Primary Key Definition Of A Table
- Options for sqlite3changegroup_config().
- Options for sqlite3session_object_config
- Pagelink Crossreference
- Partial Indexes
- Pointer Passing Interfaces
- Powersafe Overwrite
- Pressrelease 20071212
- Profiling SQL Queries
- Quality Management
- Query for the amount of heap memory used by a session object.
- Query Language Understood by SQLite
- Query Planning
- Query Result Formatting In The CLI
- Quirks, Caveats, and Gotchas In SQLite
- Rebase a changeset
- Rebasing changesets
- Recent SQLite News
- Recovering Data From A Corrupt SQLite Database
- Release History Of SQLite
- Result and Error Codes
- Return An Upper-limit For The Size Of The Changeset
- Row Values
- Rowid Tables
- Run-Time Loadable Extensions
- Set a table filter on a Session Object.
- Set Or Clear the Indirect Change Flag
- Single File Database
- SQL Features That SQLite Does Not Implement
- sqldiff.exe: Database Difference Utility
- Sqlite
- SQLite As An Application File Format
- SQLite Autoincrement
- SQLite Changes From Version 3.4.2 To 3.5.0
- SQLite Changes From Version 3.5.9 To 3.6.0
- SQLite Consortium
- SQLite Consortium Agreement
- SQLite Copyright
- SQLite Copyright Release Template
- SQLite Database Speed Comparison
- SQLite Developers
- SQLite Documentation
- SQLite Download Page
- SQLite Foreign Key Support
- SQLite Frequently Asked Questions
- SQLite Home Page
- SQLite In 5 Minutes Or Less
- SQLite is a Self Contained System
- SQLite Is Serverless
- SQLite Is Transactional
- SQLite Library Footprint
- SQLite Older News
- SQLite Over a Network, Caveats and Considerations
- SQLite Pro Support
- SQLite Release 3.0.0 On 2004-06-18
- SQLite Release 3.0.1 On 2004-06-22
- SQLite Release 3.0.2 On 2004-06-30
- SQLite Release 3.0.3 On 2004-07-22
- SQLite Release 3.0.4 On 2004-08-09
- SQLite Release 3.0.5 On 2004-08-29
- SQLite Release 3.0.6 On 2004-09-02
- SQLite Release 3.0.7 On 2004-09-18
- SQLite Release 3.0.8 On 2004-10-12
- SQLite Release 3.1.0 On 2005-01-21
- SQLite Release 3.1.1 On 2005-02-01
- SQLite Release 3.1.2 On 2005-02-15
- SQLite Release 3.1.3 On 2005-02-19
- SQLite Release 3.1.4 On 2005-03-11
- SQLite Release 3.1.5 On 2005-03-11
- SQLite Release 3.1.6 On 2005-03-17
- SQLite Release 3.10.0 On 2016-01-06
- SQLite Release 3.10.1 On 2016-01-14
- SQLite Release 3.10.2 On 2016-01-20
- SQLite Release 3.11.0 On 2016-02-15
- SQLite Release 3.11.1 On 2016-03-03
- SQLite Release 3.12.0 On 2016-03-29
- SQLite Release 3.12.1 On 2016-04-08
- SQLite Release 3.12.2 On 2016-04-18
- SQLite Release 3.13.0 On 2016-05-18
- SQLite Release 3.14 On 2016-08-08
- SQLite Release 3.14.1 On 2016-08-11
- SQLite Release 3.14.2 On 2016-09-12
- SQLite Release 3.15.0 On 2016-10-14
- SQLite Release 3.15.1 On 2016-11-04
- SQLite Release 3.15.2 On 2016-11-28
- SQLite Release 3.16.0 On 2017-01-02
- SQLite Release 3.16.1 On 2017-01-03
- SQLite Release 3.16.2 On 2017-01-06
- SQLite Release 3.17.0 On 2017-02-13
- SQLite Release 3.18.0 On 2017-03-30
- SQLite Release 3.18.1 On 2017-06-16
- SQLite Release 3.18.2 On 2017-06-17
- SQLite Release 3.19.0 On 2017-05-22
- SQLite Release 3.19.1 On 2017-05-24
- SQLite Release 3.19.2 On 2017-05-25
- SQLite Release 3.19.3 On 2017-06-08
- SQLite Release 3.2.0 On 2005-03-21
- SQLite Release 3.2.1 On 2005-03-29
- SQLite Release 3.2.2 On 2005-06-12
- SQLite Release 3.2.3 On 2005-08-21
- SQLite Release 3.2.4 On 2005-08-24
- SQLite Release 3.2.5 On 2005-08-27
- SQLite Release 3.2.6 On 2005-09-17
- SQLite Release 3.2.7 On 2005-09-24
- SQLite Release 3.2.8 On 2005-12-19
- SQLite Release 3.20.0 On 2017-08-01
- SQLite Release 3.20.1 On 2017-08-24
- SQLite Release 3.21.0 On 2017-10-24
- SQLite Release 3.22.0 On 2018-01-22
- SQLite Release 3.23.0 On 2018-04-02
- SQLite Release 3.23.1 On 2018-04-10
- SQLite Release 3.24.0 On 2018-06-04
- SQLite Release 3.25.0 On 2018-09-15
- SQLite Release 3.25.1 On 2018-09-18
- SQLite Release 3.25.2 On 2018-09-25
- SQLite Release 3.25.3 On 2018-11-05
- SQLite Release 3.26.0 On 2018-12-01
- SQLite Release 3.27.0 On 2019-02-07
- SQLite Release 3.27.1 On 2019-02-08
- SQLite Release 3.27.2 On 2019-02-25
- SQLite Release 3.28.0 On 2019-04-16
- SQLite Release 3.29.0 On 2019-07-10
- SQLite Release 3.3.0 On 2006-01-11
- SQLite Release 3.3.1 On 2006-01-16
- SQLite Release 3.3.10 On 2007-01-09
- SQLite Release 3.3.11 On 2007-01-22
- SQLite Release 3.3.12 On 2007-01-27
- SQLite Release 3.3.13 On 2007-02-13
- SQLite Release 3.3.14 On 2007-04-02
- SQLite Release 3.3.15 On 2007-04-09
- SQLite Release 3.3.16 On 2007-04-18
- SQLite Release 3.3.17 On 2007-04-25
- SQLite Release 3.3.2 On 2006-01-24
- SQLite Release 3.3.3 On 2006-01-31
- SQLite Release 3.3.4 On 2006-02-11
- SQLite Release 3.3.5 On 2006-04-05
- SQLite Release 3.3.6 On 2006-06-06
- SQLite Release 3.3.7 On 2006-08-12
- SQLite Release 3.3.8 On 2006-10-09
- SQLite Release 3.3.9 On 2007-01-04
- SQLite Release 3.30.0 On 2019-10-04
- SQLite Release 3.30.1 On 2019-10-10
- SQLite Release 3.31.0 On 2020-01-22
- SQLite Release 3.31.1 On 2020-01-27
- SQLite Release 3.32.0 On 2020-05-22
- SQLite Release 3.32.1 On 2020-05-25
- SQLite Release 3.32.2 On 2020-06-04
- SQLite Release 3.32.3 On 2020-06-18
- SQLite Release 3.33.0 On 2020-08-14
- SQLite Release 3.34.0 On 2020-12-01
- SQLite Release 3.34.1 On 2021-01-20
- SQLite Release 3.35.0 On 2021-03-12
- SQLite Release 3.35.1 On 2021-03-15
- SQLite Release 3.35.2 On 2021-03-17
- SQLite Release 3.35.3 On 2021-03-26
- SQLite Release 3.35.4 On 2021-04-02
- SQLite Release 3.35.5 On 2021-04-19
- SQLite Release 3.36.0 On 2021-06-18
- SQLite Release 3.37.0 On 2021-11-27
- SQLite Release 3.37.1 On 2021-12-30
- SQLite Release 3.37.2 On 2022-01-06
- SQLite Release 3.38.0 On 2022-02-22
- SQLite Release 3.38.1 On 2022-03-12
- SQLite Release 3.38.2 On 2022-03-26
- SQLite Release 3.38.3 On 2022-04-27
- SQLite Release 3.38.4 On 2022-05-04
- SQLite Release 3.38.5 On 2022-05-06
- SQLite Release 3.39.0 On 2022-06-25
- SQLite Release 3.39.1 On 2022-07-13
- SQLite Release 3.39.2 On 2022-07-21
- SQLite Release 3.39.3 On 2022-09-05
- SQLite Release 3.39.4 On 2022-09-29
- SQLite Release 3.4.0 On 2007-06-18
- SQLite Release 3.4.1 On 2007-07-20
- SQLite Release 3.4.2 On 2007-08-13
- SQLite Release 3.40.0 On 2022-11-16
- SQLite Release 3.40.1 On 2022-12-28
- SQLite Release 3.41.0 On 2023-02-21
- SQLite Release 3.41.1 On 2023-03-10
- SQLite Release 3.41.2 On 2023-03-22
- SQLite Release 3.42.0 On 2023-05-16
- SQLite Release 3.43.0 On 2023-08-24
- SQLite Release 3.43.1 On 2023-09-11
- SQLite Release 3.43.2 On 2023-10-10
- SQLite Release 3.44.0 On 2023-11-01
- SQLite Release 3.44.1 On 2023-11-22
- SQLite Release 3.44.2 On 2023-11-24
- SQLite Release 3.45.0 On 2024-01-15
- SQLite Release 3.45.1 On 2024-01-30
- SQLite Release 3.45.2 On 2024-03-12
- SQLite Release 3.45.3 On 2024-04-15
- SQLite Release 3.46.0 On 2024-05-23
- SQLite Release 3.46.1 On 2024-08-13
- SQLite Release 3.47.0 On 2024-10-21
- SQLite Release 3.47.1 On 2024-11-25
- SQLite Release 3.47.2 On 2024-12-07
- SQLite Release 3.48.0 On 2025-01-14
- SQLite Release 3.49.0 On 2025-02-06
- SQLite Release 3.49.1 On 2025-02-18
- SQLite Release 3.49.2 On 2025-05-07
- SQLite Release 3.5.0 On 2007-09-04
- SQLite Release 3.5.1 On 2007-10-04
- SQLite Release 3.5.2 On 2007-11-05
- SQLite Release 3.5.3 On 2007-11-27
- SQLite Release 3.5.4 On 2007-12-14
- SQLite Release 3.5.5 On 2008-01-31
- SQLite Release 3.5.6 On 2008-02-06
- SQLite Release 3.5.7 On 2008-03-17
- SQLite Release 3.5.8 On 2008-04-16
- SQLite Release 3.5.9 On 2008-05-14
- SQLite Release 3.50.0 On 2025-05-29
- SQLite Release 3.50.1 On 2025-06-06
- SQLite Release 3.50.2 On 2025-06-28
- SQLite Release 3.50.3 On 2025-07-17
- SQLite Release 3.50.4 On 2025-07-30
- SQLite Release 3.51.0 On 2025-11-04
- SQLite Release 3.51.1 On 2025-11-28
- SQLite Release 3.51.2 On 2026-01-09
- SQLite Release 3.51.3 On 2026-03-13
- SQLite Release 3.52.0 On 2026-03-06
- SQLite Release 3.53.0 On 2026-04-09
- SQLite Release 3.53.1 On 2026-05-05
- SQLite Release 3.53.2 On 2026-06-03
- SQLite Release 3.53.3 On 2026-06-26
- SQLite Release 3.53.4 On 2026-07-24
- SQLite Release 3.53.4 On 2026-07-24
- SQLite Release 3.6.0 On 2008-07-16
- SQLite Release 3.6.1 On 2008-08-06
- SQLite Release 3.6.10 On 2009-01-15
- SQLite Release 3.6.11 On 2009-02-18
- SQLite Release 3.6.12 On 2009-03-31
- SQLite Release 3.6.13 On 2009-04-13
- SQLite Release 3.6.14 On 2009-05-07
- SQLite Release 3.6.14.1 On 2009-05-19
- SQLite Release 3.6.14.2 On 2009-05-25
- SQLite Release 3.6.15 On 2009-06-15
- SQLite Release 3.6.16 On 2009-06-27
- SQLite Release 3.6.16.1 On 2009-10-30
- SQLite Release 3.6.17 On 2009-08-10
- SQLite Release 3.6.18 On 2009-09-11
- SQLite Release 3.6.19 On 2009-10-14
- SQLite Release 3.6.2 On 2008-08-30
- SQLite Release 3.6.20 On 2009-11-04
- SQLite Release 3.6.21 On 2009-12-07
- SQLite Release 3.6.22 On 2010-01-06
- SQLite Release 3.6.23 On 2010-03-09
- SQLite Release 3.6.23.1 On 2010-03-26
- SQLite Release 3.6.3 On 2008-09-22
- SQLite Release 3.6.4 On 2008-10-15
- SQLite Release 3.6.5 On 2008-11-12
- SQLite Release 3.6.6 On 2008-11-19
- SQLite Release 3.6.6.1 On 2008-11-22
- SQLite Release 3.6.6.2 On 2008-11-26
- SQLite Release 3.6.7 On 2008-12-16
- SQLite Release 3.6.8 On 2009-01-12
- SQLite Release 3.6.9 On 2009-01-14
- SQLite Release 3.7.0 On 2010-07-21
- SQLite Release 3.7.0.1 On 2010-08-04
- SQLite Release 3.7.1 On 2010-08-23
- SQLite Release 3.7.10 On 2012-01-16
- SQLite Release 3.7.11 On 2012-03-20
- SQLite Release 3.7.12 On 2012-05-14
- SQLite Release 3.7.12.1 On 2012-05-22
- SQLite Release 3.7.13 On 2012-06-11
- SQLite Release 3.7.14 On 2012-09-03
- SQLite Release 3.7.14.1 On 2012-10-04
- SQLite Release 3.7.15 On 2012-12-12
- SQLite Release 3.7.15.1 On 2012-12-19
- SQLite Release 3.7.15.2 On 2013-01-09
- SQLite Release 3.7.16 On 2013-03-18
- SQLite Release 3.7.16.1 On 2013-03-29
- SQLite Release 3.7.16.2 On 2013-04-12
- SQLite Release 3.7.17 On 2013-05-20
- SQLite Release 3.7.2 On 2010-08-24
- SQLite Release 3.7.3 On 2010-10-08
- SQLite Release 3.7.4 On 2010-12-07
- SQLite Release 3.7.5 On 2011-02-01
- SQLite Release 3.7.6 On 2011-04-12
- SQLite Release 3.7.6.1 On 2011-04-13
- SQLite Release 3.7.6.2 On 2011-04-17
- SQLite Release 3.7.6.3 On 2011-05-19
- SQLite Release 3.7.7 On 2011-06-23
- SQLite Release 3.7.7.1 On 2011-06-28
- SQLite Release 3.7.8 On 2011-09-19
- SQLite Release 3.7.9 On 2011-11-01
- SQLite Release 3.8.0 On 2013-08-26
- SQLite Release 3.8.0.1 On 2013-08-29
- SQLite Release 3.8.0.2 On 2013-09-03
- SQLite Release 3.8.1 On 2013-10-17
- SQLite Release 3.8.10 On 2015-05-07
- SQLite Release 3.8.10.1 On 2015-05-09
- SQLite Release 3.8.10.2 On 2015-05-20
- SQLite Release 3.8.11 On 2015-07-27
- SQLite Release 3.8.11.1 On 2015-07-29
- SQLite Release 3.8.2 On 2013-12-06
- SQLite Release 3.8.3 On 2014-02-03
- SQLite Release 3.8.3.1 On 2014-02-11
- SQLite Release 3.8.4 On 2014-03-10
- SQLite Release 3.8.4.1 On 2014-03-11
- SQLite Release 3.8.4.2 On 2014-03-26
- SQLite Release 3.8.4.3 On 2014-04-03
- SQLite Release 3.8.5 On 2014-06-04
- SQLite Release 3.8.6 On 2014-08-15
- SQLite Release 3.8.7 On 2014-10-17
- SQLite Release 3.8.7.1 On 2014-10-29
- SQLite Release 3.8.7.2 On 2014-11-18
- SQLite Release 3.8.7.3 On 2014-12-05
- SQLite Release 3.8.7.4 On 2014-12-09
- SQLite Release 3.8.8 On 2015-01-16
- SQLite Release 3.8.8.1 On 2015-01-20
- SQLite Release 3.8.8.2 On 2015-01-30
- SQLite Release 3.8.8.3 On 2015-02-25
- SQLite Release 3.8.9 On 2015-04-08
- SQLite Release 3.9.0 On 2015-10-14
- SQLite Release 3.9.1 On 2015-10-16
- SQLite Release 3.9.2 On 2015-11-02
- SQLite Release 3.9.3 On 2016-04-01
- SQLite Requirements
- SQLite Shared-Cache Mode
- SQLite Site Map
- SQLite Support Options
- SQLite Syntax: aggregate-function-invocation
- SQLite Syntax: alter-table-stmt
- SQLite Syntax: analyze-stmt
- SQLite Syntax: attach-stmt
- SQLite Syntax: begin-stmt
- SQLite Syntax: column-constraint
- SQLite Syntax: column-def
- SQLite Syntax: column-name-list
- SQLite Syntax: comment-syntax
- SQLite Syntax: commit-stmt
- SQLite Syntax: common-table-expression
- SQLite Syntax: compound-operator
- SQLite Syntax: compound-select-stmt
- SQLite Syntax: conflict-clause
- SQLite Syntax: create-index-stmt
- SQLite Syntax: create-table-stmt
- SQLite Syntax: create-trigger-stmt
- SQLite Syntax: create-view-stmt
- SQLite Syntax: create-virtual-table-stmt
- SQLite Syntax: cte-table-name
- SQLite Syntax: delete-stmt
- SQLite Syntax: delete-stmt-limited
- SQLite Syntax: detach-stmt
- SQLite Syntax: drop-index-stmt
- SQLite Syntax: drop-table-stmt
- SQLite Syntax: drop-trigger-stmt
- SQLite Syntax: drop-view-stmt
- SQLite Syntax: expr
- SQLite Syntax: factored-select-stmt
- SQLite Syntax: filter-clause
- SQLite Syntax: foreign-key-clause
- SQLite Syntax: frame-spec
- SQLite Syntax: function-arguments
- SQLite Syntax: indexed-column
- SQLite Syntax: insert-stmt
- SQLite Syntax: join-clause
- SQLite Syntax: join-constraint
- SQLite Syntax: join-operator
- SQLite Syntax: literal-value
- SQLite Syntax: numeric-literal
- SQLite Syntax: ordering-term
- SQLite Syntax: over-clause
- SQLite Syntax: pragma-stmt
- SQLite Syntax: pragma-value
- SQLite Syntax: qualified-table-name
- SQLite Syntax: raise-function
- SQLite Syntax: recursive-cte
- SQLite Syntax: reindex-stmt
- SQLite Syntax: release-stmt
- SQLite Syntax: result-column
- SQLite Syntax: returning-clause
- SQLite Syntax: rollback-stmt
- SQLite Syntax: savepoint-stmt
- SQLite Syntax: select-core
- SQLite Syntax: select-stmt
- SQLite Syntax: signed-number
- SQLite Syntax: simple-function-invocation
- SQLite Syntax: simple-select-stmt
- SQLite Syntax: sql-stmt
- SQLite Syntax: sql-stmt-list
- SQLite Syntax: table-constraint
- SQLite Syntax: table-options
- SQLite Syntax: table-or-subquery
- SQLite Syntax: type-name
- SQLite Syntax: update-stmt
- SQLite Syntax: update-stmt-limited
- SQLite Syntax: upsert-clause
- SQLite Syntax: vacuum-stmt
- SQLite Syntax: window-defn
- SQLite Syntax: window-function-invocation
- SQLite Syntax: with-clause
- SQLite Unlock-Notify API
- SQLite Version 3 Overview
- SQLite's Built-in printf()
- Stale Expression Indexes
- Streaming Versions of API functions.
- STRICT Tables
- Swarmvtab Virtual Table
- Target Crossreference
- Temporary Files Used By SQLite
- Terms of Art Glossary
- Test if a changeset has recorded any changes.
- TH3
- The Advantages Of Flexible Typing
- The Amalgamation Versus Canonical Sources
- The Base64() SQL Function
- The Base85() SQL Function
- The Bytecode() And Tables_Used() Table-Valued Functions
- The Checksum VFS Shim
- The COMPLETION() Table-Valued Function
- The CSV Virtual Table
- The DBSTAT Virtual Table
- The Error And Warning Log
- The generate_series Table-Valued Function
- The Geopoly Interface To The SQLite R*Tree Module
- The Lemon LALR(1) Parser Generator
- The Next-Generation Query Planner
- The Percentile Extension
- The RBU Extension
- The Schema Table
- The Session Extension
- The Spellfix1 Virtual Table
- The SQLite Amalgamation
- The SQLite Bytecode Engine
- The SQLite OS Interface or "VFS"
- The SQLite Query Optimizer Overview
- The SQLite Zipfile Module
- The sqlite3_analyzer.exe Utility Program
- The SQLITE_DBPAGE Virtual Table
- The SQLITE_MEMSTAT Virtual Table
- The SQLITE_STMT Virtual Table
- The Tcl interface to the SQLite library
- The UINT Collating Sequence
- The UNION Virtual Table
- The Use Of assert() In SQLite
- The Virtual Database Engine of SQLite
- Uniform Resource Identifiers
- Using SQLite In Multi-Threaded Applications
- Values for sqlite3session_config().
- Version Numbers in SQLite
- Vulnerabilities
- WAL-mode File Format
- Website Keyword Index
- Well-Known Users Of SQLite
- What If OpenDocument Used SQLite?
- Why Is SQLite Coded In C
- Why SQLite Does Not Use Git
- Why SQLite Uses Bytecode
- Window Functions
- Write-Ahead Logging
- Zero-Configuration
Sql Language
- ALTER TABLE
- ANALYZE
- ATTACH DATABASE
- Built-in Aggregate Functions
- Built-In Mathematical SQL Functions
- Built-In Scalar SQL Functions
- CREATE INDEX
- CREATE TABLE
- CREATE TRIGGER
- CREATE VIEW
- CREATE VIRTUAL TABLE
- Database Object Name Resolution
- Date And Time Functions
- DELETE
- DETACH
- DROP INDEX
- DROP TABLE
- DROP TRIGGER
- DROP VIEW
- EXPLAIN
- INSERT
- REINDEX
- REPLACE
- RETURNING
- Savepoints
- SELECT
- SQL Comment Syntax
- SQL Language Expressions
- SQLite Keywords
- The INDEXED BY Clause
- The ON CONFLICT Clause
- The WITH Clause
- Transaction
- UPDATE
- UPSERT
- VACUUM
Syntax
Tools Extensions
- C/C++ Interface For SQLite Version 3
- Command Line Shell For SQLite
- JSON Functions And Operators
- Pragma statements supported by SQLite
- Session Object Handle
- SQLite Archive Files
- SQLite Backup API
- SQLite FTS3 and FTS4 Extensions
- SQLite FTS5 Extension
- SQLite Session Module C/C++ Interface
- The C language interface to SQLite Version 2
- The Carray() Table-Valued Function
- The dbhash.exe Utility Program
- The SQLite R*Tree Module
- The Virtual Table Mechanism Of SQLite