|
|
 |
| Авторизация |
|
|
|
| Поиск по указателям |
|
|
|
|
|
|
|
 |
|
|
|
| Newman Ch. — SQLite |
|
|
|
| Предметный указатель |
databases, triggers, interrupting 2nd
databases, triggers, limitations
databases, triggers, triggers on views 2nd
databases, updating 2nd
databases, updating, C/C++ interface 2nd
databases, updating, Perl DBI 2nd 3rd
databases, VDBE (Virtual Database Engine)
databases, VDBE (Virtual Database Engine), B-tree
databases, VDBE (Virtual Database Engine), back end
databases, VDBE (Virtual Database Engine), code generators
databases, VDBE (Virtual Database Engine), interface
databases, VDBE (Virtual Database Engine), opcodes 2nd 3rd 4th 5th 6th 7th
databases, VDBE (Virtual Database Engine), OS interfaces
databases, VDBE (Virtual Database Engine), pagers
databases, VDBE (Virtual Database Engine), parsers
databases, VDBE (Virtual Database Engine), red/black tree
databases, VDBE (Virtual Database Engine), tokenizer
databases, VDBE (Virtual Database Engine), virtual machines
databases, views
databases, views, creating 2nd 3rd
databases, views, dropping 2nd
databases, views, example 2nd 3rd
database_list directive (PRAGMA command)
DataError class
Datasets [See result sets]
date() function
Dates 2nd
dates/times 2nd
dates/times, date() function
dates/times, date/time conversion specifiers
dates/times, datetime() function
dates/times, displaying 2nd
dates/times, jullianday() function
dates/times, modifiers 2nd 3rd
dates/times, strftime() function 2nd
dates/times, time string formats 2nd
dates/times, time zones 2nd
dates/times, time() function
datetime() function
dbcmd busy callback command
dbcmd changes command 2nd
dbcmd close command
dbcmd complete command
dbcmd errorcode command
dbcmd eval query command 2nd 3rd 4th
dbcmd function command
dbcmd onecolumn command
dbcmd timeout command
Decoding
decoding, binary data 2nd 3rd
DEFAULT columns
default directive (PRAGMA command) 2nd
DEFAULT statement
Defining
defining, table columns 2nd
DELETE statement 2nd 3rd 4th
deleting
deleting, records 2nd 3rd 4th
deleting, records, Perl DBI 2nd 3rd
DETACH DATABASE statement 2nd
detaching databases
detaching from databases
die() function 2nd
directives
directives (PRAGMA command)
directives (PRAGMA command), cache_size
directives (PRAGMA command), count_changes 2nd
directives (PRAGMA command), database_list
directives (PRAGMA command), default 2nd
directives (PRAGMA command), full_column_names
directives (PRAGMA command), index_info 2nd
directives (PRAGMA command), index_list 2nd
directives (PRAGMA command), integrity_check
directives (PRAGMA command), parser_trace
directives (PRAGMA command), show_datatypes
directives (PRAGMA command), synchronous 2nd
directives (PRAGMA command), table_info
directives (PRAGMA command), temp_store
directives (PRAGMA command), vdbe_trace 2nd
directives, sqlite.assoc_case directive
disconnect() function 2nd
displaying
displaying, dates/times 2nd
displaying, result sets in HTML tables 2nd 3rd 4th 5th
DISTINCT statement
dl() function
do() function
Documentation
documentation, PEAR class
documentation, PHP 2nd
downloading
downloading, PySQLite
downloading, SQLite 2nd
downloading, Tcl interface
drivers
drivers, Perl DBI 2nd
DROP INDEX statement
DROP TABLE statement
DROP TRIGGER statement 2nd
DROP VIEW statement 2nd
dropping
dropping, indexes 2nd
dropping, tables 2nd
dropping, triggers 2nd 3rd
dropping, views 2nd
DSN (Data Source Name)
editing
editing, database parameters
editing, database parameters, for current session 2nd 3rd
editing, database parameters, permanently 2nd
editing, query parameters 2nd 3rd 4th
embedded devices
Encoding
encoding argument (sqlite.connect() command)
encoding, binary data 2nd 3rd
err() function
Error class 2nd
Error handling
error handling, PySQLite 2nd 3rd 4th 5th 6th
error reporting
error reporting, dbcmd errorcode command
error reporting, Perl DBI 2nd 3rd 4th
Errors
errors, C error codes 2nd 3rd 4th
errors, PHP error reporting 2nd 3rd
errstr() function
escaping special characters 2nd
eval method 2nd 3rd
Events
events, triggers
events, triggers, creating 2nd
events, triggers, dropping
EXCEPT statement
Exceptions
exceptions, PrintError
exceptions, RaiseError 2nd 3rd
EXCLUSIVE locking state
execute() function 2nd 3rd 4th 5th 6th 7th
executing
executing, queries
executing, queries with callback functions 2nd 3rd
executing, queries with callback functions, sqlite_exec() function 2nd 3rd 4th
executing, queries without callback functions 2nd 3rd 4th 5th 6th
executing, queries, dbcmd eval query command 2nd
executing, queries, sqlite_escape_string() function 2nd 3rd
executing, queries, sqlite_exec() function 2nd
executing, queries, sqlite_query() function 2nd 3rd
executing, queries, sqlite_unbuffered_query() function
executing, SQL statements
executing, SQL statements from files 2nd
| executing, SQL statements with Perl DBI 2nd 3rd 4th
executing, SQL statements with PySQLite 2nd 3rd 4th 5th 6th 7th
executing, SQL statements with SQLite Database Browser
executing, SQL statements with Tcl interface 2nd
executing, SQL statements, step-by-step execution
EXPLAIN command
EXPLAIN statement 2nd 3rd 4th 5th
extension_loaded() function
faggregate functions
faggregate functions, creating
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
fields, returning information about
Files
files, executing SQL statements from 2nd
files, file permissions 2nd
files, file storage
files, loading data from 2nd
files, locked database files 2nd
files, reading SQL commands from 2nd 3rd
files, sending output to
files, SQLite version 3.0 file formats 2nd
finalize() function 2nd 3rd
finish() function 2nd
FOREIGN KEY statement
Formatting
formatting, dates/times 2nd
formatting, dates/times, 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]
functions, aggregate functions 2nd 3rd 4th 5th
functions, aggregating functions
functions, aggregating functions, creating 2nd 3rd
functions, aggregating functions, creating with Perl DBI 2nd 3rd 4th 5th 6th
functions, arbtrary data
functions, arbtrary data, referencing
functions, callback functions 2nd 3rd
functions, calling
functions, creating 2nd 3rd 4th 5th
functions, registering 2nd
functions, return values, setting 2nd
functions, UDFs (user-defined functions)
functions, UDFs, aggregating functions 2nd 3rd 4th 5th
functions, UDFs, binary data 2nd
functions, UDFs, calling 2nd
functions, UDFs, creating 2nd 3rd 4th
functions, UDFs, registering 2nd 3rd
functions, user-defined functions
functions, user-defined functions, creating 2nd 3rd 4th 5th 6th 7th
functions, user-defined functions, creating with Perl DBI 2nd 3rd 4th 5th 6th
functions, user-defined functions, registering
functions, user-defined functions, registering with Tcl interface 2nd 3rd
future of SQLite [See SQLite version 3.0]
getAll() function
getRow() function
GMT (Greenwich Mean Time)
GRANT statement
GROUP BY clause 2nd 3rd 4th
Halt opcode
HAVING clause 2nd
help 2nd
high concurrency 2nd
high-volume websites 2nd
Hipp, D. Richard
Hipp, Wyrick & Company, Inc
HTML tables
HTML tables, displaying query results in 2nd 3rd 4th 5th
Identifiers [See naming conventions]
IGNORE algorithm
IN operator
index info directive (PRAGMA command) 2nd
index list_directive (PRAGMA command) 2nd
Indexes 2nd
indexes, benchmarking 2nd 3rd
indexes, benefits of 2nd 3rd 4th
indexes, creating 2nd 3rd 4th
indexes, dropping 2nd
indexes, examples 2nd 3rd 4th 5th 6th
indexes, multiple columns 2nd
indexes, sort order
indexes, table lists 2nd
indexes, unique indexes 2nd 3rd 4th
indexes, when to create 2nd
indexes, when to use 2nd 3rd
INSERT INTO statement 2nd
INSERT INTO statement, sample database 2nd 3rd 4th 5th
INSERT statement 2nd 3rd
INSERT statement, VALUES keyword 2nd
Installation
installation, Perl DBI (Database Interface) 2nd 3rd
installation, PySQLite 2nd
installation, SQLite
installation, SQLite, binary installation for Linux 2nd
installation, SQLite, binary installation for Windows 2nd
installation, SQLite, installing from source code 2nd
installation, SQLite, RPM installation for Linux 2nd
installed_versions() function
Integer data type
Integer opcode
INTEGER PRIMARY KEY columns 2nd
IntegrityError class
integrity_check directive (PRAGMA command)
InterfaceError class
internal data manipulation
InternalError class
interrupting
interrupting, SQL statements
interrupting, triggers 2nd
INTERSECT statement
IS NOT NULL operator
IS NULL operator
isError() function
Java
jobs
jobs, background jobs
Joins 2nd 3rd 4th 5th
joins, Cartesian joins 2nd
joins, left joins 2nd 3rd
jullianday() function
keywords [See specific keywords] [See statements]
last_insert_rowid command
last_insert_rowid() function 2nd
LEFT JOIN operator 2nd 3rd
left joins 2nd 3rd
length of names
length() function
Libraries
libraries, finding version of 2nd
libraries, libsqlite.so
libraries, libsqlite3.so
libraries, sqlite.so.gz
libraries, sqlitedll.zip
libraries, tclsqlite.so.gz
libraries, tclsqlite.zip
Library
library, finding version of 2nd
libsqlite.so library
libsqlite3.so library
libtclsqlite.so 2nd
|
|
|
| Реклама |
|
|
|
|
|
О проекте