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]

safe mode

scalability of SQLite 2ndschemas

     returning information about 2nd     viewing 2nd

scripts

     benchmark.sh 2nd     ppm.batsearching    tables

         SQLite Database Browser security 2nd     database locking 2nd 3rd 4th 5th

     file permissions 2nd

     multithreaded database access 2nd

     safe mode

     timeouts 2nd 3rd 4th 5th SELECT statement 2nd

     aggregate functions 2nd 3rd 4th 5th

     AND operator     arithmetic operators 2nd 3rd

     BETWEEN operator

     callback functions 2nd 3rd     column aliases 2nd     FROM clause 2nd     GROUP BY clause 2nd 3rd 4th

     HAVING clause 2nd

     IN operator

     IS NOT NULL operator

     IS NULL operator

     joins 2nd 3rd 4th 5th

     LEFT JOIN operator 2nd 3rd

     LIKE operator 2nd

     LIMIT clause 2nd

     NOT LIKE operator

     NULL values 2nd

     OR operator

     ORDER BY clause 2nd 3rd

     output, assigning to variables    processing results of         Tcl interface 2nd

     string comparisons 2nd 3rd

     string operators 2nd     syntax 2nd 3rd 4th

     WHERE clause 2nd 3rd 4th 5th 6th

sending

     output to files

seq command

SHARED locking state

show_datatypes directive (PRAGMA command) SmallTalk

sort order     indexes

source code, installing SQLite from 2nd

special characters, escaping 2nd speed of SQLite 2ndSQL    commands

         reading from files 2nd 3rd     functions [See also specific function names]         aggregating functions 2nd 3rd

         arbitrary data, referencing 2nd

         creating 2nd 3rd 4th 5th

         registering 2nd

         return values, setting 2nd     UDFs (user-defined functions) 2nd 3rd 4th 5th

         aggregating functions 2nd 3rd 4th 5th

         binary data 2nd         calling 2nd

         creating 2nd 3rd 4th

SQL statements     ALTER TABLE     ANSI-92 unsupported features 2nd     ATTACH DATABASE 2nd 3rd 4th 5th

     BEGIN TRANSACTION 2nd 3rd

     case sensitivity

     CHECK 2nd

     checking

         dbcmd complete command

     COLLATE

     comments

     COMMIT TRANSACTION 2nd 3rd

     COPY 2nd 3rd

     CREATE INDEX 2nd 3rd

     CREATE TABLE 2nd 3rd

         CHECK clause

         conflict resolution         CONSTRAINT clause 2nd         executing 2nd

         executing with C/C++ 2nd

         ON CONFLICT clause 2nd    CREATE TABLE statement

         sample database 2nd 3rd 4th 5th

     CREATE TEMPORARY TABLE 2nd

     CREATE TRIGGER 2nd 3rd 4th

     CREATE UNIQUE INDEX 2nd 3rd 4th

     CREATE VIEW 2nd

     DEFAULT     DELETE 2nd 3rd 4th

     DETACH DATABASE 2nd     DISTINCT

     DROP INDEX

     DROP TABLE 2nd 3rd     DROP TRIGGER 2nd     DROP VIEW 2nd     EXCEPT

     executing from files 2nd     executing with callback functions 2nd 3rd         sqlite_exec() function 2nd 3rd 4th

     executing with Perl DBI 2nd 3rd 4th

     executing with PySQLite 2nd 3rd 4th 5th 6th 7th

     executing with SQLite Database Browser

     executing with Tcl interface 2nd     executing without callback functions 2nd 3rd 4th 5th 6th

     EXPLAIN 2nd 3rd 4th 5th

     FOREIGN KEY     GRANT

     INSERT 2nd 3rd

         VALUES keyword 2nd     INSERT INTO 2nd    INSERT INTO statement         sample database 2nd 3rd 4th 5th

     interrupting

     INTERSECT

     naming conventions 2nd

     normal keywords 2nd

     NOT NULL

     ON-CONFLICT 2nd

     OR 2nd

     PRAGMA 2nd

     PRIMARY KEY

     reserved keywords

     REVOKE

     RIGHT OUTER JOIN

     ROLLBACK TRANSACTION 2nd 3rd     SELECT 2nd         aggregate functions 2nd 3rd 4th 5th

         AND operator

         arithmetic operators 2nd 3rd         BETWEEN operator

         callback functions 2nd 3rd

         column aliases 2nd

         FROM clause 2nd

         GROUP BY clause 2nd 3rd 4th

         HAVING clause 2nd

         IN operator         IS NOT NULL operator

         IS NULL operator         joins 2nd 3rd 4th 5th

         LEFT JOIN operator 2nd 3rd

         LIKE operator 2nd         LIMIT clause 2nd         NOT LIKE operator         NULL values 2nd

         OR operator         ORDER BY clause 2nd 3rd         output, assigning to variables

         processing results of 2nd

         string comparisons 2nd 3rd

         string operators 2nd

         syntax 2nd 3rd 4th         WHERE clause 2nd 3rd 4th 5th 6th

     SQL92 unsupported statements 2nd

     step-by-step execution     system object names

     UNION

     UNION ALL     UNIQUE     UPDATE 2nd 3rd 4th 5th 6th     VACUUM 2nd

     validating with Tcl interface 2nd 3rd

SQL92 unsupported features 2nd

SQLite

     downloading 2nd

    installation

         binary installation for Linux 2nd

         binary installation for Windows 2nd

         installing from source code 2nd

         RPM installation for Linux 2nd

    version, finding

         sqlite_version command

SQLite Database Browser 2nd 3rd 4th

sqlite dbcmd command SQLite mailing list sqlite tool 2nd 3rd 4th 5th 6th 7th 8th 9th 10th

     closing

     commands         .databases 2nd

         .dump 2nd 3rd 4th

         .echo on|off

         .exit

         .explain on|off

         .header 2nd

         .headers         .help 2nd

         .indices         .mode

         .mode columns

         .mode html         .mode insert         .mode lines         .mode list

         .nullvalue         .output         .prompt

         .quit

         .read 2nd 3rd 4th

         .schema 2nd

         .separator 2nd         .show 2nd

         .tables

         .timeout         .width 2nd

         obtaining list of

    database schemas         returning information about 2nd    database timeouts         setting

    output

         sending to files

     output format, changing 2nd 3rd 4th 5th

    prompts

         changing

    SQL commands

         reading from files 2nd 3rd

     sqlite_master table 2nd 3rd

SQLite version 3.0 2nd

     concurrency 2nd

     data typing 2nd 3rd

     file format changes 2nd

     naming conventions 2nd     user-defined collating sequences 2nd SQLite, overview of 2nd

     customization 2nd

     help and support 2nd     limitations 2nd

     portability 2nd

     scalability 2nd

     security 2nd

     speed 2nd

     when to avoid 2nd

         high concurrency 2nd         high-volume websites 2nd

         network or client/server applications 2nd    when to use

         ad-hoc file storage

         database-driven websites         embedded devices         internal data manipulation sqlite-2.8.15-1.i386.rpm package

sqlite-2.8.15.bin.gz package sqlite-2.8.15.so.gz package sqlite-2.8.15.tar.gz package

sqlite-2_8_15.zip file

sqlite-devel package

sqlite-devel-2.8.15-1.i386.rpm package

sqlite.assoc_case directive (php.ini) sqlite.so.gz library

sqlite3_open() function

SQLITE_ABORT constant SQLITE_ABORT error code

sqlite_aggregate_context() function

sqlite_array_query() function 2nd 3rd 4th SQLITE_ASSOC constant SQLITE_AUTH constant SQLITE_AUTH error code

SQLITE_BOTH constant

SQLITE_BUSY constant

SQLITE_BUSY error code

SQLITE_BUSY Status 2nd

sqlite_busy_handler() function 2nd 3rd

sqlite_busy_handler[) function

sqlite_busy_timeout() function

sqlite_busy_timeout[) function

SQLITE_CANTOPEN constant

SQLITE_CANTOPEN error code

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

sqlite_changes[) function

sqlite_close() function 2nd 3rd 4th 5th 6th sqlite_column() function 2nd sqlite_compile() function 2nd 3rd 4th 5th

sqlite_complete() function 2nd

sqlite_complete[) function SQLITE_CONSTRAINT constant

SQLITE_CONSTRAINT error code

SQLITE_CORRUPT constant

SQLITE_CORRUPT error code

sqlite_create_aggregate() function 2nd 3rd 4th 5th 6th

sqlite_create_aggregate[) function

sqlite_create_function() function 2nd 3rd 4th 5th 6th 7th 8th 9th sqlite_create_function[) function

sqlite_current() function 2nd sqlite_decode_binary() function

SQLITE_DONE constant

SQLITE_DONE return code SQLITE_EMPTY constant SQLITE_EMPTY error code sqlite_encode_binary() function

sqlite_encoding[) function 2nd SQLITE_ERROR constant SQLITE_ERROR error code

sqlite_error_string() function 2nd 3rd

sqlite_escape_string () function 2nd 3rd

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

sqlite_exec_printf() function sqlite_fetch_array() function 2nd 3rd

sqlite_fetch_single() function 2nd 3rd

sqlite_field_name() function 2nd sqlite_finalize() function 2nd 3rd 4th

sqlite_freemem() function

sqlite_freemem[) function SQLITE_FULL constant SQLITE_FULL error code sqlite_get_table() function 2nd 3rd

sqlite_get_table[) function

sqlite_get_table_mprintf[) function

sqlite_has_more() function 2nd

SQLITE_INERRUPT error code

SQLITE_INTERNAL constant

SQLITE_INTERNAL error code

SQLITE_INTERRUPT constant

sqlite_interrupt[) function

SQLITE_IOERR constant

SQLITE_IOERR error code

sqlite_last_error() function 2nd 3rd

sqlite_last_insert_rowid() function 2nd 3rd

sqlite_last_insert_rowid[) function sqlite_libencoding() function 2nd sqlite_libversion() function 2nd

SQLITE_LOCKED constant

SQLITE_LOCKED error code sqlite_master table 2nd 3rd

SQLITE_MISMATCH constant

SQLITE_MISMATCH error code

SQLITE_MISUSE constant

SQLITE_MISUSE error code

sqlite_mprintf() function

sqlite_mprintf[) function sqlite_next() function 2nd 3rd

SQLITE_NOLFS constant SQLITE_NOLFS error code

SQLITE_NOMEM constant

SQLITE_NOMEM error code SQLITE_NOTFOUND constant SQLITE_NOTFOUND error code SQLITE_NUM constant

sqlite_num_fields() function 2nd sqlite_num_rows() function 2nd SQLITE_OK constant

SQLITE_OK error code

sqlite_open() function 2nd 3rd 4th 5th 6th 7th 8th 9th

SQLITE_PERM constant

SQLITE_PERM error code sqlite_popen() function 2nd 3rd 4th

sqlite_progress_handler[) function

SQLITE_PROTOCOL constant SQLITE_PROTOCOL error code

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

SQLITE_READONLY constant SQLITE_READONLY error code sqlite_rewind() function 2nd SQLITE_ROW constant

SQLITE_ROW return code

SQLITE_SCHEMA constant

SQLITE_SCHEMA error code

sqlite_seek() function 2nd 3rd

sqlite_set_result_double() function

sqlite_set_result_double[) function

sqlite_set_result_error[) function

sqlite_set_result_int[) function

sqlite_set_result_string[) function

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

SQLITE_TOOBIG constant

SQLITE_TOOBIG error code

sqlite_udf_decode_binary() function 2nd sqlite_udf_encode_binary() function 2nd sqlite_unbuffered_query() function 2nd

sqlite_user_data[) function

sqlite_version command sqlite_version[) function 2nd

sqliteAtoF() function

sqlitedll-2_8_15.zip file

sqlitedll.zip library

squite command

StandardError class

statements (SQL)     ALTER TABLE

     ANSI-92 unsupported features 2nd     ATTACH DATABASE 2nd 3rd 4th 5th

     BEGIN TRANSACTION 2nd 3rd

     case sensitivity     CHECK 2nd     checking     COLLATE

     comments     COMMIT TRANSACTION 2nd 3rd     COPY 2nd 3rd

     CREATE INDEX 2nd 3rd

     CREATE TABLE 2nd 3rd

         CHECK clause

         conflict resolution         CONSTRAINT clause 2nd

         executing 2nd

         executing with C/C++ 2nd         ON CONFLICT clause 2nd

         sample database 2nd 3rd 4th 5th

     CREATE TEMPORARY TABLE 2nd     CREATE TRIGGER 2nd 3rd 4th     CREATE UNIQUE INDEX 2nd 3rd 4th     CREATE VIEW 2nd

     DEFAULT

     DELETE 2nd 3rd 4th

     DETACH DATABASE 2nd

     DISTINCT

     DROP INDEX

     DROP TABLE 2nd 3rd

     DROP TRIGGER 2nd

     DROP VIEW 2nd

     EXCEPT

     executing from files 2nd

     executing with callback functions 2nd 3rd

         sqlite_exec() function 2nd 3rd 4th

     executing with Perl DBI 2nd 3rd 4th     executing with PySQLite 2nd 3rd 4th 5th 6th 7th     executing with SQLite Database Browser

     executing with Tcl interface 2nd

     executing without callback functions 2nd 3rd 4th 5th 6th     EXPLAIN 2nd 3rd 4th 5th

     FOREIGN KEY

     GRANT

     INSERT 2nd 3rd

         VALUES keyword 2nd

     INSERT INTO 2nd

         sample database 2nd 3rd 4th 5th     interrupting

     INTERSECT     naming conventions 2nd

     normal keywords 2nd

     NOT NULL     ON-CONFLICT 2nd     OR 2nd     PRAGMA 2nd

     PRIMARY KEY     reserved keywords     REVOKE

     RIGHT OUTER JOIN

     ROLLBACK TRANSACTION 2nd 3rd

     SELECT 2nd

         aggregate functions 2nd 3rd 4th 5th         AND operator

         arithmetic operators 2nd 3rd

         BETWEEN operator         callback functions 2nd 3rd

         column aliases 2nd

         FROM clause 2nd         GROUP BY clause 2nd 3rd 4th         HAVING clause 2nd         IN operator

         IS NOT NULL operator

         IS NULL operator

         joins 2nd 3rd 4th 5th

         LEFT JOIN operator 2nd 3rd

         LIKE operator 2nd

         LIMIT clause 2nd

         NOT LIKE operator

         NULL values 2nd

         OR operator

         ORDER BY clause 2nd 3rd

         output, assigning to variables

         processing results of 2nd

         string comparisons 2nd 3rd         string operators 2nd         syntax 2nd 3rd 4th

         WHERE clause 2nd 3rd 4th 5th 6th

     SQL92 unsupported statements 2nd     step-by-step executing

     system object names

     UNION

     UNION ALL

     UNIQUE

     UPDATE 2nd 3rd 4th 5th 6th

     VACUUM 2nd     validating with Tcl interface 2nd 3rd

step() function 2nd 3rd 4th strftime() function 2nd

string map command

string operators 2ndstrings     comparing 2nd 3rd     operators 2nd

     special characters, escaping 2nd     time string formats 2nd StrNe opcode

su command

substr() function

sum() function

sumFinalize() function sumStep() function

suPHP

support synchronous directive (PRAGMA command) 2nd

system object names (SQL)