Small. Fast. Reliable.
Choose any three.
Choose any three.
|
SQLite FTS3 and FTS4 Extensions
(fts3.html)
1.3. Populating FTS Tables
... The rowid of an FTS
table behaves in the same way as the rowid column of an ordinary SQLite
table, except that the values stored in the rowid column of an FTS table
remain unchanged if the database is rebuilt ...
|
|
Recovering Data From A Corrupt SQLite Database
(recovery.html)
2. Recovery Using The ".recover" Command In The CLI
... Use this option to change the name of the
"lost_and_found" table to "TABLE".
--no-rowids
If this option is provided, then rowid values that are not also
INTEGER PRIMARY KEY values are not extracted from the
corrupt database.
|
|
The SQLite Bytecode Engine
(opcode.html)
4. The Opcodes
... P3 is an integer rowid. If P1 does not contain a record with
rowid P3 then jump immediately to P2. Or, if P2 is 0, raise an
SQLITE_CORRUPT error. If P1 does contain a record with rowid P3 then
leave ...
|
|
The INDEXED BY Clause
(lang_indexedby.html)
... However, the rowid
can still be used to look up entries even when "NOT INDEXED" is specified.
Some SQL database engines provide non-standard "hint" mechanisms which
can be used to give the query optimizer clues about what indices it ...
|
|
STRICT Tables
(stricttables.html)
5. Other Table Options
... STRICT
WITHOUT ROWID
If there are multiple options, they can be specified in any order.
To keep things simple, the current parser accepts duplicate options without
complaining, but that might change in future releases, so applications
should not rely on ...
|
|
CREATE TRIGGER
(lang_createtrigger.html)
... The value of NEW.rowid is undefined in a BEFORE INSERT trigger in which
the rowid is not explicitly set to an integer.
Because of the behaviors described above, programmers are encouraged to
prefer AFTER triggers over BEFORE triggers.
6 ...
|
|
The SQLite R*Tree Module
(rtree.html)
7.1. Shadow Tables
... Each entry in an R*Tree has a rowid. The %_rowid shadow table maps entry
rowids to the node that contains that entry.
Extra columns appended to the %_rowid table hold the
content of auxiliary columns. The names of these ...
|
|
Quirks, Caveats, and Gotchas In SQLite
(quirks.html)
5. PRIMARY KEYs Can Sometimes Contain NULLs
... The WITHOUT ROWID and STRICT features was added after this bug was
discovered, and so WITHOUT ROWID and STRICT tables work correctly:
They disallow NULLs in the PRIMARY KEY.
|
|
C API: Configuration Options
(c3ref/c_config_covering_index_scan.html)
SQLITE_CONFIG_SINGLETHREAD, SQLITE_CONFIG_MULTITHREAD, SQLITE_CONFIG_SERIALIZED, SQLITE_CONFIG_MALLOC, SQLITE_CONFIG_GETMALLOC, SQLITE_CONFIG_SCRATCH ...
... SQLITE_CONFIG_ROWID_IN_VIEW
The SQLITE_CONFIG_ROWID_IN_VIEW option enables or disables the ability
for VIEWs to have a ROWID. The capability can only be enabled if SQLite is
compiled with -DSQLITE_ALLOW_ROWID_IN_VIEW, in which case the capability
defaults to on. This configuration option queries the ...
|
|
Isolation In SQLite
(isolation.html)
... If an application issues a SELECT statement on a single table like
"SELECT rowid, * FROM table WHERE ..." and starts stepping through
the output of that statement using sqlite3_step() and examining each
row, then it is safe for the application to ...
|
Page generated by FTS5 in about 130.45 ms.