Small. Fast. Reliable.
Choose any three.
Choose any three.
|
File Locking And Concurrency In SQLite Version 3
(lockingv3.html)
... Delete the journal file (or truncate the journal to zero bytes in
length if PRAGMA journal_mode=TRUNCATE is
set, or zero the journal header if
PRAGMA journal_mode=PERSIST is set).
Delete the super-journal file if it is safe to ...
|
|
Powersafe Overwrite
(psow.html)
... For a database with a PRAGMA page_size of 1024
(a very common choice) making a change to a single page in the database
now requires SQLite to backup three other adjacent pages to the rollback
journal, whereas formerly it only ...
|
|
SQLite Changes From Version 3.5.9 To 3.6.0
(35to36.html)
... Added the page_count PRAGMA for returning the size of the underlying
database file in pages.
Added a new R*Tree index extension.
|
|
Architecture of SQLite
(arch.html)
... attach.c,
auth.c,
build.c,
delete.c,
expr.c,
insert.c,
pragma.c,
select.c,
trigger.c,
update.c,
vacuum.c,
where.c,
wherecode.c, and
whereexpr.c.
In these files is where most of the serious magic happens ...
|
|
The SQLite Query Optimizer Overview
(optoverview.html)
7.1. Manual Control Of Join Order
... The best policy is to make use
of PRAGMA optimize to ensure that the query planner has access to
up-to-date statistics on the shape of the data in the database.
This section describes techniques by which developers can ...
|
|
CREATE TRIGGER
(lang_createtrigger.html)
... Note that the sqlite3_changes() and sqlite3_total_changes() interfaces
do not count INSTEAD OF trigger firings, but the
count_changes pragma does count INSTEAD OF trigger firing.
4. Some Example Triggers
Assuming that customer records are stored in the "customers" table, and
that ...
|
|
The SQLite Bytecode Engine
(opcode.html)
3. Viewing The Bytecode
... For example the vdbe_trace
pragma can be enabled to cause a disassembly of each VDBE opcode to be
printed on standard output as the opcode is executed. These debugging
pragmas include:
PRAGMA parser_trace
PRAGMA vdbe_addoptrace
PRAGMA vdbe_debug
PRAGMA vdbe_listing
PRAGMA ...
|
|
Automatic Undo/Redo With SQLite
(undoredo.html)
... eval {CREATE TEMP TABLE undolog(seq integer primary key, sql text)}
foreach tbl $args {
set collist [$db eval "pragma table_info($tbl)"]
set sql "CREATE TEMP TRIGGER _${tbl}_it AFTER INSERT ON $tbl BEGIN\n"
append sql " INSERT ...
|
|
The Tcl interface to the SQLite library
(tclsqlite.html)
3.10. Th3 enable_load_extension method
... For best security, do not use this method unless truly needed,
and run PRAGMA trusted_schema=OFF or the
"db config trusted_schema 0" method before
invoking this method.
This method maps to the sqlite3_enable_load_extension() C/C++
interface.
|
|
Why SQLite Uses Bytecode
(whybytecode.html)
2.2. Bytecode Is Easier To Debug
... In debugging builds of SQLite, the PRAGMA vdbe_trace=ON; command will
cause a trace of the bytecode execution to appear on the console.
|
Page generated by FTS5 in about 128.24 ms.