Small. Fast. Reliable.
Choose any three.
Choose any three.
|
The DBSTAT Virtual Table
(dbstat.html)
4. Example uses of the dbstat virtual table
... CREATE TEMP TABLE s(rowid INTEGER PRIMARY KEY, pageno INT);
INSERT INTO s(pageno) SELECT pageno FROM dbstat ORDER BY path;
SELECT sum(s1.pageno+1==s2.pageno)*1.0/count(*)
FROM s AS s1, s AS s2
WHERE s1 ...
|
|
C API: Flags for sqlite3_serialize
(c3ref/c_serialize_nocopy.html)
SQLITE_SERIALIZE_NOCOPY
Zero or more of the following constants can be OR-ed together for
the F argument to sqlite3_serialize(D,S,P,F).
SQLITE_SERIALIZE_NOCOPY means that sqlite3_serialize() will return
a pointer to contiguous in-memory database that it is currently using ...
|
|
The WITH Clause
(lang_with.html)
... An entry in x(s,ind) means that the 81-character string "s" is a valid
sudoku puzzle (it has no conflicts) and that the first unknown character
is at position "ind", or ind==0 if all character positions are ...
|
|
C API: Flags for sqlite3_deserialize()
(c3ref/c_deserialize_freeonclose.html)
SQLITE_DESERIALIZE_FREEONCLOSE, SQLITE_DESERIALIZE_RESIZEABLE, SQLITE_DESERIALIZE_READONLY
The following are allowed values for 6th argument (the F argument) to
the sqlite3_deserialize(D,S,P,N,M,F) interface.
The SQLITE_DESERIALIZE_FREEONCLOSE means that the database serialization
in the P argument is held in memory obtained from sqlite3_malloc64()
and ...
|
|
The RBU Extension
(rbu.html)
2.3. RBU Update C/C++ Programming
... Open an RBU handle using the sqlite3rbu_open(T,A,S) function.
The T argument is the name of the target database file.
The A argument is the name of the RBU database file.
The S argument is the name of ...
|
|
The Session Extension
(sessionintro.html)
1.1. Typical Use Case
... The session extension facilitates this by recording all changes to
both Alice's and Bob's databases and writing those changes into
changeset or patchset files. At the end of the day, Alice can send her
changeset to Bob and ...
|
|
Date And Time Functions
(lang_datefunc.html)
... HH:MM
%s seconds since 1970-01-01
%S seconds: 00-59
%T ISO 8601 time: HH:MM:SS
%U week of year (00-53) - week 01 starts on the first Sunday
%u day of week 1-7 with Monday ...
|
|
Imposter Tables
(imposter.html)
2.2. Transient Imposter Tables
Another (safer) approach to creating an imposter table is to add an
entry for the imposter table to SQLite's internal symbol table without
updating the "sqlite_schema" table on disk.
That way, the imposter table exists in only a single ...
|
|
The Next-Generation Query Planner
(queryplanner-ng.html)
3.1. Query Details
... For example, the
cost of running the S loop as an inner loop to L is 2.30 whereas the
cost of running the S loop as an outer loop to L is 9.17.
The "cost" here is logarithmic ...
|
|
SQLite Over a Network, Caveats and Considerations
(useovernet.html)
... Hence, use of a remote database is done at the user's risk.
Recommendations
Generally, if your data is separated from the application
by a network, you want to use a client/server database.
This is due to the fact ...
|
Page generated by FTS5 in about 73.56 ms.