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]

faggregate functions

    creating         cx.create_aggregate() command

FAIL algorithm fetchall_arrayref() function 2nd 3rd

fetchall_hashref() function 2nd

fetchrow_array() function 2nd 3rd 4th fetchrow_arrayref() function 2nd fetchrow_hash() function fetchrow_hashref() function

fields     returning information aboutfiles

     executing SQL statements from 2nd

     file permissions 2nd

     file storage

     loading data from 2nd     locked database files 2nd

     reading SQL commands from 2nd 3rd

     sending output to     SQLite version 3.0 file formats 2nd

finalize() function 2nd 3rd

finish() function 2nd FOREIGN KEY statementformatting     dates/times 2nd

         time string formats 2nd

FROM clause 2nd

full table scans

full_column_names directive (PRAGMA command)

func() function

function method 2nd 3rd

functions 2nd [See also specific function names] [See also names of specific functions]

     aggregate functions 2nd 3rd 4th 5th

    aggregating functions

         creating 2nd 3rd

         creating with Perl DBI 2nd 3rd 4th 5th 6th

    arbtrary data

         referencing     callback functions 2nd 3rd     calling

     creating 2nd 3rd 4th 5th

     registering 2nd     return values, setting 2nd

    UDFs (user-defined functions)

         aggregating functions 2nd 3rd 4th 5th

         binary data 2nd

         calling 2nd

         creating 2nd 3rd 4th

         registering 2nd 3rd    user-defined functions

         creating 2nd 3rd 4th 5th 6th 7th         creating with Perl DBI 2nd 3rd 4th 5th 6th

         registering

         registering with Tcl interface 2nd 3rdfuture of SQLite [See SQLite version 3.0]