|
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 2nd calling 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 statement collating 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 3rd compiling PySQLite complete method 2nd concatenation operator concurrency high concurrency 2nd SQLite version 3.0 2nd configuration 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 2nd connection parameters PySQLite 2nd constants 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() command custom 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 |
|