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 ...
|
|
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 ...
|
|
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.
|
|
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 ...
|
|
Database File Format
(fileformat.html)
1.3.14. User version number
The 4-byte big-endian integer at offset 60 is the user version which
is set and queried by the user_version pragma. The user version is
not used by SQLite.
|
|
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.
|
Page generated by FTS5 in about 150.83 ms.