Small. Fast. Reliable.
Choose any three.
Choose any three.
|
The SQLite Zipfile Module
(zipfile.html)
3.1. Table-Valued Function (read-only access)
... This identifies the type of record (file, directory
or symbolic link), and the associated user/group/all
permissions.
mtime UTC timestamp, in seconds since the UNIX epoch (an integer).
sz Size of associated data in bytes after it has been ...
|
|
The Session Extension
(sessionintro.html)
3.3. Inspecting the Contents of a Changeset
The example code below demonstrates the techniques used to iterate
through and extract the data related to all changes in a changeset. To
summarize:
The sqlite3changeset_start() API is called to create and
initialize an iterator to iterate through the contents ...
|
|
C API: Last Insert Rowid
(c3ref/last_insert_rowid.html)
sqlite3_last_insert_rowid()
... If
the table has a column of type INTEGER PRIMARY KEY then that column
is another alias for the rowid.
The sqlite3_last_insert_rowid(D) interface usually returns the rowid of
the most recent successful INSERT into a rowid table or virtual ...
|
|
SQLite Autoincrement
(autoinc.html)
3. The AUTOINCREMENT Keyword
If a column has the type INTEGER PRIMARY KEY AUTOINCREMENT then a slightly
different ROWID selection algorithm is used.
The ROWID chosen for the new row is at least one larger than the largest ROWID
that has ever before existed ...
|
|
Database File Format
(fileformat.html)
2.1. Record Format
The data for a table b-tree leaf page and the key
of an index b-tree page was characterized above
as an arbitrary sequence of bytes.
The prior discussion mentioned one key being less than another, but
did not ...
|
|
SQLite FTS3 and FTS4 Extensions
(fts3.html)
6.1. The compress= and uncompress= options
... Specifically, when a user reads a value from
a compressed FTS table, the value returned by FTS is exactly the same
as the value returned by the uncompress function, including the data type.
If that data type is not the ...
|
|
ALTER TABLE
(lang_altertable.html)
... Create new table
Copy data
Drop old table
Rename new into old
Rename old table
Create new table
Copy data
Drop old table
↑Correct
↑Incorrect
The 12-step generalized ALTER TABLE procedure
above will work even if the ...
|
|
SELECT
(lang_select.html)
... The input data for the simple SELECT is
determined. The input data is either implicitly a single row with 0
columns (if there is no FROM clause) or is determined by the FROM
clause.
WHERE clause processing: The input data ...
|
|
The RBU Extension
(rbu.html)
2.2.1. The RBU Database Schema
For each table in the target database, the RBU database should contain a table
named "data<integer>_<target-table-name>" where
<target-table-name> is the name of the table in the target ...
|
|
SQLite Archive Files
(sqlar.html)
2. Advantages Of SQLite Archives
... An
SQLite Archive stores files plus whatever other tabular
and/or relational data seems useful to the application.
An SQLite Archive is transactional.
Updates are atomic and durable, even if there are crashes
or power losses in the middle of ...
|
Page generated by FTS5 in about 114.98 ms.