SQLite

Index

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W]

C/C++ 2nd 3rd

     core API 2nd 3rd    databases

         closing 2nd 3rd 4th 5th 6th 7th         finding information about database changes

         inserting data into 2nd 3rd 4th

         locked files 2nd         opening 2nd 3rd 4th 5th 6th 7th         updating 2nd     error codes 2nd 3rd 4th

    functions         aggregating functions 2nd 3rd         avgFinalize()

         callback() 2nd

         creating 2nd 3rd 4th 5th

         sqlite_aggregate_context()

         sqlite_busy_handler()         sqlite_busy_handler[)

         sqlite_busy_timeout[)

         sqlite_changes() 2nd         sqlite_changes[)

         sqlite_close() 2nd 3rd 4th

         sqlite_compile() 2nd 3rd         sqlite_compile() function 2nd         sqlite_complete() 2nd         sqlite_complete[)

         sqlite_create_aggregate()

         sqlite_create_aggregate[)

         sqlite_create_function() 2nd 3rd

         sqlite_create_function[)

         sqlite_encoding[) 2nd

         sqlite_exec() 2nd 3rd 4th 5th 6th 7th

         sqlite_exec_printf()

         sqlite_finalize() 2nd 3rd 4th

         sqlite_freemem()

         sqlite_freemem[)

         sqlite_get_table() 2nd 3rd

         sqlite_get_table[)

         sqlite_get_table_mprintf[)         sqlite_interrupt[)         sqlite_last_insert_rowid()

         sqlite_last_insert_rowid[)

         sqlite_mprintf()         sqlite_mprintf[)

         sqlite_open() 2nd 3rd 4th

         sqlite_progress_handler[)

         sqlite_set_result_double()

         sqlite_set_result_double[)

         sqlite_set_result_error[)

         sqlite_set_result_int[)         sqlite_set_result_string[)

         sqlite_step() 2nd 3rd 4th 5th         sqlite_step() function

         sqlite_user_data[)

         sqlite_version[) 2nd         sqliteAtoF()         sumFinalize()         sumStep()

    jobs         performing in background     memory management

     non-callaback AP 2nd

     preparing to use 2nd

    queries

         executing 2nd    result sets

         returning 2nd 3rd

     return codes 2nd    SQL statements

         checking

         executing with callback functions 2nd 3rd 4th 5th 6th 7th         executing without callback functions 2nd 3rd 4th 5th 6th         interrupting         step-by-step execution

    SQLite library

         finding version of 2nd 3rd

     SQLite virtual machines, creating 2nd

C/C++ interface

C/C++losing

    databases

         sqlite_close() function

C/C++ore C API 2nd

cache_size directive (PRAGMA command)

calcualting

     median averages 2nd 3rd

callback functions 2nd 3rd

Callback opcode callback() function 2ndcalling

     functions

     UDFs (user-defined functions) 2nd Cartesian joins 2nd

case sensitivity 2nd

changes method 2nd

CHECK clause

     CREATE TABLE statement

CHECK statement

classes     DatabaseError 2nd

     DataError     Error 2nd

     IntegrityError

     InterfaceError     InternalError     NotSupportedError     OperationalError

     PEAR 2nd 3rd     ProgrammingError     StandardError

clauses

    CHECK

         CREATE TABLE statement

    CONSTRAINT         CREATE TABLE statement 2nd

     GROUP BY 2nd 3rd 4th

     HAVING 2nd     LIMIT 2nd

    ON CONFLICT

         CREATE TABLE statement 2nd     ORDER BY 2nd 3rd     USING DELIMITERS    WHEN

         CREATE TRIGGER statement

    WHERE

         DELETE statement

         UPDATE statement

client/server applications 2nd

close method

closing

    databases

         cx.close() command 2nd

         dbcmd close command

         disconnect() function 2nd

         sqlite_close() function 2nd 3rd 4th

         Tcl interface 2nd     sqlite code generators

code listings

     benchmark.sh script 2nd     changes method

    CREATE TABLE statement

         executing with C/C++ 2nd

    database timeouts

         handling with Tcl interface

    databases

         adding data to 2nd         connecting with C/C++

         opening         updating 2nd

    functions

         creating 2nd    index examples         joint1t2.sql         joint2t1.sql

         t1word.sql         tl.sql    Perl DBI

         aggregating functions, creating 2nd

         available_drivers() function 2nd

         bind values 2nd 3rd

         database updates         databases, adding records to 2nd

         databases, adding tables to

         fetchrow_array() function         fetchrow_arrayref () function

         quote() function

         tracing         user-defined functions, creating 2nd     PRAGMA show_datatypes command    PySQLite

         .execute() command

         aggregate functions

         database records, fetching 2nd

         database records, inserting

         database updates, checking

         error handling

         SQL statements, executing 2nd

         user-defined functions, creating 2nd

         user-defined functions, registering

    queries

         executing without callback functions 2nd

    records

         inserting with Tcl    result sets         accessing random rows in 2nd

         displaying in HTML tables 2nd

         displaying with callback functions 2nd         returning in single array 2nd

         returning one at a time 2nd

     result sets, displaying in HTML tables 2nd

    rows

         inserting with Tcl

    SELECT queries

         assigning output to variables         processing results of 2nd

     special characters, escaping 2nd    SQL statements

         CREATE TABLE

         validating with Tcl interface 2nd     SQL statements, executing with Tcl     SQLite extension, checking for     SQLITE_BUSY Status 2nd

     sqlite_busy_handler() function 2nd    tables         creating with ANSI data types

         creating with made-up data types

         creating without data types

    UDFs (user-defined functions)

         aggregating functions 2nd         calling with php() 2nd

         creating 2nd

    user-defined functions         registering with Tcl interface 2nd

     vegetables.csv

     virtual machine program 2nd COLLATE statementcollating sequences     SQLite version 3.0 2nd

Column opcode

columns

     aliases 2nd

     binary data 2nd

     BLOBs 2nd

     constraints 2nd

     dates 2nd

     DEFAULT

     defining 2nd

     INTEGER PRIMARY KEY columns 2nd

    multiple columns

         indexing 2nd

     NOT NULL 2nd     PRIMARY KEY     returning information about 2nd

     UNIQUE

command_logfile argument (sqlite.connect() command)commands [See names of specific commands] [See names of specific commands] [See statements]

comments

COMMIT TRANSACTION statement 2nd 3rd

commit() function 2nd

commit() method

committing

    transactions         commit() function 2nd

comparing strings 2nd 3rdcompiling

     PySQLite

complete method 2nd concatenation operatorconcurrency     high concurrency 2nd

     SQLite version 3.0 2ndconfiguration     PHP 2nd

         Linux/Unix configuration 2nd

         SQLite extension, returning information about 2nd

         SQLite support, checking for 2nd

         Windows configuration 2nd configure command

confirming

     database changes 2nd 3rd conflict resolution 2nd 3rd 4th

connect() function 2nd 3rd 4th 5th 6th 7th

connecting to databases 2ndconnection parameters     PySQLite 2ndconstants

     SQLITE_ASSOC

     SQLITE_BOTH

     SQLITE_NUM

CONSTRAINT clause

     CREATE TABLE statement 2nd

constraints (column) 2nd

convenience functions 2nd 3rd

converters argument (sqlite.connect() command)

converting

     time zones

Coordinated Universal Time (UTC)

COPY statement 2nd 3rd

copying     tables core C API

coreutils package

count() function 2nd 3rd count_changes directive (PRAGMA command) 2nd

CREATE INDEX statement 2nd 3rd

CREATE TABLE statement

     executing 2nd

     executing with C/C++ 2nd

     sample database 2nd 3rd 4th 5th

CREATE TRIGGER statement 2nd 3rd 4th CREATE UNIQUE INDEX statement 2nd 3rd 4th

CREATE VIEW statement 2nd create_aggregate() function 2nd 3rd 4th 5th

create_function() function 2nd 3rd 4th

cu.execute() command 2nd 3rd 4th 5th cu.fetchall() command 2nd cu.fetchmany() command 2nd 3rd 4th cu.fetchone() command 2nd 3rd

cu.rowcount() command 2nd 3rd cu.rownumber() commandcustom functions

    registering

         dbcmd function command

customization 2nd 3rd [See also user-defined functions]

cx = sqlite.connect() command 2nd 3rd 4th 5th cx.close() command 2nd

cx.commit() command 2nd

cx.create_aggregate() command 2nd 3rd 4th 5th 6th cx.create_function() command 2nd 3rd

cx.cursor() command 2nd

cx.rollback() command