Index

A note on the digital index

A link in an index entry is displayed as the section title in which that entry appears. Because some sections have multiple index markers, it is not unusual for an entry to have several links to the same section. Clicking on any link will take you directly to the place in the text in which the marker appears.

Symbols

!= (not equal) operator, Simple Operators, Binary Expressions

% (modulo) operator, Simple Operators, Binary Expressions

& (binary AND) bitwise operator, Simple Operators, Binary Expressions

' (single quote), Basic Syntax

* (asterisk), SELECT Header

* (multiplication) operator, Simple Operators, Binary Expressions

+ (addition) operator, Simple Operators, Binary Expressions

+ (positive sign) operator, Simple Operators, Unary Expressions

, (comma), Basic Syntax

- (sign negation) operator, Simple Operators, Unary Expressions

- (subtraction) operator, Simple Operators, Binary Expressions

/ (division) operator, Simple Operators, Binary Expressions

; (semicolon), Basic Syntax, SQLite SQL Command Reference

< (less than) operator, Simple Operators, Binary Expressions

<< (bit shift) operator, Simple Operators, Binary Expressions

<= (less than or equal to) operator, Simple Operators, Binary Expressions

<> (not equal) operator, Simple Operators, Binary Expressions

= (equal) operator, Three-Valued Logic, Simple Operators, Binary Expressions

== (equal) operator, Simple Operators, Binary Expressions

> (greater than) operator, Simple Operators, Binary Expressions

>= (greater than or equal to) operator, Simple Operators, Binary Expressions

>> (bit shift) operator, Simple Operators, Binary Expressions

[ ] (square brackets), Basic Syntax

\ (backslash), Basic Syntax

` (back tick), Basic Syntax

| (binary OR) bitwise operator, Simple Operators, Binary Expressions

|| (string concatenation) operator, Simple Operators, Binary Expressions

~ (bit inversion) operator, Simple Operators, Unary Expressions

A

abs() function, abs()

access control, Not the Best Choice

ACID transactions, ACID Transactions–ACID Transactions

addition (+) operator, Simple Operators, Binary Expressions

adjacency model, Hierarchies and Trees–Adjacency Model

aggregate functions, SELECT Header, SQL Functions and Extensions, Aggregate Functions, Defining Aggregates, Aggregate Context–Aggregate Context, Example–Example, Function Calls, SQLite SQL Function Reference, avg()–Description

aggregate context, Aggregate Context–Aggregate Context

built-in, avg()–Description

defined, SELECT Header, SQL Functions and Extensions, Aggregate Functions, Function Calls, SQLite SQL Function Reference

defining aggregates, Defining Aggregates

usage examples, Example–Example

ALTER TABLE command, Altering tables, ALTER TABLE–ADD COLUMN, RENAME, ADD COLUMN

ADD COLUMN variant, ADD COLUMN

functionality, Altering tables

RENAME variant, RENAME

syntax, ALTER TABLE–ADD COLUMN

amalgamation, The Amalgamation, Source Files, Source Downloads

defined, The Amalgamation

source downloads, Source Downloads

source files, Source Files

American National Standards Institute (ANSI), Brief Background

ANALYZE command, ANALYZE–Description

AND operator, Three-Valued Logic, Simple Operators, Binary Expressions, Binary Expressions, AND

binary operations, Binary Expressions

logical operations, Simple Operators, Binary Expressions, AND

three valued logic, Three-Valued Logic

ANSI (American National Standards Institute), Brief Background

ANSI join notation, Alternate JOIN Notation

application cache, Application Cache

application files, Application Files

APSW module, Python

archives, SQLite support, Archives and Data Stores

AS keyword, Table aliases, SELECT Header

ASC keyword, ORDER BY Clause

asterisk (*), SELECT Header

atoi() function, Rows and Columns

ATTACH DATABASE command, ATTACH DATABASE

autocommit mode, SQL Transactions

auto_vacuum pragma, auto_vacuum–Description

avg() function, GROUP BY Examples, avg()

B

back tick (`), Basic Syntax

backslash (\), Basic Syntax

.backup command, .backup

.bail command, .bail

BCNF (Boyce-Codd Normal Form), Normal Form

BEGIN IMMEDIATE command, SQL Transactions

BEGIN TRANSACTION command, SQL Transactions, Transactions and Errors, Avoiding SQLITE_BUSY, BEGIN TRANSACTION

avoiding SQLITE_BUSY, Avoiding SQLITE_BUSY

errors and, Transactions and Errors

syntax, SQL Transactions, BEGIN TRANSACTION

BETWEEN expression, BETWEEN

binary AND (&) bitwise operator, Simple Operators, Binary Expressions

binary bit shift, Simple Operators, Binary Expressions

BINARY collation, Collation Functions

binary operators, Simple Operators, Binary Expressions–Binary Expressions

binary OR (|) bitwise operator, Simple Operators, Binary Expressions

bit inversion (~) operator, Simple Operators, Unary Expressions

bit shift operator, Simple Operators, Binary Expressions

BLOB datatype, Basic Syntax, Column types, One-to-One Relationships, Literal Expressions

defined, Column types, Literal Expressions

one-to-one relationships and, One-to-One Relationships

SQL syntax, Basic Syntax

bound parameters, Bound Parameters (see statement parameters)

Boyce-Codd Normal Form (BCNF), Normal Form

bridge tables, Many-to-Many Relationships

C

C APIs, API Overview–More Info, Structure, Error Codes, Structures and Allocations, Library Initialization, Database Connections–Example, Prepared Statements–Examples, Bound Parameters–Potential Pitfalls, Convenience Functions–Convenience Functions, Result Codes and Error Codes–Extended Codes, Extended Codes–When BUSY becomes BLOCKED, Utility Functions–Memory Management, API Datatypes–Description, API Functions–Description

bound parameters, Bound Parameters–Potential Pitfalls

convenience functions, Convenience Functions–Convenience Functions

database connections, Database Connections–Example

datatypes supported, Structure, API Datatypes–Description

error codes, Error Codes, Extended Codes–When BUSY becomes BLOCKED

functions supported, API Functions–Description

library initialization, Library Initialization

overview, API Overview–More Info

prepared statements, Prepared Statements–Examples

result codes, Result Codes and Error Codes–Extended Codes

structures and allocations, Structures and Allocations

utility functions, Utility Functions–Memory Management

C++ language, C++

cache, application, Application Cache

cache_size pragma, cache_size

CamelCase, Structure

CASE expression, CASE

case sensitivity, Basic Syntax

case_sensitive_like pragma, case_sensitive_like

CAST expression, CAST

CEROD extension, Additional Extensions

changes() function, changes()

client/server framework, Client/Server Stand-in, Not the Best Choice

SQLite limitations, Not the Best Choice

SQLite stand-in, Client/Server Stand-in

coalesce() function, coalesce()

COLLATE operator, COLLATE

collations, Column constraints, SQL Functions and Extensions, Registering a Collation, Collation Example

defined, Column constraints, SQL Functions and Extensions

registering, Registering a Collation

usage examples, Collation Example

collation_list pragma, collation_list

column constraints (tables), Column constraints, Column constraints

column names, Column Names

column typing, Column types–Column types

comma (,), Basic Syntax

comments, Basic Syntax, Basic Syntax

C syntax, Basic Syntax

SQL syntax, Basic Syntax

COMMIT TRANSACTION command, SQL Transactions, COMMIT TRANSACTION

compound SELECT statements, Compound SELECT Statements–Compound SELECT Statements

concatenation (||) operator, Simple Operators, Binary Expressions

configuring SQLite, Zero Configuration, Configure

conversions, Result Columns, Conversion Function–Conversion Function

datatype rules, Result Columns

date and time, Conversion Function–Conversion Function

Coordinated Universal Time (UTC), Views, Time zones

count() function, count()

count_changes pragma, Step, count_changes

CREATE INDEX command, Indexes, CREATE INDEX–Description

CREATE TABLE command, The basics, Column constraints, Primary keys, Table constraints, Tables from queries, Keys Define the Table, Foreign Keys, Examples, CREATE TABLE–Conflict clause, Column constraints, Table constraints, PRIMARY KEY constraint, Conflict clause

column constraints, Column constraints, Column constraints

conflict clause, Conflict clause

creating tables from queries, Tables from queries

identifying foreign keys, Foreign Keys

identifying primary key, Keys Define the Table

PRIMARY KEY constraint, Primary keys, PRIMARY KEY constraint

syntax, The basics, CREATE TABLE–Conflict clause

table constraints, Table constraints, Table constraints

usage examples, Examples

CREATE TRIGGER command, CREATE TRIGGER–Description

CREATE VIEW command, Views, CREATE VIEW

CREATE VIRTUAL TABLE command, Virtual tables, Module API, Advanced Example: weblog Module, CREATE VIRTUAL TABLE

functionality, Virtual tables

syntax, Module API, Advanced Example: weblog Module, CREATE VIRTUAL TABLE

CROSS JOIN, CROSS JOIN, Simple JOINs

CURRENT_DATE literal, Column constraints, Time literals, Literal Expressions

CURRENT_TIME literal, Column constraints, Time literals, Literal Expressions

CURRENT_TIMESTAMP literal, Column constraints, Time literals, Literal Expressions

D

Data Control Language (DCL), SQL Data Languages

Data Definition Language, SQL Data Languages (see DDL)

Data Manipulation Language, SQL Data Languages (see DML)

data stores, SQLite support, Archives and Data Stores

Database Administrator (DBA), Index Summary

database connections, Opening, Special Cases, Closing, Example, Deadlocks, Avoiding deadlocks

closing, Closing

deadlocks, Deadlocks, Avoiding deadlocks

opening, Opening

special cases, Special Cases

usage examples, Example

database design, Tables and Keys–Keep It Specific, Common Structures and Relationships–More information, Normal Form–Higher Normal Forms, Indexes–Index Summary, Transferring Design Experience–Do One Thing

indexes, Indexes–Index Summary

Normal Forms, Normal Form–Higher Normal Forms

structures and relationships, Common Structures and Relationships–More information

tables and keys, Tables and Keys–Keep It Specific

transferring experience, Transferring Design Experience–Do One Thing

database locking, Database Locking, Busy handlers, Deadlocks, Avoiding SQLITE_BUSY, Avoiding deadlocks, When BUSY becomes BLOCKED

avoiding SQLITE_BUSY, Avoiding SQLITE_BUSY

busy handlers, Busy handlers

deadlocks, Deadlocks, Avoiding deadlocks

purpose, Database Locking

read-only, When BUSY becomes BLOCKED

.databases command, .databases

database_list pragma, Example Modules, Simple Example: dblist Module, database_list

datatype conversion rules, Result Columns

date and time features, Application Requirements, Representations–Time zones, Conversion Function–Conversion Function, Convenience functions, Time literals, Examples

application requirements, Application Requirements

convenience functions, Convenience functions

conversion function, Conversion Function–Conversion Function

literal expressions, Time literals

representations, Representations–Time zones

usage examples, Examples

date() function, Convenience functions, date()

datetime() function, Convenience functions, datetime()

Daylight Saving Time (DST), Time zones

DB-API 2.0 interface, Python

DBA (Database Administrator), Index Summary

DBD::SQLite module, Perl

DBI interface, Perl

dblist module example, Simple Example: dblist Module, Create and Connect–Create/connect dblist example, Disconnect and Destroy, Query Optimization, Custom Functions, Table Rename, Opening and Closing Table Cursors, Filtering Rows–Filtering Rows, Extracting and Returning Data–Extracting and Returning Data, Virtual Table Modifications, Cursor Sequence, Transaction Control, Register the Module, Example Usage

about, Simple Example: dblist Module

create and connect, Create and Connect–Create/connect dblist example

cursor sequence, Cursor Sequence

custom functions, Custom Functions

disconnect and destroy, Disconnect and Destroy

extracting and returning data, Extracting and Returning Data–Extracting and Returning Data

filtering rows, Filtering Rows–Filtering Rows

query optimization, Query Optimization

registering modules, Register the Module

table cursors, Opening and Closing Table Cursors

table rename, Table Rename

transaction control, Transaction Control

usage example, Example Usage

virtual table modifications, Virtual Table Modifications

DCL (Data Control Language), SQL Data Languages

DDL (Data Definition Language), SQL Data Languages, Data Definition Language, Tables–Virtual tables, Views, Indexes

about, SQL Data Languages, Data Definition Language

indexes, Indexes

tables, Tables–Virtual tables

views, Views

deadlocks, Deadlocks, Avoiding deadlocks

declarative languages, Declarative

default_cache_size pragma, default_cache_size

DEFERRED keyword, SQL Transactions, Avoiding SQLITE_BUSY

#define macros, Version Management

DELETE command, DELETE, DELETE, Description

syntax, DELETE, DELETE

WHERE clause, Description

denormalization, Denormalization

DESC keyword, ORDER BY Clause

DETACH DATABASE command, DETACH DATABASE

detail tables, One-to-One Relationships

DISTINCT keyword, SELECT command, The SELECT Pipeline, DISTINCT Keyword

division (/) operator, Simple Operators, Binary Expressions

DML (Data Manipulation Language), SQL Data Languages, Data Manipulation Language, INSERT–INSERT, UPDATE, DELETE, The Query Command–The Query Command

about, SQL Data Languages, Data Manipulation Language

DELETE command, DELETE

INSERT command, INSERT–INSERT

SELECT command, The Query Command–The Query Command

UPDATE command, UPDATE

documentation distribution, Documentation Distribution

DROP INDEX command, Indexes, DROP INDEX

DROP TABLE command, Dropping tables, Creating and Populating FTS Tables, Disconnect and Destroy, DROP TABLE

dblist module example, Disconnect and Destroy

deleting FTS tables, Creating and Populating FTS Tables

functionality, Dropping tables

syntax, DROP TABLE

DROP TRIGGER command, DROP TRIGGER

DROP VIEW command, Views, DROP VIEW

.dump command, .dump

E

.echo command, .echo

embedded systems development, Mobile and Embedded Development–Other Environments

ENABLE_READLINE directive, ENABLE_READLINE

encoding pragma, encoding

encryption, Additional Extensions

END TRANSACTION command, SQL Transactions, END TRANSACTION

entry points, Extension Design, Multiple Entry Points

equal (=) operator, Three-Valued Logic, Simple Operators, Binary Expressions

equal (==) operator, Simple Operators, Binary Expressions

error codes, Error Codes, Result Codes and Error Codes–When BUSY becomes BLOCKED, Returning Results and Errors–Returning Results and Errors

C API conventions, Error Codes, Result Codes and Error Codes–When BUSY becomes BLOCKED

scalar functions, Returning Results and Errors–Returning Results and Errors

EXCEPT operator, Compound SELECT Statements

EXCLUSIVE keyword, SQL Transactions, Avoiding SQLITE_BUSY

EXISTS operator, Subqueries, EXISTS

.exit command, .exit

EXPLAIN command, Index Summary, EXPLAIN

.explain command, .explain

EXPLAIN QUERY PLAN command, Index Summary

explicit join notation, Alternate JOIN Notation

expressions, SQLite SQL Expression Reference (see specific types of expressions)

extensions, SQL Functions and Extensions, SQL Functions and Extensions, SQLite Extensions, SQLite Extensions, SQLite Extensions, Extension Architecture, Extension Design, Extension Design, Example Extension: sql_trig–Example Extension: sql_trig, Building and Integrating Static Extensions–Building and Integrating Static Extensions, Using Loadable Extensions–Loading Loadable Extensions, Multiple Entry Points

architectural overview, Extension Architecture

defined, SQL Functions and Extensions, SQLite Extensions

design considerations, Extension Design

entry points, Extension Design, Multiple Entry Points

loadable, SQL Functions and Extensions, SQLite Extensions, Using Loadable Extensions–Loading Loadable Extensions

static, SQLite Extensions, Building and Integrating Static Extensions–Building and Integrating Static Extensions

usage examples, Example Extension: sql_trig–Example Extension: sql_trig

external modules, External Modules

F

Fifth Normal Form, Higher Normal Forms

file-globbing, Description

First Normal Form, The First Normal Form

floating-point numbers, Column types, Literal Expressions

foreign key constraints, Foreign Key Constraints–Foreign Key Constraints

foreign keys, Foreign Keys, Foreign Keys, One-to-Many Relationships, Many-to-Many Relationships

defined, Foreign Keys

many-to-many relationships, Many-to-Many Relationships

one-to-many relationships, One-to-Many Relationships

table constraints, Foreign Keys

foreign_keys pragma, Foreign Key Constraints, foreign_keys

foreign_key_list pragma, foreign_key_list

format() function, Scalar Functions

Fourth Normal Form, Higher Normal Forms

freelist_count pragma, freelist_count

FROM clause, SELECT command, The Query Command, The SELECT Pipeline, FROM Clause–Table aliases, Table aliases, Alternate JOIN Notation

functionality, The Query Command, The SELECT Pipeline

joining tables, FROM Clause–Table aliases, Alternate JOIN Notation

table aliases, Table aliases

FTS (Full Text Search) engine, Creating and Populating FTS Tables, Searching FTS Tables, More Details, Internal Modules

additional resources, More Details

creating and populating tables, Creating and Populating FTS Tables

internal modules and, Internal Modules

searching FTS tables, Searching FTS Tables

FTS (Full-Text Search) engine, Full-Text Search Module

functionality, Full-Text Search Module

FULL OUTER JOIN, OUTER JOIN

fullfsync pragma, fullfsync

full_column_names pragma, full_column_names

function calls, Structure, Busy handlers, Function Calls

busy handlers, Busy handlers

C API support, Structure

defined, Function Calls

G

general expressions, General Expressions–Description

generic ID keys, Generic ID Keys–Generic ID Keys

GLOB operator, Simple Operators, GLOB

glob() function, glob()

greater than (>) operator, Simple Operators, Binary Expressions

greater than or equal to (>=) operator, Simple Operators, Binary Expressions

Greenwich Mean Time, Time zones

GROUP BY clause, SELECT command, The SELECT Pipeline, GROUP BY Clause, SELECT Header, GROUP BY Examples

flattening row groups, SELECT Header

functionality, The SELECT Pipeline, GROUP BY Clause

usage examples, GROUP BY Examples

group_concat() function, group_concat()

H

HAVING clause, SELECT command, The SELECT Pipeline, HAVING Clause

.headers command, An sqlite3 Primer, .headers

.help command, .help

hex() function, hex()

HIDDEN keyword, Create and Connect

hierarchical relationships, Hierarchies and Trees, Adjacency Model, Nested set

adjacency model, Adjacency Model

common operations, Hierarchies and Trees

nested set, Nested set

Hwaci, Inc., Additional Extensions

I

ICU (International Components for Unicode), ICU Internationalization Extension, Description

ifnull() function, ifnull()

ignore_check_constraints pragma, ignore_check_constraints

IMMEDIATE keyword, SQL Transactions, Avoiding SQLITE_BUSY

imperative languages, Declarative

implicit join notation, Alternate JOIN Notation

.import command, .import

IN operator, Simple Operators, Subqueries, IN

functionality, Simple Operators, IN

subquery support, Subqueries

incremental_vacuum pragma, incremental_vacuum

indexes, Indexes, Indexes, Indexes, Indexes, How They Work, Must Be Diverse, INTEGER PRIMARY KEYs, Order Matters, One at a Time, Index Summary–Index Summary

column order, Order Matters

creating, Indexes

defined, Indexes, Indexes

as diverse, Must Be Diverse

dropping, Indexes

multicolumn limitations, One at a Time

overview, Index Summary–Index Summary

primary keys and, INTEGER PRIMARY KEYs

usage examples, How They Work

index_info pragma, index_info

index_list pragma, index_list

.indices command, .indices

INNER JOIN, INNER JOIN–INNER JOIN, Simple JOINs

INSERT command, INSERT–INSERT, Parameter Tokens, Potential Pitfalls, INSERT–Description

bound parameters and, Parameter Tokens, Potential Pitfalls

syntax, INSERT–INSERT, INSERT–Description

integers, Column types, Literal Expressions

integrity_check pragma, integrity_check

internal modules, Internal Modules, Transaction Control

International Components for Unicode (ICU), ICU Internationalization Extension, Description

International Standards Organization (ISO), Brief Background

INTERSECT operator, Compound SELECT Statements

.iotrace command, .iotrace

iPhone (Apple), iPhone Support

IS NOT operator, IS

IS operator, IS

isdigit() function, Collation Example

ISNULL operator, ISNULL

ISO (International Standards Organization), Brief Background

J

Java Database Compatibility (JDBC) interface, Java

Java language, Java

JOIN operators, FROM Clause–Table aliases, Alternate JOIN Notation, Simple JOINs

alternate notation, Alternate JOIN Notation

combining tables, FROM Clause–Table aliases

usage examples, Simple JOINs

journal_mode pragma, journal_mode

journal_size_limit pragma, journal_size_limit

Julian Day calendar, Julian Day

julianday() function, Convenience functions, julianday()

K

Kent, William, Higher Normal Forms

keys, Tables and Keys–Keep It Specific, Keys Are Backwards Pointers

design considerations, Keys Are Backwards Pointers

tables and, Tables and Keys–Keep It Specific

keyword expressions, General Expressions–Description

L

last_insert_rowid() function, last_insert_rowid()

LEFT OUTER JOIN, OUTER JOIN, OUTER JOIN

legacy_file_format pragma, legacy_file_format

length() function, length()

less than (<) operator, Simple Operators, Binary Expressions

less than or equal to (<=) operator, Simple Operators, Binary Expressions

library initialization, Library Initialization

LIKE operator, Simple Operators, LIKE

like() function, like()

LIMIT clause, SELECT command, The SELECT Pipeline, LIMIT and OFFSET Clauses

link tables, Many-to-Many Relationships

literal expressions, Basic Syntax, Time literals, Literal Expressions–Literal Expressions

date and time, Time literals

SQL syntax, Basic Syntax

supported datatypes, Literal Expressions–Literal Expressions

.load command, .load

loadable extensions, SQL Functions and Extensions, SQLite Extensions, Using Loadable Extensions–Loading Loadable Extensions

load_extension() function, load_extension()

locking_mode pragma, Avoiding SQLITE_BUSY, Storage, locking_mode

lock_proxy_file pragma, lock_proxy_file

lock_status pragma, lock_status

.log command, .log

logic operations, Simple Operators, Logic Representations

logical AND operator, Binary Expressions

logical OR operator, Binary Expressions

lower() function, ICU Internationalization Extension, lower()

ltrim() function, ltrim()

M

manifest typing, Column types

many-to-many relationships, Many-to-Many Relationships–Many-to-Many Relationships

MATCH operator, Simple Operators, Searching FTS Tables, MATCH

FTS engine and, Searching FTS Tables

functionality, Simple Operators, MATCH

match() function, match()

max() function, max(), max()

max_page_count pragma, max_page_count

MDB2 interface, PHP

memory management, Memory Management, Memory

mobile devices, Memory

utility functions, Memory Management

min() function, min(), min()

mobile device development, Mobile and Embedded Development–Other Environments

.mode command, An sqlite3 Primer, .mode

module API, Module API–Module API

modules, Virtual Tables and Modules, Virtual Tables and Modules, Introduction to Modules, Register the Module, Register the Module

additional information, Virtual Tables and Modules

categories of, Introduction to Modules

defined, Virtual Tables and Modules

registering, Register the Module, Register the Module

modulo (%) operator, Simple Operators, Binary Expressions

multiplication (*) operator, Simple Operators, Binary Expressions

N

NATURAL JOIN, INNER JOIN, JOIN...USING, NATURAL JOIN

negative sign (-) operator, Simple Operators, Unary Expressions

nested set representation, Nested set

nested transactions, Save-Points–Save-Points

.NET technologies, .NET

NOCASE collation, Collation Functions

Normal Forms, Normal Form, Normalization, Denormalization, The First Normal Form, The Second Normal Form, The Third Normal Form, Higher Normal Forms, Higher Normal Forms

defined, Normal Form

denormalization, Denormalization

Fifth Normal Form, Higher Normal Forms

First Normal Form, The First Normal Form

Fourth Normal Form, Higher Normal Forms

normalization, Normalization

Second Normal Form, The Second Normal Form

Third Normal Form, The Third Normal Form

normalization, Normal Form, Normalization

not equal (!=) operator, Simple Operators, Binary Expressions

not equal (<>) operator, Simple Operators, Binary Expressions

NOT operator, Three-Valued Logic, Simple Operators, Unary Expressions

functionality, Simple Operators, Unary Expressions

three valued logic, Three-Valued Logic

NOTNULL operator, ISNULL, NOTNULL

NULL datatype, Three-Valued Logic–Three-Valued Logic, Column types, Literal Expressions

defined, Column types, Literal Expressions

SQL syntax, Three-Valued Logic–Three-Valued Logic

nullif() function, nullif()

.nullvalue command, .nullvalue

O

ODBC (Open Database Connectivity), ODBC

OFFSET clause, SELECT command, The SELECT Pipeline, LIMIT and OFFSET Clauses

omit_readlock pragma, omit_readlock

one-to-many relationships, Foreign Keys, One-to-Many Relationships–One-to-Many Relationships

one-to-one relationships, One-to-One Relationships–One-to-One Relationships

Open Database Connectivity (ODBC), ODBC

OR operator, Three-Valued Logic, Simple Operators, Binary Expressions, Binary Expressions, OR

binary operations, Binary Expressions

logical operations, Simple Operators, Binary Expressions, OR

three valued logic, Three-Valued Logic

ORDER BY clause, SELECT command, The SELECT Pipeline, ORDER BY Clause, ORDER BY Examples

OUTER JOIN, OUTER JOIN

.output command, .output

P

page_count pragma, page_count

page_size pragma, Memory, page_size

parser_trace pragma, parser_trace

PDO (PHP Data Objects) interface, PHP

PEAR-DB interface, PHP

performance, statement parameters, Security and Performance–Security and Performance

Perl language, Perl

PHP language, PHP

positive sign (+) operator, Simple Operators, Unary Expressions

PRAGMA command, Other Resources, PRAGMA, SQLite SQL PRAGMA Reference–SQLite SQL PRAGMA Reference, auto_vacuum

(see also specific pragmas)

functionality, SQLite SQL PRAGMA Reference–SQLite SQL PRAGMA Reference

mobile devices and, Other Resources

syntax, PRAGMA

prepared statements, Statement Life Cycle–Statement Life Cycle, Prepare, Step–Step, Result Columns–Result Columns, Reset and Finalize, Statement Transitions, Examples

preparing, Prepare

resetting and finalizing, Reset and Finalize

result columns, Result Columns–Result Columns

statement life cycle, Statement Life Cycle–Statement Life Cycle

statement transitions, Statement Transitions

stepping through, Step–Step

usage examples, Examples

PRIMARY KEY constraint, Primary keys, PRIMARY KEY constraint

primary keys, Keys Define the Table, Generic ID Keys, INTEGER PRIMARY KEYs

defined, Keys Define the Table

indexes and, INTEGER PRIMARY KEYs

multicolumn, Generic ID Keys

proleptic Gregorian calendar, Julian Day

.prompt command, .prompt

PySQLite module, Python

Python language, Python

Q

queries, Tables from queries, SQL Tables, Query Optimization

creating tables from, Tables from queries

dblist module example, Query Optimization

sort considerations, SQL Tables

quick_check pragma, quick_check

.quit command, .quit

quote() function, quote()

R

R*Tree module, R*Trees and Spatial Indexing Module, Internal Modules

RAISE expression, RAISE

random() function, random()

randomblob() function, randomblob()

RDBMS (relational database management system), What Is SQLite?, Database Junior

.read command, An sqlite3 Primer, .read

read_uncommitted pragma, read_uncommitted

real numbers, Column types, Literal Expressions

recursive_triggers pragma, recursive_triggers

regex() function, regex()

REGEXP operator, Simple Operators, REGEXP

REINDEX command, REINDEX

relational database management system (RDBMS), What Is SQLite?, Database Junior

RELEASE SAVEPOINT command, Save-Points, RELEASE SAVEPOINT

remainder (%) operator, Binary Expressions

REPLACE command, REPLACE

replace() function, replace()

replication, Not the Best Choice

.restore command, .restore

result codes, Result Codes and Error Codes–Extended Codes, Returning Results and Errors–Returning Results and Errors

C APIs, Result Codes and Error Codes–Extended Codes

scalar functions, Returning Results and Errors–Returning Results and Errors

reverse_unordered_selects pragma, SQL Tables, reverse_unordered_selects

RIGHT OUTER JOIN, OUTER JOIN

ROLLBACK TO command, Save-Points

ROLLBACK TRANSACTION command, SQL Transactions, ROLLBACK TRANSACTION

round() function, round()

RTRIM collation, Collation Functions

rtrim() function, rtrim()

S

save-points, Save-Points–Save-Points

SAVEPOINT command, Save-Points, SAVEPOINT

scalar functions, SQL Functions and Extensions, Scalar Functions, Registering Functions–Registering Functions, Extracting Parameters–Extracting Parameters, Returning Results and Errors–Returning Results and Errors, Example–sql_getset_var_limit, Function Calls, SQLite SQL Function Reference, abs()–Description

built-in, abs()–Description

calling, Function Calls

defined, SQL Functions and Extensions, Scalar Functions, SQLite SQL Function Reference

extracting parameters, Extracting Parameters–Extracting Parameters

registering functions, Registering Functions–Registering Functions

returning results and errors, Returning Results and Errors–Returning Results and Errors

usage examples, Example–sql_getset_var_limit

.schema command, An sqlite3 Primer, .schema

schema_version pragma, schema_version

scripting languages, Scripting Languages and Other Interfaces (see specific languages)

search, full text, Searching FTS Tables (see FTS engine)

Second Normal Form, The Second Normal Form

secure_delete pragma, secure_delete

security, Security and Performance–Security and Performance, Loadable Extension Security

loadable extensions, Loadable Extension Security

statement parameters, Security and Performance–Security and Performance

SEE (SQLite Encryption Extension), Additional Extensions

SELECT command, The Query Command–The Query Command, The Query Command, The Query Command, The SELECT Command, The SELECT Pipeline, The SELECT Pipeline, The SELECT Pipeline, The SELECT Pipeline, The SELECT Pipeline, The SELECT Pipeline, The SELECT Pipeline, The SELECT Pipeline, The SELECT Pipeline, The SELECT Pipeline, FROM Clause–Table aliases, Table aliases, WHERE Clause, GROUP BY Clause, SELECT Header–SELECT Header, SELECT Header, SELECT Header, HAVING Clause, DISTINCT Keyword, ORDER BY Clause, LIMIT and OFFSET Clauses, LIMIT and OFFSET Clauses, Subqueries, Compound SELECT Statements–Compound SELECT Statements, Alternate JOIN Notation, SELECT Examples–ORDER BY Examples, WHERE Examples, GROUP BY Examples, ORDER BY Examples, SELECT–Compound statements, Basic format, Basic format, Additional clauses, Compound statements, SQLite SQL Expression Reference

additional clauses, Basic format, Additional clauses

compound SELECT statements, Compound SELECT Statements–Compound SELECT Statements

compound statements, Compound statements

DISTINCT keyword, The SELECT Pipeline, DISTINCT Keyword

expression support, SQLite SQL Expression Reference

FROM clause, The Query Command, The SELECT Pipeline, FROM Clause–Table aliases, Table aliases, Alternate JOIN Notation

functionality, The Query Command–The Query Command, The SELECT Command

GROUP BY clause, The SELECT Pipeline, GROUP BY Clause, SELECT Header, GROUP BY Examples

HAVING clause, The SELECT Pipeline, HAVING Clause

LIMIT clause, The SELECT Pipeline, LIMIT and OFFSET Clauses

OFFSET clause, The SELECT Pipeline, LIMIT and OFFSET Clauses

ORDER BY clause, The SELECT Pipeline, ORDER BY Clause, ORDER BY Examples

SELECT header, The SELECT Pipeline, SELECT Header–SELECT Header

subquery support, Subqueries

syntax, The SELECT Pipeline, SELECT–Compound statements

usage examples, SELECT Examples–ORDER BY Examples

WHERE clause, The Query Command, The SELECT Pipeline, WHERE Clause, WHERE Examples, Basic format

wildcard support, SELECT Header

SELECT expression, SELECT

SELECT header, SELECT command, The SELECT Pipeline, SELECT Header–SELECT Header

semicolon (;), Basic Syntax, SQLite SQL Command Reference

.separator command, .separator

shadow tables, Internal Modules, Transaction Control

shell.c source file, Source Files

short_column_names pragma, short_column_names

.show command, .show

sign negation (-) operator, Simple Operators, Unary Expressions

single quote ('), Basic Syntax

snprintft() function, Security and Performance

source distributions, The Amalgamation, Source Files, Source Downloads

amalgamation, The Amalgamation

source downloads, Source Downloads

source files, Source Files

SQL (Structured Query Language), The SQL Language, Learning SQL, Learning SQL, Brief Background, Declarative, Portability, General Syntax–Simple Operators, Basic Syntax, SQL Data Languages, SQL Data Languages, SQL Data Languages, SQL Data Languages, Data Definition Language–Indexes, Data Manipulation Language–The Query Command, Transaction Control Language–Save-Points, System Catalogs, Wrap-up, SQL Tables

about, The SQL Language, Brief Background

additional resources, Wrap-up

case sensitivity, Basic Syntax

DCL support, SQL Data Languages

DDL support, SQL Data Languages, Data Definition Language–Indexes

as declarative language, Declarative

DML support, SQL Data Languages, Data Manipulation Language–The Query Command

general syntax, General Syntax–Simple Operators

important command, Learning SQL

learning, Learning SQL

portability, Portability

system catalogs, System Catalogs

table structure, SQL Tables

TCL support, SQL Data Languages, Transaction Control Language–Save-Points

SQL commands, SQLite SQL Command Reference (see specific commands)

SQLite, What Is SQLite?, Self-Contained, No Server Required–Self-Contained, No Server Required, Single File Database, Zero Configuration, Embedded Device Support, Unique Features, Compatible License, Highly Reliable, Uses of SQLite–Generic SQL Engine, Not the Best Choice, Big Name Users, Building and Installing SQLite–Summary, Configure

building and installing, Building and Installing SQLite–Summary

common uses, Uses of SQLite–Generic SQL Engine

configuring, Zero Configuration, Configure

database requirements, Single File Database

defined, What Is SQLite?

embedded device support, Embedded Device Support

licensing considerations, Compatible License

limitations, Not the Best Choice

list of users, Big Name Users

reliability, Highly Reliable

server requirements, Self-Contained, No Server Required–Self-Contained, No Server Required

unique features, Unique Features

SQLite analyzer, SQLite Products

SQLite build options, Shell Directives, Default Values–Description, Sizes and Limits–Description, Operation and Behavior–Description, Debug Settings, Enable Extensions–Description, Limit Features, Omit Core Features

debug settings, Debug Settings

default values, Default Values–Description

enable extensions, Enable Extensions–Description

limit features, Limit Features

omit core features, Omit Core Features

operation and behavior, Operation and Behavior–Description

shell directives, Shell Directives

sizes and limits, Sizes and Limits–Description

SQLite core, SQLite Products, iPhone Support

SQLite Encryption Extension (SEE), Additional Extensions

SQLite Manager extension (Firefox), Additional Extensions

sqlite-3_x_x-tea.tar.gz file, Source Downloads

sqlite-amalgamation-3_x_x.tar.gz file, Source Downloads

sqlite-amalgamation-3_x_x.zip file, Source Downloads

sqlite-source-3_x_x.zip file, Source Downloads

sqlite.h source file, Source Files

sqlite3 application, SQLite Products, Precompiled Distributions, An sqlite3 Primer, An sqlite3 Primer, An sqlite3 Primer, An sqlite3 Primer, An sqlite3 Primer, sqlite3 Command Reference, Command-Line Options, Command-Line Options, Command-Line Options, Command-Line Options, Command-Line Options, Command-Line Options, Command-Line Options, Command-Line Options, Command-Line Options, Command-Line Options, Command-Line Options, Command-Line Options, Command-Line Options, Command-Line Options, Command-Line Options, Command-Line Options, Command-Line Options, Interactive Dot-Commands, .backup, .bail, .databases, .dump, .echo, .exit, .explain, .headers, .help, .import, .indices, .iotrace, .load, .log, .mode, .nullvalue, .output, .prompt, .quit, .read, .restore, .schema, .separator, .show, .tables, .timeout, .timer, .width

about, SQLite Products, An sqlite3 Primer, sqlite3 Command Reference, Command-Line Options

.backup command, .backup

.bail command, .bail

-bail option, Command-Line Options

-batch option, Command-Line Options

-column option, Command-Line Options

-csv option, Command-Line Options

.databases command, .databases

dot-commands, Interactive Dot-Commands

.dump command, .dump

.echo command, .echo

-echo option, Command-Line Options

.exit command, .exit

.explain command, .explain

-header option, Command-Line Options

.headers command, An sqlite3 Primer, .headers

.help command, .help

-help option, Command-Line Options

-html option, Command-Line Options

.import command, .import

.indices command, .indices

-init option, Command-Line Options

-interactive option, Command-Line Options

.iotrace command, .iotrace

-line option, Command-Line Options

-list option, Command-Line Options

.load command, .load

.log command, .log

.mode command, An sqlite3 Primer, .mode

-noheader option, Command-Line Options

.nullvalue command, .nullvalue

-nullvalue option, Command-Line Options

.output command, .output

precompiled distributions, Precompiled Distributions

.prompt command, .prompt

.quit command, .quit

.read command, An sqlite3 Primer, .read

.restore command, .restore

.schema command, An sqlite3 Primer, .schema

.separator command, .separator

-separator option, Command-Line Options

.show command, .show

.tables command, .tables

.timeout command, .timeout

.timer command, .timer

-version option, Command-Line Options

.width command, .width

sqlite3 structure, sqlite3

sqlite3.c source file, Source Files

sqlite3ext.h source file, Source Files, Extension Design

sqlite3_aggregate_context() function, Aggregate Context, sqlite3_aggregate_context()

sqlite3_auto_extension() function, Building and Integrating Static Extensions, sqlite3_auto_extension()

sqlite3_backup structure, sqlite3_backup

sqlite3_backup_finish() function, sqlite3_backup_finish()

sqlite3_backup_init() function, sqlite3_backup_init()

sqlite3_backup_pagecount() function, sqlite3_backup_pagecount()

sqlite3_backup_remaining() function, sqlite3_backup_remaining()

sqlite3_backup_step() function, Database Locking, sqlite3_backup_step()

sqlite3_bind_parameter_count() function, Binding Values, sqlite3_bind_parameter_count()

sqlite3_bind_parameter_index() function, Binding Values, sqlite3_bind_parameter_index()

sqlite3_bind_parameter_name() function, Binding Values, sqlite3_bind_parameter_name()

sqlite3_bind_xxx() function, Binding Values–Binding Values, sqlite3_bind_xxx()

sqlite3_blob structure, sqlite3_blob

sqlite3_blob_bytes() function, sqlite3_blob_bytes()

sqlite3_blob_close() function, sqlite3_blob_close()

sqlite3_blob_open() function, Database Locking, sqlite3_blob_open()

sqlite3_blob_read() function, sqlite3_blob_read()

sqlite3_blob_write() function, sqlite3_blob_write()

sqlite3_busy_handler() function, Busy handlers, sqlite3_busy_handler()

sqlite3_busy_timeout() function, Busy handlers, sqlite3_busy_timeout()

sqlite3_changes() function, sqlite3_changes()

sqlite3_clear_bindings() function, Binding Values, sqlite3_clear_bindings()

sqlite3_close() function, Closing, Database Locking, sqlite3_close()

sqlite3_collation_needed() function, sqlite3_collation_needed()

sqlite3_column_blob() function, Result Columns

sqlite3_column_bytes() function, Result Columns, sqlite3_column_bytes()

sqlite3_column_bytes16() function, Result Columns

sqlite3_column_count() function, Result Columns, sqlite3_column_count()

sqlite3_column_database_name() function, sqlite3_column_database_name()

sqlite3_column_decltype() function, sqlite3_column_decltype()

sqlite3_column_double() function, Result Columns

sqlite3_column_int() function, Result Columns

sqlite3_column_int64() function, Result Columns

sqlite3_column_name() function, Result Columns, sqlite3_column_name()

sqlite3_column_name16() function, Result Columns

sqlite3_column_origin_name() function, sqlite3_column_origin_name()

sqlite3_column_table_name() function, sqlite3_column_table_name()

sqlite3_column_text() function, Strings and Unicode, Result Columns

sqlite3_column_text16() function, Strings and Unicode, Result Columns

sqlite3_column_type() function, Result Columns, sqlite3_column_type()

sqlite3_column_value() function, Result Columns

sqlite3_column_xxx() function, Step, sqlite3_column_xxx()

sqlite3_commit_hook() function, sqlite3_commit_hook()

sqlite3_compileoption_get() function, sqlite3_compileoption_get()

sqlite3_compileoption_used() function, sqlite3_compileoption_used()

sqlite3_complete() function, sqlite3_complete()

sqlite3_config() function, Memory, sqlite3_config()

sqlite3_context structure, sqlite3_context

sqlite3_context_db_handle() function, Extracting Parameters, sqlite3_context_db_handle()

sqlite3_create_collation() function, Registering a Collation, sqlite3_create_collation()–Description

sqlite3_create_collation16() function, Registering a Collation

sqlite3_create_collation_v2() function, Registering a Collation

sqlite3_create_function() function, Structure, Registering Functions, sqlite3_create_function()

sqlite3_create_function16() function, Registering Functions

sqlite3_create_module() function, Module API, Create and Connect, sqlite3_create_module()

sqlite3_create_module_v2() function, Module API

sqlite3_data_count() function, sqlite3_data_count()

sqlite3_db_config() function, sqlite3_db_config()

sqlite3_db_handle() function, sqlite3_db_handle()

sqlite3_db_mutex() function, sqlite3_db_mutex()

sqlite3_db_status() function, sqlite3_db_status()

sqlite3_declare_vtab() function, Define the table structure, sqlite3_declare_vtab()

sqlite3_enable_load_extension() function, Loadable Extension Security, sqlite3_enable_load_extension()

sqlite3_enable_shared_cache() function, sqlite3_enable_shared_cache()

sqlite3_errcode() function, Error Functions, sqlite3_errcode()

sqlite3_errmsg() function, Error Functions, sqlite3_errmsg()

sqlite3_errmsg16() function, Error Functions

sqlite3_exec() function, Security and Performance, Convenience Functions, sqlite3_exec()

sqlite3_extended_errcode() function, Error Functions, sqlite3_extended_errcode()

sqlite3_extended_result_codes() function, Error Functions, sqlite3_extended_result_codes()

sqlite3_file_control() function, sqlite3_file_control()

sqlite3_finalize() function, Result Columns, Reset and Finalize, sqlite3_finalize()

sqlite3_free() function, Memory Management, sqlite3_free()

sqlite3_free_table() function, Convenience Functions, sqlite3_free_table()

sqlite3_get_autocommit() function, Transactions and Errors, sqlite3_get_autocommit()

sqlite3_get_auxdata() function, sqlite3_get_auxdata()

sqlite3_get_table() function, Convenience Functions, sqlite3_get_table()

sqlite3_index_info structure, Query Optimization

sqlite3_initialize() function, Library Initialization, sqlite3_initialize()

sqlite3_int64 structure, sqlite3_int64, sqlite3_uint64, sqlite_int64, sqlite_uint64

sqlite3_interrupt() function, Standard Codes, sqlite3_interrupt()

sqlite3_last_insert_rowid() function, sqlite3_last_insert_rowid()

sqlite3_libversion() function, Version Management, sqlite3_libversion()

sqlite3_libversion_number() function, Version Management, sqlite3_libversion_number()

sqlite3_limit() function, Example–sql_getset_var_limit, sqlite3_limit()

sqlite3_load_extension() function, Loading Loadable Extensions, sqlite3_load_extension()

sqlite3_log() function, sqlite3_log()

sqlite3_malloc() function, Memory Management, sqlite3_malloc()

sqlite3_memory_highwater() function, sqlite3_memory_highwater()

sqlite3_memory_used() function, sqlite3_memory_used()

sqlite3_module structure, Module API, Register the Module, sqlite3_module

sqlite3_mprintf() function, Convenience Functions, Allocate the vtab structure, sqlite3_mprintf()

sqlite3_mutex structure, sqlite3_mutex

sqlite3_mutex_alloc() function, sqlite3_mutex_alloc()

sqlite3_mutex_enter() function, sqlite3_mutex_enter()

sqlite3_mutex_free() function, sqlite3_mutex_free()

sqlite3_mutex_held() function, sqlite3_mutex_held()

sqlite3_mutex_leave() function, sqlite3_mutex_leave()

sqlite3_mutex_notheld() function, sqlite3_mutex_notheld()

sqlite3_mutex_try() function, sqlite3_mutex_try()

sqlite3_next_stmt() function, sqlite3_next_stmt()

sqlite3_open() function, Structure, Opening, sqlite3_open()

sqlite3_open16() function, Opening

sqlite3_open_v2() function, Structure, Opening, sqlite3_open_v2()–Description

sqlite3_overload_function() function, sqlite3_overload_function()

sqlite3_prepare_xxx() function, Prepare, Bound Parameters, sqlite3_prepare_xxx()

sqlite3_profile() function, sqlite3_profile()

sqlite3_progress_handler() function, sqlite3_progress_handler()

sqlite3_randomness() function, sqlite3_randomness()

sqlite3_realloc() function, Memory Management, sqlite3_realloc()

sqlite3_release_memory() function, sqlite3_release_memory()

sqlite3_reset() function, Result Columns, Reset and Finalize, sqlite3_reset()

sqlite3_reset_auto_extension() function, sqlite3_reset_auto_extension()

sqlite3_result_error_xxx() function, Returning Results and Errors, sqlite3_result_error_xxx()

sqlite3_result_xxx() function, Returning Results and Errors, sqlite3_result_xxx()

sqlite3_rollback_hook() function, sqlite3_rollback_hook()

sqlite3_set_authorizer() function, sqlite3_set_authorizer()

sqlite3_set_auxdata() function, sqlite3_set_auxdata()

sqlite3_shutdown() function, Library Initialization, sqlite3_shutdown()

sqlite3_sleep() function, sqlite3_sleep()

sqlite3_snprintf() function, Convenience Functions, sqlite3_snprintf()

sqlite3_soft_heap_limit() function, sqlite3_soft_heap_limit()

sqlite3_sourceid() function, Version Management, sqlite3_sourceid()

sqlite3_sql() function, sqlite3_sql()

sqlite3_status() function, sqlite3_status()

sqlite3_step() function, Step, Prepare v2, Filtering Rows, sqlite3_step()

sqlite3_stmt structure, Prepared Statements–Examples, sqlite3_stmt

sqlite3_stmt_status() function, Index Summary, sqlite3_stmt_status()

sqlite3_strnicmp() function, sqlite3_strnicmp()

sqlite3_table_column_metadata() function, sqlite3_table_column_metadata(), Definition

sqlite3_threadsafe() function, sqlite3_threadsafe()

sqlite3_total_changes() function, sqlite3_total_changes()

sqlite3_trace() function, sqlite3_trace()

sqlite3_uint64 structure, sqlite3_int64, sqlite3_uint64, sqlite_int64, sqlite_uint64

sqlite3_unlock_notify() function, sqlite3_unlock_notify()

sqlite3_update_hook() function, sqlite3_update_hook()

sqlite3_user_data() function, Extracting Parameters, sqlite3_user_data()

sqlite3_value structure, sqlite3_value

sqlite3_value_blob() function, Extracting Parameters

sqlite3_value_bytes() function, Extracting Parameters, sqlite3_value_bytes()

sqlite3_value_bytes16() function, Extracting Parameters

sqlite3_value_double() function, Extracting Parameters

sqlite3_value_int() function, Extracting Parameters

sqlite3_value_int64() function, Extracting Parameters

sqlite3_value_numeric_type() function, Extracting Parameters, Example, sqlite3_value_numeric_type(), Description

sqlite3_value_text() function, Extracting Parameters

sqlite3_value_text16() function, Extracting Parameters

sqlite3_value_type() function, Extracting Parameters, sqlite3_value_type()

sqlite3_value_xxx() function, sqlite3_value_xxx()

sqlite3_version[] function, sqlite3_version[]

sqlite3_vfs structure, sqlite3_vfs

sqlite3_vfs_find() function, sqlite3_vfs_find()

sqlite3_vfs_register() function, sqlite3_vfs_register()

sqlite3_vfs_unregister() function, sqlite3_vfs_unregister()

sqlite3_vmprintf() function, Convenience Functions, sqlite3_vmprintf()

sqlite3_vtab structure, Allocate the vtab structure

sqlite3_vtab_cursor structure, Opening and Closing Table Cursors

SQLiteJDBC package, Java

SQLiteODBC package, ODBC

SQLITE_ABORT return code, Standard Codes

SQLITE_AUTH return code, Standard Codes

SQLITE_BUSY return code, Standard Codes, Transactions and Errors, Database Locking, Avoiding SQLITE_BUSY

SQLITE_CANTOPEN return code, Standard Codes

SQLITE_CASE_SENSITIVE_LIKE directive, SQLITE_CASE_SENSITIVE_LIKE

sqlite_compileoption_get() function, Description

sqlite_compileoption_used() function, sqlite_compileoption_used()

SQLITE_CONSTRAINT return code, Standard Codes

SQLITE_CORRUPT return code, Standard Codes

SQLITE_DEBUG directive, SQLITE_DEBUG

SQLITE_DEFAULT_AUTOVACUUM directive, SQLITE_DEFAULT_AUTOVACUUM

SQLITE_DEFAULT_CACHE_SIZE directive, SQLITE_DEFAULT_CACHE_SIZE

SQLITE_DEFAULT_FILE_FORMAT directive, SQLITE_DEFAULT_FILE_FORMAT

SQLITE_DEFAULT_JOURNAL_SIZE_LIMIT directive, SQLITE_DEFAULT_JOURNAL_SIZE_LIMIT

SQLITE_DEFAULT_MEMSTATUS directive, SQLITE_DEFAULT_MEMSTATUS

SQLITE_DEFAULT_PAGE_SIZE directive, SQLITE_DEFAULT_PAGE_SIZE

SQLITE_DEFAULT_TEMP_CACHE_SIZE directive, SQLITE_DEFAULT_TEMP_CACHE_SIZE

SQLITE_DISABLE_DIRSYNC directive, SQLITE_DISABLE_DIRSYNC

SQLITE_DISABLE_LFS directive, SQLITE_DISABLE_LFS

SQLITE_EMPTY return code, Standard Codes

SQLITE_ENABLE_ATOMIC_WRITE directive, SQLITE_ENABLE_ATOMIC_WRITE

SQLITE_ENABLE_COLUMN_METADATA directive, SQLITE_ENABLE_COLUMN_METADATA

SQLITE_ENABLE_FTS3 directive, Full-Text Search Module, SQLITE_ENABLE_FTS3

SQLITE_ENABLE_FTS3_PARENTHESIS directive, Full-Text Search Module, SQLITE_ENABLE_FTS3_PARENTHESIS

SQLITE_ENABLE_ICU directive, ICU Internationalization Extension, SQLITE_ENABLE_ICU

SQLITE_ENABLE_IOTRACE directive, SQLITE_ENABLE_IOTRACE

SQLITE_ENABLE_LOCKING_STYLE directive, SQLITE_ENABLE_LOCKING_STYLE

SQLITE_ENABLE_MEMORY_MANAGEMENT directive, SQLITE_ENABLE_MEMORY_MANAGEMENT

SQLITE_ENABLE_MEMSYS3 directive, SQLITE_ENABLE_MEMSYS3

SQLITE_ENABLE_MEMSYS5 directive, SQLITE_ENABLE_MEMSYS5

SQLITE_ENABLE_RTREE directive, SQLITE_ENABLE_RTREE

SQLITE_ENABLE_STAT2 directive, SQLITE_ENABLE_STAT2

SQLITE_ENABLE_UNLOCK_NOTIFY directive, SQLITE_ENABLE_UNLOCK_NOTIFY

SQLITE_ENABLE_UPDATE_DELETE_LIMIT directive, SQLITE_ENABLE_UPDATE_DELETE_LIMIT

SQLITE_ERROR return code, Standard Codes

SQLITE_EXTENSION_INIT1 macro, Extension Design

SQLITE_FORMAT return code, Standard Codes

SQLITE_FULL return code, Standard Codes, Transactions and Errors

SQLITE_HAVE_ISNAN directive, SQLITE_HAVE_ISNAN

sqlite_int64 structure, sqlite3_int64, sqlite3_uint64, sqlite_int64, sqlite_uint64

SQLITE_INTERNAL return code, Standard Codes

SQLITE_INTERRUPT return code, Standard Codes, Transactions and Errors

SQLITE_IOERR return code, Standard Codes, Transactions and Errors, Database Locking, When BUSY becomes BLOCKED

SQLITE_LOCKED return code, Standard Codes

sqlite_master catalog, System Catalogs

SQLITE_MAX_ATTACHED directive, SQLITE_MAX_ATTACHED

SQLITE_MAX_COLUMN directive, SQLITE_MAX_COLUMN

SQLITE_MAX_COMPOUND_SELECT directive, SQLITE_MAX_COMPOUND_SELECT

SQLITE_MAX_DEFAULT_PAGE_SIZE directive, SQLITE_MAX_DEFAULT_PAGE_SIZE

SQLITE_MAX_EXPR_DEPTH directive, SQLITE_MAX_EXPR_DEPTH

SQLITE_MAX_FUNCTION_ARG directive, SQLITE_MAX_FUNCTION_ARG

SQLITE_MAX_LENGTH directive, SQLITE_MAX_LENGTH

SQLITE_MAX_LIKE_PATTERN_LENGTH directive, SQLITE_MAX_LIKE_PATTERN_LENGTH

SQLITE_MAX_PAGE_COUNT directive, SQLITE_MAX_PAGE_COUNT

SQLITE_MAX_PAGE_SIZE directive, SQLITE_MAX_PAGE_SIZE

SQLITE_MAX_SQL_LENGTH directive, SQLITE_MAX_SQL_LENGTH

SQLITE_MAX_TRIGGER_DEPTH directive, SQLITE_MAX_TRIGGER_DEPTH

SQLITE_MAX_VARIABLE_NUMBER directive, SQLITE_MAX_VARIABLE_NUMBER

SQLITE_MEMDEBUG directive, SQLITE_MEMDEBUG

SQLITE_MISMATCH return code, Standard Codes

SQLITE_MISUSE return code, Standard Codes

SQLITE_NOLFS return code, Standard Codes

SQLITE_NOMEM return code, Standard Codes, Transactions and Errors

SQLITE_NOTADB return code, Standard Codes

SQLITE_OK return code, Standard Codes, Create and Connect

SQLITE_OMIT_ANALYZE directive, Omit Core Features

SQLITE_OMIT_VIRTUALTABLE directive, Omit Core Features

SQLITE_OS_OTHER directive, SQLITE_OS_OTHER

SQLITE_PERM return code, Standard Codes

SQLITE_RANGE return code, Standard Codes

SQLITE_READONLY return code, Standard Codes

SQLITE_SCHEMA return code, Standard Codes, Prepare v2

SQLITE_SECURE_DELETE directive, SQLITE_SECURE_DELETE

sqlite_source_id() function, sqlite_source_id()

SQLITE_TEMP_STORE directive, SQLITE_TEMP_STORE

SQLITE_THREADSAFE directive, SQLITE_THREADSAFE

SQLITE_TOOBIG return code, Standard Codes

sqlite_uint64 structure, sqlite3_int64, sqlite3_uint64, sqlite_int64, sqlite_uint64

sqlite_version() function, sqlite_version()

SQLITE_ZERO_MALLOC directive, SQLITE_ZERO_MALLOC

sql_trace pragma, sql_trace

square brackets [ ], Basic Syntax

statement parameters, Bound Parameters, Parameter Tokens–Parameter Tokens, Parameter Tokens, Binding Values–Binding Values, Security and Performance–Security and Performance, Example, Potential Pitfalls–Potential Pitfalls

binding values, Binding Values–Binding Values

defined, Bound Parameters

parameter tokens, Parameter Tokens–Parameter Tokens

potential pitfalls, Potential Pitfalls–Potential Pitfalls

quotation marks and, Parameter Tokens

security and performance, Security and Performance–Security and Performance

usage examples, Example

static extensions, SQLite Extensions, Building and Integrating Static Extensions–Building and Integrating Static Extensions

storage, Storage, Storage initialization

initializing, Storage initialization

mobile devices, Storage

storage classes, Column types

strftime() function, Conversion Function–Conversion Function, strftime()–Description

string concatenation (||) operator, Simple Operators, Binary Expressions

strings (text), Basic Syntax, Column types, Strings and Unicode, Text values, Literal Expressions

date and time values, Text values

defined, Column types, Literal Expressions

SQL syntax, Basic Syntax

Unicode encoding and, Strings and Unicode

Structured Query Language, The SQL Language (see SQL)

subqueries, defined, Subqueries

substr() function, substr()

subtraction (-) operator, Simple Operators, Binary Expressions

sum() function, GROUP BY Examples, sum()

surrogate keys, Generic ID Keys

synchronous pragma, synchronous–Description

system catalogs, System Catalogs

System.Data.SQLite package, .NET

T

table aliases, Table aliases

table cursor, Module API, Opening and Closing Table Cursors

tables, Column types–Column types, Column constraints, Primary keys, Table constraints, Tables from queries, Altering tables, Dropping tables, Virtual tables, Row Modification Commands–DELETE, SQL Tables, FROM Clause–Table aliases, Alternate JOIN Notation, Simple JOINs, Tables and Keys–Keep It Specific, Foreign Keys, Keep It Specific, Common Structures and Relationships–More information, Normal Form–Higher Normal Forms, Tables Are Types, Creating and Populating FTS Tables, Table Rename, Column constraints, Table constraints, PRIMARY KEY constraint

(see also virtual tables)

altering, Altering tables

basic structure, SQL Tables

column constraints, Column constraints, Column constraints

column types, Column types–Column types

creating from queries, Tables from queries

creating with FTS, Creating and Populating FTS Tables

design considerations, Keep It Specific, Tables Are Types

dropping, Dropping tables

joining, FROM Clause–Table aliases, Alternate JOIN Notation, Simple JOINs

keys and, Tables and Keys–Keep It Specific

Normal Forms, Normal Form–Higher Normal Forms

primary keys, Primary keys, PRIMARY KEY constraint

renaming, Table Rename

row modification commands, Row Modification Commands–DELETE

structures and relationships, Common Structures and Relationships–More information

table constraints, Table constraints, Foreign Keys, Table constraints

.tables command, .tables

table_info pragma, table_info

TCL (Transaction Control Language), SQL Data Languages, Transaction Control Language, ACID Transactions–ACID Transactions, SQL Transactions–SQL Transactions, Save-Points–Save-Points, Tcl

about, SQL Data Languages, Transaction Control Language

ACID transactions, ACID Transactions–ACID Transactions

additional information, Tcl

save-points, Save-Points–Save-Points

SQL transactions, SQL Transactions–SQL Transactions

TEA (Tcl Extension Architecture), SQLite Products, Tcl

TEMP keyword, Tables from queries

temp_store pragma, temp_store

temp_store_directory pragma, temp_store_directory

ternary logic, Three-Valued Logic–Three-Valued Logic

text (strings), Basic Syntax, Column types, Strings and Unicode, Text values, Literal Expressions

date and time values, Text values

defined, Column types, Literal Expressions

SQL syntax, Basic Syntax

Unicode encoding and, Strings and Unicode

Third Normal Form, The Third Normal Form

three valued logic (3VL), Three-Valued Logic–Three-Valued Logic

time zones, Time zones

time() function, Convenience functions, time()

.timeout command, .timeout

.timer command, .timer

total() function, total()

total_changes() function, total_changes()

Transaction Control Language, SQL Data Languages (see TCL)

TRANSACTION keyword, SQL Transactions

transaction processing, Not the Best Choice, ACID Transactions–ACID Transactions, SQL Transactions–SQL Transactions, Save-Points–Save-Points, Transaction Control

ACID transactions, ACID Transactions–ACID Transactions

dblist module example, Transaction Control

save-points, Save-Points–Save-Points

SQL transactions, SQL Transactions–SQL Transactions

SQLite limitations, Not the Best Choice

trees, Hierarchies and Trees, Adjacency Model, Nested set

adjacency model, Adjacency Model

common operations, Hierarchies and Trees

nested set, Nested set

trim() function, trim()

type affinities, Column types, Column types, Column types

column types and, Column types

defined, Column types

mapping, Column types

typeof() function, typeof()

U

unary operators, Simple Operators, Unary Expressions–Unary Expressions

UNION ALL operator, Compound SELECT Statements

UNION operator, Compound SELECT Statements

UNIQUE keyword, Indexes

UPDATE command, UPDATE, UPDATE–Description, Description, Description

constraint resolution clauses, Description

syntax, UPDATE, UPDATE–Description

WHERE clause, Description

upper() function, ICU Internationalization Extension, upper()

user_version pragma, user_version

USING condition, INNER JOIN, JOIN...USING, NATURAL JOIN

UTC (Coordinated Universal Time), Views, Time zones

UTF-16 encoding, Strings and Unicode

UTF-8 encoding, Strings and Unicode

V

VACUUM command, VACUUM–Description

VDBE (Virtual Database Engine), Step

vdbe_listing pragma, vdbe_listing

vdbe_trace pragma, vdbe_trace

version management, Version Management

views, creating and dropping, Views

Virtual Database Engine (VDBE), Step

virtual table API, Module API–Module API

virtual tables, Virtual tables, Virtual Tables and Modules, Introduction to Modules, Virtual Table Modifications, Advanced Example: weblog Module

categories of, Introduction to Modules

creating, Virtual tables, Advanced Example: weblog Module

dblist module example, Virtual Table Modifications

defined, Virtual Tables and Modules

W

weblog module example, Advanced Example: weblog Module, Create and Connect–Create and Connect, Disconnect and Destroy, Other Table Functions, Open and Close–Open and Close, Filter–Filter, Rows and Columns–Rows and Columns, Register the Module, Example Usage–Example Usage

about, Advanced Example: weblog Module

create and connect, Create and Connect–Create and Connect

disconnect and destroy, Disconnect and Destroy

filter, Filter–Filter

open and close, Open and Close–Open and Close

registering module, Register the Module

rows and columns, Rows and Columns–Rows and Columns

table functions, Other Table Functions

usage example, Example Usage–Example Usage

webserver log analysis, SQL for Anything

WHERE clause, DELETE command, Description

WHERE clause, SELECT command, The Query Command, The SELECT Pipeline, WHERE Clause, WHERE Examples, Basic format

functionality, The Query Command, The SELECT Pipeline, WHERE Clause, Basic format

usage examples, WHERE Examples

.width command, .width

wildcards, SELECT Header

writable_schema pragma, writable_schema

X

xBegin() function, Module API, Transaction Control

xBestIndex() function, Module API, Query Optimization, Filtering Rows, xBestIndex()–xBestIndex()

xClose() function, Module API, Opening and Closing Table Cursors

xColumn() function, Module API, Extracting and Returning Data, Rows and Columns

xCommit() function, Module API, Transaction Control

xConnect() function, Module API, Create and Connect

xCreate() function, Module API, Create and Connect

xDestroy() function, Module API, Disconnect and Destroy

xDisconnect() function, Module API, Disconnect and Destroy

xEof() function, Module API, Extracting and Returning Data

xFilter() function, Module API, Filtering Rows, xFilter()–Typical Usage

xFindFunction() function, Module API, Custom Functions

xNext() function, Module API, Extracting and Returning Data

xOpen() function, Module API, Allocate the vtab structure, Opening and Closing Table Cursors

xRename() function, Module API, Allocate the vtab structure, Table Rename

xRollback() function, Module API, Transaction Control

xRowid() function, Module API, Extracting and Returning Data

xSync() function, Module API, Transaction Control

xUpdate() function, Module API, Virtual Table Modifications

Y

YYSTACKDEPTH directive, YYSTACKDEPTH

YYTRACKMAXSTACKDEPTH directive, YYTRACKMAXSTACKDEPTH

Z

zeroblob() function, zeroblob()