|
SQLite Archive Files
(sqlar.html)
5. Managing SQLite Archives From Application Code
... sqlar_compress(X)
The sqlar_compress(X) function attempts to compress a copy of the
blob X using the Default algorithm and returns the
result as a blob. If the input X is not a compressible blob, then
a copy of X ...
|
|
SQLite In 5 Minutes Or Less
(quickstart.html)
... 01 #!/usr/bin/tclsh
02 if {$argc!=2} {
03 puts stderr "Usage: %s DATABASE SQL-STATEMENT"
04 exit 1
05 }
06 package require sqlite3
07 sqlite3 db [lindex $argv 0]
08 db eval [lindex $argv 1] x {
09 ...
|
|
The Spellfix1 Virtual Table
(spellfix1.html)
7. Auxiliary Functions
... spellfix1_phonehash(X)
This routine constructs a phonetic hash of the pure ascii input word X
and returns that hash. This routine is used internally by spellfix1 in
order to transform the K1 column of the shadow table into the K2 ...
|
|
Well-Known Users Of SQLite
(famous.html)
... Apple uses SQLite in many (most?) of the
native applications running on Mac OS-X desktops and servers and
on iOS devices such as iPhones and iPods. SQLite is also used in
iTunes, even on non-Apple hardware.
Bentley Systems ...
|
|
C API: Register A Callback To Handle SQLITE_BUSY Errors
(c3ref/busy_handler.html)
sqlite3_busy_handler()
The sqlite3_busy_handler(D,X,P) routine sets a callback function X
that might be invoked with argument P whenever
an attempt is made to access a database table associated with
database connection D when another thread
or process has the ...
|
|
Stale Expression Indexes
(staleexpridx.html)
1. Overview
... Deterministic
functions are things like "abs(X)" and "concat(X,Y)". Non-deterministic
functions are things like "datetime('now')" and "random()".
Sometimes functions that are identified as "deterministic" are not
completely deterministic across different CPU architectures, operating
systems, configuration options ...
|
|
The RBU Extension
(rbu.html)
2.3. RBU Update C/C++ Programming
... Register any required virtual table modules with the database
handle returned by sqlite3rbu_db(X) (where argument X is the sqlite3rbu
pointer returned from sqlite3rbu_open()). Also, if required, register
the rbu_delta() SQL function using
sqlite3_create_function_v2().
Invoke the sqlite3rbu_step(X) function one ...
|
|
Transaction
(lang_transaction.html)
... If database
connection X is holding a read transaction, it is possible that some
other database connection Y might change the content of the database
while X's transaction is still open, however X will not be able to see ...
|
|
WAL-mode File Format
(walformat.html)
1. Files On Disk
... The main database file with an arbitrary name "X".
The write-ahead log file, usually named "X-wal".
The wal-index file, usually named "X-shm".
|
|
SQLite's Built-in printf()
(printf.html)
2.1. Substitution Types
... x, X
The argument is an integer which is displayed in hexadecimal.
Lower-case hexadecimal is used for %x and upper-case is used
for %X
o
The argument is an integer which is displayed in octal.
s, z
The ...
|
Page generated by FTS5 in about 82.89 ms.