Small. Fast. Reliable.
Choose any three.
Choose any three.
|
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 ...
|
|
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 ...
|
|
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 ...
|
|
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".
|
|
Row Values
(rowvalue.html)
2.2. Row Value IN Operators
... CREATE TABLE t2(x,y,z);
INSERT INTO t2(x,y,z) VALUES(1,2,3),(2,3,4),(1,NULL,5);
SELECT
(1,2,3) IN (SELECT * FROM t2), -- 1
(7,8,9) IN (SELECT * FROM t2), -- 0
(1 ...
|
|
C API: Synchronization Type Flags
(c3ref/c_sync_dataonly.html)
SQLITE_SYNC_NORMAL, SQLITE_SYNC_FULL, SQLITE_SYNC_DATAONLY
... If the lower four bits equal SQLITE_SYNC_FULL, that means
to use Mac OS X style fullsync instead of fsync().
Do not confuse the SQLITE_SYNC_NORMAL and SQLITE_SYNC_FULL flags
with the PRAGMA synchronous=NORMAL and PRAGMA synchronous=FULL
settings. The synchronous pragma ...
|
|
EXPLAIN QUERY PLAN
(eqp.html)
1.3. Subqueries
... sqlite> EXPLAIN QUERY PLAN SELECT count(*)
> FROM (SELECT max(b) AS x FROM t1 GROUP BY a) AS qqq
> GROUP BY x;
QUERY PLAN
|--CO-ROUTINE qqq
| `--SCAN t1 USING COVERING INDEX i2
|--SCAN qqqq
`--USE TEMP ...
|
Page generated by FTS5 in about 141.22 ms.