Small. Fast. Reliable.
Choose any three.
Choose any three.
|
The Percentile Extension
(percentile.html)
3.3. The percentile_cont(Y,P) aggregate function
... SELECT percentile_cont(Y,P) FROM tab;
SQLite will support the SQL-standard syntax, but only if it is compiled
(from canonical sources, not from the amalgamation) using the
-DSQLITE_ENABLE_ORDERED_SET_AGGREGATES=1 compile-time option. Without that
compile-time option, only the ...
|
|
Partial Indexes
(partialindex.html)
3. Queries Using Partial Indexes
... terms in W and X must match exactly. SQLite does not
do algebra to try to get them to look the same.
The term "b=6" does not match "b=3+3" or "b-6=0" or "b BETWEEN 6 ...
|
|
Recovering Data From A Corrupt SQLite Database
(recovery.html)
3.3. Example Implementations
Examples of how the recovery extension is used by SQLite itself
can be seen at the following links:
https://sqlite.org/src/info/30475c820dc5ab8a8?ln=999,1026
An example of the recovery extension found in the
"fuzzcheck" testing utility in ...
|
|
Why SQLite Does Not Use Git
(whynotgit.html)
3.3. Fossil Access
... mkdir ~/fossils
fossil clone https://sqlite.org/src ~/fossils/sqlite.fossil
mkdir ~/sqlite; cd ~/sqlite
fossil open ~/fossils/sqlite.fossil
At this point you are ready to type "./configure; make"
(or on Windows with MSVC, "nmake /f Makefile.msc").
To ...
|
|
The SQLite Amalgamation
(amalgamation.html)
3. The Split Amalgamation
... Then there is a separate source file named
"sqlite3-all.c" which basically consists of code like this:
#include "sqlite3-1.c"
#include "sqlite3-2.c"
#include "sqlite3-3.c"
#include "sqlite3-4.c"
#include "sqlite3-5.c"
#include "sqlite3 ...
|
|
Dynamic Memory Allocation In SQLite
(malloc.html)
3.1.3. The Win32 native memory allocator
If SQLite is compiled for Windows with the SQLITE_WIN32_MALLOC
compile-time option, then a different, thin wrapper is used around
HeapAlloc(), HeapReAlloc(), and HeapFree(). The thin wrapper uses the
configured SQLite heap, which will be different from the default process ...
|
|
C API: Virtual Table Indexing Information
(c3ref/index_info.html)
struct sqlite3_index_info, struct sqlite3_index_constraint, struct sqlite3_index_orderby ...
... The estimatedRows field was added to the sqlite3_index_info
structure for SQLite version 3.8.2 (2013-12-06).
If a virtual table extension is
used with an SQLite version earlier than 3.8.2, the results of attempting
to read ...
|
|
C API: Fundamental Datatypes
(c3ref/c_blob.html)
SQLITE_INTEGER, SQLITE_FLOAT, SQLITE_BLOB, SQLITE_NULL
... Note that the SQLITE_TEXT constant was also used in SQLite version 2
for a completely different meaning. Software that links against both
SQLite version 2 and SQLite version 3 should use SQLITE3_TEXT, not
SQLITE_TEXT.
See also lists of
Objects,
Constants ...
|
|
Application-Defined SQL Functions
(appfunc.html)
2.3. Callbacks
SQLite evaluates an SQL function by invoking callback routines.
|
|
Powersafe Overwrite
(psow.html)
... Enabling PSOW does not decrease SQLite's ability
to recover from a torn page.
Changes In SQLite Version 3.7.10
The VFS for SQLite version 3.7.10 (2012-01-16)
adds a new device characteristic
named SQLITE_IOCAP_POWERSAFE_OVERWRITE. Database ...
|
Page generated by FTS5 in about 342.49 ms.