*** DRAFT ***

• Home
• Menu
• About
• Documentation
• Download
• License
• Support
• Purchase
• Search

• About
• Documentation
• Download
• Support
• Purchase

Search Documentation Search Changelog

Permuted Index

• 35% Faster Than The Filesystem
• 8+3 Filenames
• About SQLite
• About SQLite — Books
• Advantages Of Flexible Typing — The
• Against The Dark Arts — Defense
• Aggregate Functions — Built in
• Ahead Logging — Write
• Allocation In SQLite — Dynamic Memory
• Alphabetical List Of SQLite Documents
• ALTER TABLE
• Amalgamation — The SQLite
• Amalgamation Versus Canonical Sources — The
• An Introduction To The SQLite C/C++ Interface
• ANALYZE
• And Concurrency In SQLite Version 3 — File Locking
• and Considerations — SQLite Over a Network, Caveats
• and Error Codes — Result
• and FTS4 Extensions — SQLite FTS3
• and Gotchas In SQLite — Quirks, Caveats,
• and JSON with the SQLite Extension — Bridging Tcl
• And Operators — JSON Functions
• and Reducing CPU Usage in SQLite — Measuring
• And Tables_Used() Table Valued Functions — The Bytecode()
• and the WITHOUT ROWID Optimization — Clustered Indexes
• And Time Functions — Date
• And Warning Log — The Error
• Android Bindings
• API — SQLite Backup
• API — SQLite Unlock Notify
• API Reference — C/C++
• Application Defined SQL Functions
• Application File Format — SQLite As An
• Applications — Using SQLite In Multi Threaded
• Appropriate Uses For SQLite
• Architecture of SQLite
• Archive Files — SQLite
• Archiver (sqlar.exe) — SQLite
• Are Efficient In SQLite — Many Small Queries
• Art Glossary — Terms of
• Arts — Defense Against The Dark
• Asked Questions — SQLite Frequently
• assert() In SQLite — The Use Of
• Atomic Commit In SQLite
• ATTACH DATABASE
• Autoincrement — SQLite
• Automatic Undo/Redo With SQLite
• Backup API — SQLite
• Base64() SQL Function — The
• Base85() SQL Function — The
• Benefits of SQLite As A File Format
• Bindings — Android
• BLOBs — Internal Versus External
• Books About SQLite
• Branches Of SQLite — Maintaining Private
• Bridging Tcl and JSON with the SQLite Extension
• Builds Of SQLite — Custom
• Built in Aggregate Functions
• Built In Mathematical SQL Functions
• Built in printf() — SQLite's
• Built In Scalar SQL Functions
• Bytecode — Why SQLite Uses
• Bytecode Engine — The SQLite
• Bytecode() And Tables_Used() Table Valued Functions — The
• C/C++ API Reference
• C/C++ Interface — An Introduction To The SQLite
• C/C++ Interface — SQLite Session Module
• C/C++ Interface For SQLite Version 3
• C/C++ Interface For SQLite Version 3 (old)
• Cache Mode — SQLite Shared
• Canonical Sources — The Amalgamation Versus
• Canonical SQLite Source Code — How To Download
• Carray() Table Valued Function — The
• Caveats and Considerations — SQLite Over a Network,
• Caveats, and Gotchas In SQLite — Quirks,
• Change in Default Page Size in SQLite Version 3.12.0
• Changes From Version 3.4.2 To 3.5.0 — SQLite
• Changes From Version 3.5.9 To 3.6.0 — SQLite
• Changes in SQLite — File Format
• Characters In Strings — NUL
• Checksum VFS Shim — The
• Clause — The INDEXED BY
• Clause — The ON CONFLICT
• Clause — The WITH
• CLI — Query Result Formatting In The
• CLI Prompt — The
• Clustered Indexes and the WITHOUT ROWID Optimization
• Code — How To Download Canonical SQLite Source
• Coded In C — Why Is SQLite
• Codes — Result and Error
• Collating Sequence — The UINT
• Columns — Generated
• Command Line Shell For SQLite
• Comment Syntax — SQL
• Commit In SQLite — Atomic
• Comparison — SQLite Database Speed
• Compile SQLite — How To
• Compile time Options
• COMPLETION() Table Valued Function — The
• Concurrency In SQLite Version 3 — File Locking And
• Configuration — Zero
• CONFLICT Clause — The ON
• Conflict Resolution in SQLite — Constraint
• Considerations — SQLite Over a Network, Caveats and
• Consortium — SQLite
• Constraint Conflict Resolution in SQLite
• Contained System — SQLite is a Self
• Control System — The Fossil Version
• Copy Tool For SQLite — Database Remote
• Copyright — SQLite
• Corrupt An SQLite Database File — How To
• Corrupt SQLite Database — Recovering Data From A
• CPU Usage in SQLite — Measuring and Reducing
• CREATE INDEX
• CREATE TABLE
• CREATE TRIGGER
• CREATE VIEW
• CREATE VIRTUAL TABLE
• CSV Virtual Table — The
• Custom Builds Of SQLite
• Dark Arts — Defense Against The
• Data From A Corrupt SQLite Database — Recovering
• DATABASE — ATTACH
• Database — Recovering Data From A Corrupt SQLite
• Database — SQLite: Single File
• Database Difference Utility — sqldiff.exe:
• Database Engine — Most Widely Deployed SQL
• Database Engine of SQLite — The Virtual
• Database File — How To Corrupt An SQLite
• Database File Format
• Database Object Name Resolution
• Database Remote Copy Tool For SQLite
• Database Speed Comparison — SQLite
• Databases — In Memory
• Datatypes In SQLite
• Datatypes In SQLite version 2
• Date And Time Functions
• dbhash.exe Utility Program — The
• DBSTAT Virtual Table — The
• Debugging SQLite — Hints for
• Default Page Size in SQLite Version 3.12.0 — Change in
• Defense Against The Dark Arts
• Defined SQL Functions — Application
• DELETE
• Deployed SQL Database Engine — Most Widely
• DETACH
• Deterministic SQL Functions
• Developers — SQLite
• Diagrams — List of SQLite Syntax
• Diagrams For SQLite — Syntax
• Difference Utility — sqldiff.exe: Database
• Disk Format — On
• DISKUSED() Extension — The
• Distinctive Features Of SQLite
• Documentation — SQLite
• Documents — Alphabetical List Of SQLite
• Does Not Implement — SQL Features That SQLite
• Does Not Use Git — Why SQLite
• Download Canonical SQLite Source Code — How To
• Download Page — SQLite
• DROP INDEX
• DROP TABLE
• DROP TRIGGER
• DROP VIEW
• Dynamic Memory Allocation In SQLite
• Efficient In SQLite — Many Small Queries Are
• Engine — Most Widely Deployed SQL Database
• Engine — The SQLite Bytecode
• Engine of SQLite — The Virtual Database
• Error And Warning Log — The
• Error Codes — Result and
• EXPLAIN
• EXPLAIN QUERY PLAN
• Expression Indexes — Stale
• Expressions — Indexes On
• Expressions — SQL Language
• Extension — Bridging Tcl and JSON with the SQLite
• Extension — SQLite FTS5
• Extension — The DISKUSED()
• Extension — The Percentile
• Extension — The RBU
• Extension — The Session
• Extensions — Run Time Loadable
• Extensions — SQLite FTS3 and FTS4
• External BLOBs — Internal Versus
• Faster Than The Filesystem — 35%
• Featured SQL — Full
• Features Of SQLite
• Features Of SQLite — Distinctive
• Features That SQLite Does Not Implement — SQL
• File — How To Corrupt An SQLite Database
• File Database — SQLite: Single
• File Format — Benefits of SQLite As A
• File Format — Database
• File Format — SQLite As An Application
• File Format — WAL mode
• File Format Changes in SQLite
• File Locking And Concurrency In SQLite Version 3
• Filenames — 8+3
• Files — SQLite Archive
• Files Used By SQLite — Temporary
• Filesystem — 35% Faster Than The
• Flexible Typing — The Advantages Of
• Floating Point Numbers
• Footprint — SQLite Library
• Foreign Key Support — SQLite
• Format — Benefits of SQLite As A File
• Format — Database File
• Format — LoC Recommended Storage
• Format — On Disk
• Format — SQLite As An Application File
• Format — WAL mode File
• Format Changes in SQLite — File
• Formatting In The CLI — Query Result
• Fossil Version Control System — The
• Frequently Asked Questions — SQLite
• From A Corrupt SQLite Database — Recovering Data
• From Version 3.4.2 To 3.5.0 — SQLite Changes
• From Version 3.5.9 To 3.6.0 — SQLite Changes
• FTS3 and FTS4 Extensions — SQLite
• FTS4 Extensions — SQLite FTS3 and
• FTS5 Extension — SQLite
• Full Featured SQL
• Function — The Base64() SQL
• Function — The Base85() SQL
• Function — The Carray() Table Valued
• Function — The COMPLETION() Table Valued
• Function — The generate_series Table Valued
• Functions — Application Defined SQL
• Functions — Built in Aggregate
• Functions — Built In Mathematical SQL
• Functions — Built In Scalar SQL
• Functions — Date And Time
• Functions — Deterministic SQL
• Functions — The Bytecode() And Tables_Used() Table Valued
• Functions — Window
• Functions And Operators — JSON
• generate_series Table Valued Function — The
• Generated Columns
• Generation Query Planner — The Next
• Generator — The Lemon LALR(1) Parser
• Geopoly Interface To The SQLite R*Tree Module — The
• Git — Why SQLite Does Not Use
• Glossary — Terms of Art
• Gotchas In SQLite — Quirks, Caveats, and
• Handling in SQLite — NULL
• High Reliability
• Hints for Debugging SQLite
• History Of SQLite — Release
• History Of SQLite Releases
• Home Page — SQLite
• How Indexes Work
• 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
• I/O — Memory Mapped
• Identifiers — Uniform Resource
• Implement — SQL Features That SQLite Does Not
• Implementation Limits For SQLite
• Imposter Tables
• In Memory Databases
• INDEX — CREATE
• INDEX — DROP
• Index — Website Keyword
• INDEXED BY Clause — The
• Indexes — Partial
• Indexes — Stale Expression
• Indexes and the WITHOUT ROWID Optimization — Clustered
• Indexes On Expressions
• Indexes Work — How
• INSERT
• Interface — An Introduction To The SQLite C/C++
• Interface — SQLite Session Module C/C++
• Interface For SQLite Version 3 — C/C++
• Interface For SQLite Version 3 (old) — C/C++
• Interface or VFS — The SQLite OS
• interface to SQLite Version 2 — The C language
• interface to the SQLite library — The Tcl
• Interface To The SQLite R*Tree Module — The Geopoly
• Interfaces — Pointer Passing
• Internal Versus External BLOBs
• Introduction To The SQLite C/C++ Interface — An
• Invalid UTF Policy
• Isolation In SQLite
• Javascript Required
• JSON Functions And Operators
• JSON with the SQLite Extension — Bridging Tcl and
• Key Support — SQLite Foreign
• Keyword Index — Website
• Keywords — SQLite
• Known Users Of SQLite — Well
• LALR(1) Parser Generator — The Lemon
• Language Expressions — SQL
• language interface to SQLite Version 2 — The C
• Language Understood by SQLite — Query
• Lemon LALR(1) Parser Generator — The
• Less — SQLite In 5 Minutes Or
• library — The Tcl interface to the SQLite
• Library Footprint — SQLite
• Limits For SQLite — Implementation
• Line Shell For SQLite — Command
• List Of SQLite Documents — Alphabetical
• List of SQLite Syntax Diagrams
• List Of Virtual Tables
• Loadable Extensions — Run Time
• LoC Recommended Storage Format
• Locking And Concurrency In SQLite Version 3 — File
• Log — The Error And Warning
• Logging — Write Ahead
• Long Term Support
• Maintaining Private Branches Of SQLite
• Management — Quality
• Many Small Queries Are Efficient In SQLite
• Map — SQLite Site
• Mapped I/O — Memory
• Mathematical SQL Functions — Built In
• Measuring and Reducing CPU Usage in SQLite
• Mechanism Of SQLite — The Virtual Table
• Memory Allocation In SQLite — Dynamic
• Memory Databases — In
• Memory Mapped I/O
• Minutes Or Less — SQLite In 5
• Mode — SQLite Shared Cache
• mode File Format — WAL
• Module — The Geopoly Interface To The SQLite R*Tree
• Module — The SQLite R*Tree
• Module — The SQLite Zipfile
• Module C/C++ Interface — SQLite Session
• Most Widely Deployed SQL Database Engine
• Multi Threaded Applications — Using SQLite In
• Name Resolution — Database Object
• Network, Caveats and Considerations — SQLite Over a
• News — Recent SQLite
• News — SQLite Older
• Next Generation Query Planner — The
• Not Implement — SQL Features That SQLite Does
• Not Use Git — Why SQLite Does
• Notify API — SQLite Unlock
• NUL Characters In Strings
• NULL Handling in SQLite
• Numbers — Floating Point
• Numbers in SQLite — Version
• Object Name Resolution — Database
• Older News — SQLite
• On Disk Format
• OpenDocument Used SQLite? — What If
• Operators — JSON Functions And
• Optimization — Clustered Indexes and the WITHOUT ROWID
• Optimizer Overview — The SQLite Query
• Options — Compile time
• Options — SQLite Support
• Over a Network, Caveats and Considerations — SQLite
• Overview — SQLite Version 3
• Overview — The SQLite Query Optimizer
• Overwrite — Powersafe
• Page — SQLite Download
• Page — SQLite Home
• Page Size in SQLite Version 3.12.0 — Change in Default
• Parser Generator — The Lemon LALR(1)
• Partial Indexes
• Passing Interfaces — Pointer
• Percentile Extension — The
• PLAN — EXPLAIN QUERY
• Planner — The Next Generation Query
• Planning — Query
• Point Numbers — Floating
• Pointer Passing Interfaces
• Policy — Invalid UTF
• Powersafe Overwrite
• Pragma statements supported by SQLite
• printf() — SQLite's Built in
• Private Branches Of SQLite — Maintaining
• Pro Support — SQLite
• Profiling SQL Queries
• Program — The dbhash.exe Utility
• Program — The sqlite3_analyzer.exe Utility
• Prompt — The CLI
• Quality Management
• Queries — Profiling SQL
• Queries Are Efficient In SQLite — Many Small
• Query Language Understood by SQLite
• Query Optimizer Overview — The SQLite
• QUERY PLAN — EXPLAIN
• Query Planner — The Next Generation
• Query Planning
• Query Result Formatting In The CLI
• Questions — SQLite Frequently Asked
• Quirks, Caveats, and Gotchas In SQLite
• R*Tree Module — The Geopoly Interface To The SQLite
• R*Tree Module — The SQLite
• RBU Extension — The
• Recent SQLite News
• Recommended Storage Format — LoC
• Recovering Data From A Corrupt SQLite Database
• Reducing CPU Usage in SQLite — Measuring and
• Reference — C/C++ API
• REINDEX
• Release History Of SQLite
• Releases — History Of SQLite
• Reliability — High
• Remote Copy Tool For SQLite — Database
• REPLACE
• Required — Javascript
• Requirements — SQLite
• Resolution — Database Object Name
• Resolution in SQLite — Constraint Conflict
• Resource Identifiers — Uniform
• Result and Error Codes
• Result Formatting In The CLI — Query
• RETURNING
• Row Values
• ROWID Optimization — Clustered Indexes and the WITHOUT
• Rowid Tables
• Run Time Loadable Extensions
• Savepoints
• Scalar SQL Functions — Built In
• Schema Table — The
• SELECT
• Self Contained System — SQLite is a
• Sequence — The UINT Collating
• Serverless — SQLite Is
• Session Extension — The
• Session Module C/C++ Interface — SQLite
• Shared Cache Mode — SQLite
• Shell For SQLite — Command Line
• Shim — The Checksum VFS
• Single File Database — SQLite:
• Site Map — SQLite
• Size in SQLite Version 3.12.0 — Change in Default Page
• Small Queries Are Efficient In SQLite — Many
• Source Code — How To Download Canonical SQLite
• Sources — The Amalgamation Versus Canonical
• Speed Comparison — SQLite Database
• Spellfix1 Virtual Table — The
• SQL — Full Featured
• SQL Comment Syntax
• SQL Database Engine — Most Widely Deployed
• SQL Features That SQLite Does Not Implement
• SQL Function — The Base64()
• SQL Function — The Base85()
• SQL Functions — Application Defined
• SQL Functions — Built In Mathematical
• SQL Functions — Built In Scalar
• SQL Functions — Deterministic
• SQL Language Expressions
• SQL Queries — Profiling
• sqldiff.exe: Database Difference Utility
• SQLite Archive Files
• SQLite Archiver (sqlar.exe)
• SQLite As An Application File Format
• SQLite Autoincrement
• SQLite Backup API
• 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 Copyright
• SQLite Database Speed Comparison
• SQLite Developers
• SQLite Documentation
• SQLite Download Page
• SQLite Foreign Key Support
• SQLite Frequently Asked Questions
• SQLite FTS3 and FTS4 Extensions
• SQLite FTS5 Extension
• SQLite Home Page
• SQLite In 5 Minutes Or Less
• SQLite is a Self Contained System
• SQLite Is Serverless
• SQLite Is Transactional
• SQLite Keywords
• SQLite Library Footprint
• SQLite Older News
• SQLite Over a Network, Caveats and Considerations
• SQLite Pro Support
• SQLite Requirements
• SQLite Session Module C/C++ Interface
• SQLite Shared Cache Mode
• SQLite Site Map
• SQLite Support Options
• SQLite Unlock Notify API
• SQLite Version 3 Overview
• SQLite's Built in printf()
• sqlite3_analyzer.exe Utility Program — The
• SQLite: Single File Database
• SQLite? — What If OpenDocument Used
• SQLITE_DBPAGE Virtual Table — The
• SQLITE_MEMSTAT Virtual Table — The
• SQLITE_STMT Virtual Table — The
• Stale Expression Indexes
• statements supported by SQLite — Pragma
• Storage Format — LoC Recommended
• STRICT Tables
• Strings — NUL Characters In
• Support — Long Term
• Support — SQLite Foreign Key
• Support — SQLite Pro
• Support Options — SQLite
• supported by SQLite — Pragma statements
• Swarmvtab Virtual Table
• Syntax — SQL Comment
• Syntax Diagrams — List of SQLite
• Syntax Diagrams For SQLite
• System — SQLite is a Self Contained
• System — The Fossil Version Control
• System.Data.SQLite
• TABLE — ALTER
• TABLE — CREATE
• TABLE — CREATE VIRTUAL
• TABLE — DROP
• Table — Swarmvtab Virtual
• Table — The CSV Virtual
• Table — The DBSTAT Virtual
• Table — The Schema
• Table — The Spellfix1 Virtual
• Table — The SQLITE_DBPAGE Virtual
• Table — The SQLITE_MEMSTAT Virtual
• Table — The SQLITE_STMT Virtual
• Table — The UNION Virtual
• Table Mechanism Of SQLite — The Virtual
• Table Valued Function — The Carray()
• Table Valued Function — The COMPLETION()
• Table Valued Function — The generate_series
• Table Valued Functions — The Bytecode() And Tables_Used()
• Tables — Imposter
• Tables — List Of Virtual
• Tables — Rowid
• Tables — STRICT
• Tables_Used() Table Valued Functions — The Bytecode() And
• Tcl and JSON with the SQLite Extension — Bridging
• Tcl interface to the SQLite library — The
• Temporary Files Used By SQLite
• Term Support — Long
• Terms of Art Glossary
• Tested — How SQLite Is
• TH3
• Than The Filesystem — 35% Faster
• That SQLite Does Not Implement — SQL Features
• 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 C language interface to SQLite Version 2
• The Carray() Table Valued Function
• The Checksum VFS Shim
• The CLI Prompt
• The COMPLETION() Table Valued Function
• The CSV Virtual Table
• The dbhash.exe Utility Program
• The DBSTAT Virtual Table
• The DISKUSED() Extension
• The Error And Warning Log
• The Fossil Version Control System
• The generate_series Table Valued Function
• The Geopoly Interface To The SQLite R*Tree Module
• The INDEXED BY Clause
• The Lemon LALR(1) Parser Generator
• The Next Generation Query Planner
• The ON CONFLICT Clause
• 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 R*Tree Module
• 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
• The Virtual Table Mechanism Of SQLite
• The WITH Clause
• Threaded Applications — Using SQLite In Multi
• Time Functions — Date And
• Time Loadable Extensions — Run
• time Options — Compile
• Tool For SQLite — Database Remote Copy
• Transaction
• Transactional — SQLite Is
• TRIGGER — CREATE
• TRIGGER — DROP
• Typing — The Advantages Of Flexible
• UINT Collating Sequence — The
• Understood by SQLite — Query Language
• Undo/Redo With SQLite — Automatic
• Uniform Resource Identifiers
• UNION Virtual Table — The
• Unlock Notify API — SQLite
• UPDATE
• UPSERT
• Usage in SQLite — Measuring and Reducing CPU
• Use Git — Why SQLite Does Not
• Use Of assert() In SQLite — The
• Used By SQLite — Temporary Files
• Used SQLite? — What If OpenDocument
• Users Of SQLite — Well Known
• Uses Bytecode — Why SQLite
• Uses For SQLite — Appropriate
• Using SQLite In Multi Threaded Applications
• UTF Policy — Invalid
• Utility — sqldiff.exe: Database Difference
• Utility Program — The dbhash.exe
• Utility Program — The sqlite3_analyzer.exe
• VACUUM
• Valued Function — The Carray() Table
• Valued Function — The COMPLETION() Table
• Valued Function — The generate_series Table
• Valued Functions — The Bytecode() And Tables_Used() Table
• Values — Row
• version 2 — Datatypes In SQLite
• Version 2 — The C language interface to SQLite
• Version 3 — C/C++ Interface For SQLite
• Version 3 — File Locking And Concurrency In SQLite
• Version 3 (old) — C/C++ Interface For SQLite
• Version 3 Overview — SQLite
• Version 3.12.0 — Change in Default Page Size in SQLite
• Version 3.4.2 To 3.5.0 — SQLite Changes From
• Version 3.5.9 To 3.6.0 — SQLite Changes From
• Version Control System — The Fossil
• Version Numbers in SQLite
• Versus Canonical Sources — The Amalgamation
• Versus External BLOBs — Internal
• VFS — The SQLite OS Interface or
• VFS Shim — The Checksum
• VIEW — CREATE
• VIEW — DROP
• Virtual Database Engine of SQLite — The
• VIRTUAL TABLE — CREATE
• Virtual Table — Swarmvtab
• Virtual Table — The CSV
• Virtual Table — The DBSTAT
• Virtual Table — The Spellfix1
• Virtual Table — The SQLITE_DBPAGE
• Virtual Table — The SQLITE_MEMSTAT
• Virtual Table — The SQLITE_STMT
• Virtual Table — The UNION
• Virtual Table Mechanism Of SQLite — The
• Virtual Tables — List Of
• Vulnerabilities
• WAL mode File Format
• Warning Log — The Error And
• 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
• Widely Deployed SQL Database Engine — Most
• Window Functions
• WITH Clause — The
• With SQLite — Automatic Undo/Redo
• with the SQLite Extension — Bridging Tcl and JSON
• WITHOUT ROWID Optimization — Clustered Indexes and the
• Work — How Indexes
• Works — How SQLite
• Write Ahead Logging
• Zero Configuration
• Zipfile Module — The SQLite

*** DRAFT ***