|
|
 |
| Авторизация |
|
|
|
| Поиск по указателям |
|
|
|
|
|
|
|
 |
|
|
|
| Newman Ch. — SQLite |
|
|
|
| Предметный указатель |
LIKE operator 2nd
LIMIT clause 2nd
limitations of SQLite 2nd
limiting data 2nd
Linux
Linux, binary SQLite installation 2nd
Linux, PHP configuration 2nd
Linux, RPM SQLite installation 2nd
Loading
loading, data from files 2nd
loading, Perl DBI (Database Interface) 2nd
locked database files 2nd 3rd 4th
locked databases
locked databases, handling with Tcl interface 2nd
Locking
locking databases 2nd 3rd 4th 5th
locking, databases
locking, databases, SQLite version 3.0
lower() function
macros
macros, THREADSAFE
mailing lists
make command
make install command
manifest typing
Mapping
mapping, data types
mapping, data types, PySQLite 2nd 3rd 4th 5th
MAX() function
median averages, calculating 2nd 3rd
median() function 2nd 3rd 4th 5th 6th 7th 8th 9th
Memory
memory, management
MIN() function
mode argument (sqlite.connect() command)
modifiers
modifiers, dates/time modifiers 2nd 3rd
Modules
modules, Perl DBI (Database Interface)
multiple columns
multiple columns, indexing 2nd
multithreaded database access 2nd
naming conventions
naming conventions, case sensitivity 2nd
naming conventions, name length
naming conventions, reserved keywords 2nd
naming conventions, SQL 2nd
naming conventions, SQLite version 3.0 2nd
naming conventions, valid characters 2nd
nested subqueries 2nd
Nesting
nesting, transactions
networks 2nd
new() function 2nd 3rd
Next opcode
non-callback API (C) 2nd
normal keywords (SQL) 2nd
NOT LIKE operator
NOT NULL columns 2nd
NOT NULL statement
NotSupportedError class
NULL values 2nd
Objects
objects, BLOBs 2nd
ON CONFLICT clause
ON CONFLICT clause, CREATE TABLE statement 2nd
ON-CONFLICT clause 2nd
onecolumn method
opcodes (VDBE) 2nd 3rd 4th 5th 6th 7th
Opening
opening, databases
opening, databases, connect() function 2nd 3rd 4th 5th 6th 7th
opening, databases, cx = sqlite.connect() command 2nd 3rd 4th 5th
opening, databases, PEAR database class 2nd 3rd
opening, databases, persistent connections
opening, databases, sqlite dbcmd command
opening, databases, sqlite_open() function 2nd 3rd 4th 5th 6th 7th 8th 9th
opening, databases, Tcl interface 2nd
OpenRead opcode
OperationalError class
Operators
operators, AND
operators, arithmetic operators 2nd 3rd
operators, BETWEEN
operators, concatengation
operators, IN
operators, IS NOT NULL
operators, IS NULL
operators, joins 2nd 3rd 4th 5th
operators, LEFT JOIN 2nd 3rd
operators, LIKE 2nd 3rd
operators, OR
operators, relational operators
operators, string operators 2nd
OR clause 2nd
OR operator
ORDER BY clause 2nd 3rd
ordering data 2nd 3rd
OS interfaces
P1 opcode
Packages
packages, coreutils
packages, sqlite-2.8.15-1.i386.rpm
packages, sqlite-2.8.15.bin.gz
packages, sqlite-2.8.15.so.gz
packages, sqlite-2.8.15.tar.gz
packages, sqlite-2_8_15.zip
packages, sqlite-devel
packages, sqlite-devel-2.8.15-1.i386.rpm
packages, sqlitedll-2_8_15.zip
packages, tclsqlite-2.8.15.so.gz
packages, tclsqlite-2_8_15.zip
packages, tclsqlite.so.gz
packages, tclsqlite.zip
pagers
Parameters
parameters, database parameters
parameters, database parameters, changing for current session 2nd 3rd
parameters, database parameters, changing permanently 2nd
parameters, query parameters
parameters, query parameters, editing 2nd 3rd 4th
parsers
parser_trace directive (PRAGMA command)
PEAR class 2nd 3rd
pear tool 2nd
PENDING locking state
performance optimization
performance optimization, EXPLAIN statement 2nd 3rd 4th 5th
performance optimization, indexes 2nd
performance optimization, indexes, benchmarking 2nd 3rd
performance optimization, indexes, benefits of 2nd 3rd 4th
performance optimization, indexes, creating 2nd 3rd 4th
performance optimization, indexes, dropping 2nd
performance optimization, indexes, examples 2nd 3rd 4th 5th 6th 7th
performance optimization, indexes, multiple columns 2nd
performance optimization, indexes, table lists 2nd
performance optimization, indexes, unique indexes 2nd 3rd 4th
performance optimization, indexes, when to create 2nd
performance optimization, indexes, when to use 2nd 3rd
performance optimization, PRAGMA statement 2nd
performance optimization, transactions 2nd
performance optimization, VACUUM statement 2nd
Perl DBI
Perl DBI (Database Interface) 2nd 3rd
Perl DBI, aggregating creating 2nd 3rd 4th 5th 6th
Perl DBI, available drivers 2nd
Perl DBI, bind values 2nd 3rd 4th 5th 6th 7th 8th 9th
Perl DBI, data safety
Perl DBI, databases
Perl DBI, databases, adding tables to 2nd
| Perl DBI, databases, closing 2nd
Perl DBI, databases, deleting records from 2nd 3rd
Perl DBI, databases, fetching records from 2nd 3rd 4th 5th
Perl DBI, databases, opening 2nd 3rd 4th 5th 6th 7th
Perl DBI, databases, updating 2nd 3rd
Perl DBI, error reporting 2nd 3rd 4th
Perl DBI, functions
Perl DBI, functions, available_drivers() 2nd
Perl DBI, functions, begin_work() 2nd
Perl DBI, functions, bind_param() 2nd 3rd
Perl DBI, functions, commit() 2nd
Perl DBI, functions, connect() 2nd 3rd 4th 5th 6th 7th
Perl DBI, functions, create_aggregate() 2nd 3rd 4th 5th
Perl DBI, functions, create_function() 2nd 3rd 4th
Perl DBI, functions, die() 2nd
Perl DBI, functions, disconnect() 2nd
Perl DBI, functions, do()
Perl DBI, functions, err()
Perl DBI, functions, errstr()
Perl DBI, functions, execute() 2nd 3rd 4th 5th 6th 7th
Perl DBI, functions, fetchall_arrayref() 2nd 3rd
Perl DBI, functions, fetchall_hashref() 2nd
Perl DBI, functions, fetchrow_array() 2nd 3rd 4th
Perl DBI, functions, fetchrow_arrayref() 2nd
Perl DBI, functions, fetchrow_hash()
Perl DBI, functions, fetchrow_hashref()
Perl DBI, functions, finalize() 2nd 3rd
Perl DBI, functions, finish() 2nd
Perl DBI, functions, func()
Perl DBI, functions, installed_versions()
Perl DBI, functions, last_insert_rowid()
Perl DBI, functions, new() 2nd 3rd
Perl DBI, functions, prepare() 2nd 3rd 4th
Perl DBI, functions, quote() 2nd 3rd 4th
Perl DBI, functions, rollback() 2nd
Perl DBI, functions, rows()
Perl DBI, functions, step() 2nd 3rd
Perl DBI, functions, trace() 2nd 3rd 4th 5th
Perl DBI, functions, warn() 2nd
Perl DBI, installing 2nd 3rd
Perl DBI, loading 2nd
Perl DBI, modules
Perl DBI, queries
Perl DBI, queries, fetching rows from 2nd 3rd 4th 5th 6th
Perl DBI, queries, returning information about 2nd
Perl DBI, SQL statements, executing 2nd 3rd 4th
Perl DBI, tracing 2nd 3rd 4th
Perl DBI, transactions 2nd 3rd 4th
Perl DBI, user-defined functions, creating 2nd 3rd 4th 5th 6th
Perl DBI, version, finding
PERMISSIONS
permissions, file permissions 2nd
persistent connections
PHP 2nd
PHP interface 2nd
php() function 2nd
PHP, configuring for Linux/Unix 2nd
PHP, configuring for Windows 2nd
PHP, constants 2nd
PHP, databases
PHP, databases, closing 2nd
PHP, databases, confirming changes to 2nd 3rd
PHP, databases, opening 2nd 3rd 4th 5th
PHP, databases, persistent connections
PHP, documentation 2nd
PHP, error reporting 2nd 3rd
PHP, functions
PHP, functions, addslashes()
PHP, functions, date()
PHP, functions, datetime()
PHP, functions, dl()
PHP, functions, extension_loaded()
PHP, functions, getAll()
PHP, functions, getRow()
PHP, functions, isError()
PHP, functions, jullianday()
PHP, functions, last_insert_rowid()
PHP, functions, length()
PHP, functions, lower()
PHP, functions, median() 2nd 3rd 4th
PHP, functions, php() 2nd
PHP, functions, phpinfo()
PHP, functions, query()
PHP, functions, sqlite_array_query() 2nd 3rd 4th
PHP, functions, sqlite_busy_timeout()
PHP, functions, sqlite_changes() 2nd 3rd 4th
PHP, functions, sqlite_close() 2nd
PHP, functions, sqlite_column() 2nd
PHP, functions, sqlite_create_aggregate() 2nd 3rd 4th 5th
PHP, functions, sqlite_create_function() 2nd 3rd 4th 5th 6th
PHP, functions, sqlite_current() 2nd
PHP, functions, sqlite_decode_binary()
PHP, functions, sqlite_encode_binary()
PHP, functions, sqlite_error_string() 2nd 3rd
PHP, functions, sqlite_escape_string() 2nd 3rd
PHP, functions, sqlite_fetch_array() 2nd 3rd
PHP, functions, sqlite_fetch_single() 2nd 3rd
PHP, functions, sqlite_field_name() 2nd
PHP, functions, sqlite_has_more() 2nd
PHP, functions, sqlite_last_error() 2nd 3rd
PHP, functions, sqlite_last_insert_rowid() 2nd
PHP, functions, sqlite_libencoding() 2nd
PHP, functions, sqlite_libversion() 2nd
PHP, functions, sqlite_next() 2nd 3rd
PHP, functions, sqlite_num_fields() 2nd
PHP, functions, sqlite_num_rows() 2nd
PHP, functions, sqlite_open() 2nd 3rd 4th
PHP, functions, sqlite_popen() 2nd 3rd 4th
PHP, functions, sqlite_query() 2nd 3rd 4th 5th
PHP, functions, sqlite_rewind() 2nd
PHP, functions, sqlite_seek() 2nd 3rd
PHP, functions, sqlite_udf_decode_binary() 2nd
PHP, functions, sqlite_udf_encode_binary() 2nd
PHP, functions, sqlite_unbuffered_query() 2nd
PHP, functions, strftime() 2nd
PHP, functions, substr()
PHP, functions, time()
PHP, functions, ucwords()
PHP, functions, upper()
PHP, functions, word_reverse() 2nd
PHP, PEAR database class 2nd 3rd
PHP, queries
PHP, queries, executing 2nd 3rd 4th 5th
PHP, queries, returning information about 2nd 3rd 4th
PHP, result sets
PHP, result sets, accessing random rows 2nd
PHP, result sets, displaying in HTML tables 2nd 3rd 4th 5th
PHP, result sets, processing 2nd 3rd 4th 5th 6th 7th 8th
PHP, result sets, returning in single array 2nd 3rd
PHP, runtime configuration 2nd
PHP, safe mode
PHP, special characters, escaping 2nd
PHP, SQLite extension, returning information about 2nd
PHP, SQLite support, checking for 2nd
PHP, suPHP
php.ini
php.ini, directives
php.ini, directives, sqlite.assoc_case
phpinfo() function
portability of SQLite 2nd
ppm.bat script
PRAGMA command
PRAGMA command, database analysis 2nd 3rd
PRAGMA command, database information, returning 2nd 3rd 4th
PRAGMA command, database parameters
PRAGMA command, database parameters, changing for current session 2nd 3rd
PRAGMA command, database parameters, changing permanently 2nd
PRAGMA command, directives
PRAGMA command, directives, cache_size
PRAGMA command, directives, count_changes 2nd
|
|
|
| Реклама |
|
|
|
|
|
|
|
|
О проекте