Small. Fast. Reliable.
Choose any three.
Choose any three.
|
SQLite As An Application File Format
(appfileformat.html)
... If you've chosen the right data structures
and organized things well, the algorithms will almost always
be self-evident. Data structures, not algorithms, are central
to programming.
Linus Torvalds used different words to say
much the same thing on ...
|
|
SQLite Shared-Cache Mode
(sharedcache.html)
2.2. Table Level Locking
... Tables support
two types of locks, "read-locks" and "write-locks". Locks are granted to
connections - at any one time, each database connection has either a
read-lock, write-lock or no lock on each database table.
At any one ...
|
|
Swarmvtab Virtual Table
(swarmvtab.html)
1. Overview
... The types and default collation sequences attached to each column
must be the same for all component tables.
All component tables must have the same PRIMARY KEY declaration (if any).
A swarmvtab table has the same schema as each of ...
|
|
Result and Error Codes
(rescode.html)
6. Result Code Meanings
... SQLite is normally very forgiving about mismatches between the type of
a value and the declared type of the container in which that value is
to be stored. For example, SQLite allows the application to store
a large BLOB in ...
|
|
Pragma statements supported by SQLite
(pragma.html)
PRAGMA table_info
... Columns in the result set include: "name" (its name); "type"
(data type if given, else ''); "notnull" (whether or not the column
can be NULL); "dflt_value" (the default value for the column);
and "pk" (either zero for columns that are not ...
|
|
Temporary Files Used By SQLite
(tempfiles.html)
... But if SQLite cannot find an appropriate index
it will evaluate the query and store each row in a transient index
whose data is the row data and whose key is the ORDER BY terms.
After the query is evaluated ...
|
|
Compile-time Options
(compile.html)
7. Options To Enable Features Normally Turned Off
... The ANALYZE command is enhanced to collect
histogram data from all columns of every index and store that data
in the sqlite_stat4 table. The query planner will then use the
histogram data to help it make better index choices. The ...
|
|
The Tcl interface to the SQLite library
(tclsqlite.html)
3.13. The function method
... If this option is set to "any" (the default), SQLite attempts to
determine the type of each value returned by the function implementation based
on the Tcl value's internal type. Or, if it is set to "text" or "blob ...
|
|
The Virtual Table Mechanism Of SQLite
(vtab.html)
2.1. The xCreate Method
... The second argument to sqlite3_declare_vtab() must a zero-terminated
UTF-8 string that contains a well-formed CREATE TABLE statement that
defines the columns in the virtual table and their data types.
The name of the table in this CREATE ...
|
|
SQLite Changes From Version 3.4.2 To 3.5.0
(34to35.html)
... SQLITE_IOCAP_SAFE_APPEND means that when extending a file with new
data, the new data is written first and then the file size is updated.
So if a power failure occurs, there is no chance that the file might have
been extended ...
|
Page generated by FTS5 in about 114.54 ms.