Documentation

Your complete guide to the SQLite database engine.

▼Document Lists And Indexes
►Overview Documents
- About SQLite→ A high-level overview of what SQLite is.
- Appropriate Uses For SQLite→ Where SQLite fits, and where a client/server RDBMS is better.
- Distinctive Features→ What makes SQLite different from other SQL engines.
- Quirks of SQLite→ Unusual features that can cause confusion.
- How SQLite Is Tested→ An overview of the rigorous testing process.
- Copyright→ SQLite is in the public domain.
- Frequently Asked Questions→ The title says it all...
►Programming Interfaces
- SQLite In 5 Minutes Or Less→ A very quick introduction to programming with SQLite.
- Introduction to the C/C++ API→ A primer for the C/C++ API.
- How To Compile SQLite→ Instructions and hints for compiling SQLite.
- C/C++ API Reference→ A detailed reference for each API function.
- Tcl API→ Description of the Tcl interface bindings.
- System.Data.SQLite→ C#/.NET bindings for SQLite.
►SQL Language
- SQL Syntax→ The SQL language understood by SQLite.
- Pragma commands→ Performance tuning and special purpose commands.
- Core SQL Functions→ Built-in scalar SQL functions.
- Aggregate SQL Functions→ Built-in aggregate functions.
- Date and Time Functions→ Functions for manipulating dates and times.
- Window Functions→ SQL window functions.
- DataTypes in SQLite 3→ How manifest typing works.
►Extensions
- JSON Functions→ Create, parse, and query JSON content.
- FTS5 - Full Text Search→ The latest full-text search engine.
- R-Tree Module→ Fast multi-dimensional range queries.
- Sessions→ Capture and apply changesets.
- Run-Time Loadable Extensions→ How to compile and create extensions.
- CSV Virtual Table→ Directly read and query CSV files.
►Features In-Depth
- Autoincrement→ What AUTOINCREMENT does, and when to (not) use it.
- Backup API→ Creating hot backups of a live database.
- Foreign Key Support→ Foreign key constraint support.
- Limits In SQLite→ Maximum database size, string length, etc.
- Multi-threaded Programs→ How to use SQLite safely in multi-threaded programs.
- Write-Ahead Log (WAL) Mode→ Improved concurrency and performance with WAL.
►Tools
- Command-Line Shell (sqlite3)→ Notes on using the CLI to manage databases.
- SQLite Database Diff (sqldiff)→ Compare two databases.
- SQLite Archiver (sqlar)→ A ZIP-like archive program using SQLite for storage.
►Technical & Design Docs
- How Database Corruption Can Occur→ What can cause a database to become corrupt.
- Atomic Commit→ How transactions are implemented.
- Locking And Concurrency→ How locking increases concurrency.
- The Query Planner→ Information about the SQLite query planner.
- Architecture→ An architectural overview of the library.
- The SQLite File Format→ A description of the on-disk file format.