Small. Fast. Reliable.
Choose any three.
Choose any three.
|
C API: The pre-update hook.
(c3ref/preupdate_blobwrite.html)
sqlite3_preupdate_hook(), sqlite3_preupdate_old(), sqlite3_preupdate_count(), sqlite3_preupdate_depth(), sqlite3_preupdate_new(), sqlite3_preupdate_blobwrite()
... For an INSERT operation on a rowid table,
or any operation on a WITHOUT ROWID table, the value of the sixth
parameter is undefined. For an INSERT or UPDATE on a rowid table the
seventh parameter is the final rowid ...
|
|
Swarmvtab Virtual Table
(swarmvtab.html)
1. Overview
The "swarmvtab" virtual table allows the user to query a large number
of tables (hereafter "component" tables) with similar schemas but distinct
ranges of rowid values as if they were a single database table. The tables may
be (and usually ...
|
|
Automatic Undo/Redo With SQLite
(undoredo.html)
... CREATE TEMP TRIGGER ex1_it AFTER INSERT ON ex1 BEGIN
INSERT INTO undolog VALUES(NULL,'DELETE FROM ex1 WHERE rowid='||new.rowid);
END;
CREATE TEMP TRIGGER ex1_ut AFTER UPDATE ON ex1 BEGIN
INSERT INTO undolog VALUES(NULL,'UPDATE ex1
SET a ...
|
|
C API: Pseudo-Random Number Generator
(c3ref/randomness.html)
sqlite3_randomness()
SQLite contains a high-quality pseudo-random number generator (PRNG) used to
select random ROWIDs when inserting new records into a table that
already uses the largest possible ROWID. The PRNG is also used for
the built-in random() and ...
|
|
SQLite Version 3 Overview
(version3.html)
... 64-bit ROWIDs
Every row of a table has a unique rowid.
If the table defines a column with the type "INTEGER PRIMARY KEY" then that
column becomes an alias for the rowid. But with or without an INTEGER PRIMARY ...
|
|
C API: Extract Metadata About A Column Of A Table
(c3ref/table_column_metadata.html)
sqlite3_table_column_metadata()
... If the specified column is "rowid", "oid" or "_rowid_" and the table
is not a WITHOUT ROWID table and an
INTEGER PRIMARY KEY column has been explicitly declared, then the output
parameters are set for the explicitly declared column. If ...
|
|
Imposter Tables
(imposter.html)
2. Details
... The 64-bit integer key is the ROWID. Index b-trees contain
an arbitrary binary key and no data. So table b-trees and index
b-trees are not directly compatible.
However, the b-tree for a WITHOUT ROWID table ...
|
|
Profiling SQL Queries
(profile.html)
2. Simple Cases - Rows, Loops and Cycles
... sqlite3> SELECT * FROM t1, t2 WHERE t2.c=t1.a;
<...query results...>
QUERY PLAN (cycles=1140768 [100%])
|--SCAN t1 (cycles=455974 [40%] loops=1 rows=500)
`--SEARCH t2 USING INTEGER PRIMARY KEY (rowid=?) (cycles ...
|
|
The Carray() Table-Valued Function
(carray.html)
4. Usage
... For example, to query two entries from the OBJ table using rowids
taken from a C-language array at address $PTR.
SELECT obj.* FROM obj, carray($PTR, 10) AS x
WHERE obj.rowid=x.value;
This query gives the same ...
|
|
Database File Format
(fileformat.html)
2.4. Representation of WITHOUT ROWID Tables
If an SQL table is created using the "WITHOUT ROWID" clause at the
end of its CREATE TABLE statement, then that table is a WITHOUT ROWID
table and uses a different on-disk representation. A WITHOUT ROWID
table uses an ...
|
Page generated by FTS5 in about 109.31 ms.