|
|
 |
| Авторизация |
|
|
|
| Поиск по указателям |
|
|
|
|
|
|
|
 |
|
|
|
| Newman Ch. — SQLite |
|
|
|
| Предметный указатель |
' (apostrophe)
(backslash)
(quotes)
.databases command (sqlite) 2nd
.dump command (sqlite) 2nd 3rd 4th
.echo on|off command (sqlite)
.exit command (sqlite)
.explain on|off command (sqlite)
.header command (sqlite) 2nd
.headers command (sqlite)
.help command (sqlite) 2nd
.indices command (sqlite)
.mode columns command (sqlite)
.mode command (sqlite)
.mode html command (sqlite)
.mode insert command (sqlite)
.mode lines command (sqlite)
.mode list command (sqlite)
.NET
.nullvalue command (sqlite)
.output command (sqlite)
.prompt command (sqlite)
.quit command (sqlite)
.read command (sqlite) 2nd 3rd 4th
.schema command (sqlite) 2nd
.separator command (sqlite) 2nd
.show command (sqlite) 2nd
.tables command (sqlite)
.timeout command (sqlite)
.width command (sqlite) 2nd
ABORT algorithm
ad-hoc file storage
Add opcode
addslashes() function
Administration
administration, backing up databases 2nd
administration, backing up databases, .dump command 2nd 3rd
administration, database analysis 2nd 3rd
administration, database information, returning 2nd 3rd 4th
administration, database parameters
administration, database parameters, changing for current session 2nd 3rd
administration, database parameters, changing permanently 2nd
administration, query parameters
administration, query parameters, editing 2nd 3rd 4th
Aggregate functions 2nd 3rd 4th 5th
aggregate functions, creating
aggregate functions, creating, cx.create_aggregate() command 2nd 3rd 4th 5th
aggregating functions
aggregating functions, creating 2nd 3rd 4th 5th 6th 7th 8th
aggregating functions, creating with Perl DBI 2nd 3rd 4th 5th 6th
algorithms (conflict resolution)
algorithms (conflict resolution), ABORT
algorithms (conflict resolution), FAIL
algorithms (conflict resolution), IGNORE
algorithms (conflict resolution), REPLACE 2nd
algorithms (conflict resolution), ROLLBACK
Aliases
aliases, column aliases 2nd
altcaps() function
ALTER TABLE statement
altering tables 2nd
analyzing
analyzing, databases 2nd 3rd
and operator
ANSI SQL92 unsupported features 2nd
apostrophe (')
arbtrary data
arbtrary data, referencing
Architecture
architecture, VDBE (Virtual Database Engine)
architecture, VDBE (Virtual Database Engine), B-tree
architecture, VDBE (Virtual Database Engine), back end
architecture, VDBE (Virtual Database Engine), code generators
architecture, VDBE (Virtual Database Engine), interface
architecture, VDBE (Virtual Database Engine), OS interfaces
architecture, VDBE (Virtual Database Engine), pagers
architecture, VDBE (Virtual Database Engine), parsers
architecture, VDBE (Virtual Database Engine), red/black tree
architecture, VDBE (Virtual Database Engine), tokenizers
architecture, VDBE (Virtual Database Engine), virtual machines
arithmetic operators 2nd 3rd
Arrays
arrays, returning
arrays, returning result sets as 2nd 3rd
ATTACH DATABASE statement 2nd 3rd 4th 5th
attaching to databases 2nd 3rd 4th 5th 6th 7th 8th
autocommit argument (sqlite.connect() command)
available_drivers() function 2nd
AVG() function
avgFinalize() function
avverages
avverages, calculating 2nd 3rd
B-tree
back end (VDBE)
background jobs
backing up databases 2nd
backing up databases, .dump command 2nd 3rd
backslash
BEGIN TRANSACTION statement 2nd 3rd
beginning
beginning, transactions
beginning, transactions, begin_work() function 2nd
begin_work() function 2nd
benchmark.sh script 2nd
Benchmarking 2nd 3rd
BETWEEN operator
Binary data 2nd
binary data, encoding/decoding 2nd 3rd
binary data, UDFs (user-defined functions) 2nd
binary installation for Linux 2nd
binary installation for Windows 2nd
bind values
bind values, Perl DBI 2nd 3rd 4th 5th 6th 7th 8th 9th
bind_param() function 2nd 3rd
BLOB data type
blobs 2nd
browsing records
busy method
C/C++ 2nd 3rd
C/C++ interface
C/C++, core API 2nd 3rd
C/C++, databases
C/C++, databases, closing 2nd 3rd 4th 5th 6th 7th
C/C++, databases, finding information about database changes
C/C++, databases, inserting data into 2nd 3rd 4th
C/C++, databases, locked files 2nd
C/C++, databases, opening 2nd 3rd 4th 5th 6th 7th
C/C++, databases, updating 2nd
C/C++, error codes 2nd 3rd 4th
C/C++, functions
C/C++, functions, aggregating functions 2nd 3rd
C/C++, functions, avgFinalize()
C/C++, functions, callback() 2nd
C/C++, functions, creating 2nd 3rd 4th 5th
C/C++, functions, sqliteAtoF()
C/C++, functions, sqlite_aggregate_context()
C/C++, functions, sqlite_busy_handler()
C/C++, functions, sqlite_busy_handler[)
C/C++, functions, sqlite_busy_timeout[)
C/C++, functions, sqlite_changes() 2nd
C/C++, functions, sqlite_changes[)
C/C++, functions, sqlite_close() 2nd 3rd 4th
C/C++, functions, sqlite_compile() 2nd 3rd
C/C++, functions, sqlite_compile() function 2nd
C/C++, functions, sqlite_complete() 2nd
C/C++, functions, sqlite_complete[)
C/C++, functions, sqlite_create_aggregate()
C/C++, functions, sqlite_create_aggregate[)
C/C++, functions, sqlite_create_function() 2nd 3rd
C/C++, functions, sqlite_create_function[)
| C/C++, functions, sqlite_encoding[) 2nd
C/C++, functions, sqlite_exec() 2nd 3rd 4th 5th 6th 7th
C/C++, functions, sqlite_exec_printf()
C/C++, functions, sqlite_finalize() 2nd 3rd 4th
C/C++, functions, sqlite_freemem()
C/C++, functions, sqlite_freemem[)
C/C++, functions, sqlite_get_table() 2nd 3rd
C/C++, functions, sqlite_get_table[)
C/C++, functions, sqlite_get_table_mprintf[)
C/C++, functions, sqlite_interrupt[)
C/C++, functions, sqlite_last_insert_rowid()
C/C++, functions, sqlite_last_insert_rowid[)
C/C++, functions, sqlite_mprintf()
C/C++, functions, sqlite_mprintf[)
C/C++, functions, sqlite_open() 2nd 3rd 4th
C/C++, functions, sqlite_progress_handler[)
C/C++, functions, sqlite_set_result_double()
C/C++, functions, sqlite_set_result_double[)
C/C++, functions, sqlite_set_result_error[)
C/C++, functions, sqlite_set_result_int[)
C/C++, functions, sqlite_set_result_string[)
C/C++, functions, sqlite_step() 2nd 3rd 4th 5th
C/C++, functions, sqlite_step() function
C/C++, functions, sqlite_user_data[)
C/C++, functions, sqlite_version[) 2nd
C/C++, functions, sumFinalize()
C/C++, functions, sumStep()
C/C++, jobs
C/C++, jobs, performing in background
C/C++, memory management
C/C++, non-callaback AP 2nd
C/C++, preparing to use 2nd
C/C++, queries
C/C++, queries, executing 2nd
C/C++, result sets
C/C++, result sets, returning 2nd 3rd
C/C++, return codes 2nd
C/C++, SQL statements
C/C++, SQL statements, checking
C/C++, SQL statements, executing with callback functions 2nd 3rd 4th 5th 6th 7th
C/C++, SQL statements, executing without callback functions 2nd 3rd 4th 5th 6th
C/C++, SQL statements, interrupting
C/C++, SQL statements, step-by-step execution
C/C++, SQLite library
C/C++, SQLite library, finding version of 2nd 3rd
C/C++, SQLite virtual machines, creating 2nd
C/C++losing
C/C++losing, databases
C/C++losing, databases, sqlite_close() function
C/C++ore C API 2nd
cache_size directive (PRAGMA command)
calcualting
calcualting, median averages 2nd 3rd
callback functions 2nd 3rd
Callback opcode
callback() function 2nd
calling
calling, functions
calling, UDFs (user-defined functions) 2nd
Cartesian joins 2nd
case sensitivity 2nd
changes method 2nd
CHECK clause
CHECK clause, CREATE TABLE statement
CHECK statement
Classes
classes, DatabaseError 2nd
classes, DataError
classes, Error 2nd
classes, IntegrityError
classes, InterfaceError
classes, InternalError
classes, NotSupportedError
classes, OperationalError
classes, PEAR 2nd 3rd
classes, ProgrammingError
classes, StandardError
clauses
clauses, CHECK
clauses, CHECK, CREATE TABLE statement
clauses, CONSTRAINT
clauses, CONSTRAINT, CREATE TABLE statement 2nd
clauses, GROUP BY 2nd 3rd 4th
clauses, HAVING 2nd
clauses, LIMIT 2nd
clauses, ON CONFLICT
clauses, ON CONFLICT, CREATE TABLE statement 2nd
clauses, ORDER BY 2nd 3rd
clauses, USING DELIMITERS
clauses, WHEN
clauses, WHEN, CREATE TRIGGER statement
clauses, WHERE
clauses, WHERE, DELETE statement
clauses, WHERE, UPDATE statement
client/server applications 2nd
close method
Closing
closing, databases
closing, databases, cx.close() command 2nd
closing, databases, dbcmd close command
closing, databases, disconnect() function 2nd
closing, databases, sqlite_close() function 2nd 3rd 4th
closing, databases, Tcl interface 2nd
closing, sqlite
code generators
code listings
code listings, benchmark.sh script 2nd
code listings, changes method
code listings, CREATE TABLE statement
code listings, CREATE TABLE statement, executing with C/C++ 2nd
code listings, database timeouts
code listings, database timeouts, handling with Tcl interface
code listings, databases
code listings, databases, adding data to 2nd
code listings, databases, connecting with C/C++
code listings, databases, opening
code listings, databases, updating 2nd
code listings, functions
code listings, functions, creating 2nd
code listings, index examples
code listings, index examples, joint1t2.sql
code listings, index examples, joint2t1.sql
code listings, index examples, t1word.sql
code listings, index examples, tl.sql
code listings, Perl DBI
code listings, Perl DBI, aggregating functions, creating 2nd
code listings, Perl DBI, available_drivers() function 2nd
code listings, Perl DBI, bind values 2nd 3rd
code listings, Perl DBI, database updates
code listings, Perl DBI, databases, adding records to 2nd
code listings, Perl DBI, databases, adding tables to
code listings, Perl DBI, fetchrow_array() function
code listings, Perl DBI, fetchrow_arrayref () function
code listings, Perl DBI, quote() function
code listings, Perl DBI, tracing
code listings, Perl DBI, user-defined functions, creating 2nd
code listings, PRAGMA show_datatypes command
code listings, PySQLite
code listings, PySQLite, .execute() command
code listings, PySQLite, aggregate functions
code listings, PySQLite, database records, fetching 2nd
code listings, PySQLite, database records, inserting
code listings, PySQLite, database updates, checking
code listings, PySQLite, error handling
code listings, PySQLite, SQL statements, executing 2nd
code listings, PySQLite, user-defined functions, creating 2nd
code listings, PySQLite, user-defined functions, registering
code listings, queries
code listings, queries, executing without callback functions 2nd
code listings, records
|
|
|
| Реклама |
|
|
|
|
|
О проекте