Small. Fast. Reliable.
Choose any three.
Choose any three.
|
The SQLite Query Optimizer Overview
(optoverview.html)
11. Subquery Flattening
... the subquery may not contain window functions.
the subquery must not be the right-hand side of a LEFT JOIN.
either the subquery is the first element of the outer query
or there are not RIGHT or FULL JOINs in ...
|
|
Result and Error Codes
(rescode.html)
6. Result Code Meanings
... In other words,
this code indicates a problem with the fsync() system call in unix
or the FlushFileBuffers() system call in windows.
(1038) SQLITE_CANTOPEN_CONVPATH
The SQLITE_CANTOPEN_CONVPATH error code is an extended error code
for SQLITE_CANTOPEN used only by Cygwin VFS ...
|
|
The C language interface to SQLite Version 2
(c_interface.html)
... In precompiled SQLite libraries available on the website, the Unix
versions are compiled with THREADSAFE turned off but the Windows
versions are compiled with THREADSAFE turned on. If you need something
different that this you will have to recompile.
Under ...
|
|
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 ...
|
|
The Tcl interface to the SQLite library
(tclsqlite.html)
2. Building And Installing The SQLite Extension for Tcl
... For example, if you have a custom Tcl 9.0 installation at
$HOME/tcl you can install the SQLite for that installation by running:
./configure --with-tclsh=$HOME/tcl/bin/tclsh9.0
make tclextension-install
On Windows, use the TCLDIR ...
|
|
How SQLite Is Tested
(testing.html)
11. Static Analysis
... SQLite compiles without warnings on GCC and Clang using
the -Wall and -Wextra flags on Linux and Mac and on MSVC on Windows.
No valid warnings are generated by the Clang Static Analyzer tool "scan-build"
either (though recent versions ...
|
|
Pragma statements supported by SQLite
(pragma.html)
PRAGMA data_store_directory
PRAGMA data_store_directory;
PRAGMA data_store_directory = 'directory-name';
Query or change the value of the sqlite3_data_directory global
variable, which windows operating-system interface backends use to
determine where to store database files specified using a relative
pathname.
Changing the data_store_directory setting is ...
|
|
The SQLite Bytecode Engine
(opcode.html)
4. The Opcodes
... AggFinal
P1 is the memory location that is the accumulator for an aggregate
or window function. Execute the finalizer function
for an aggregate and store the result in P1.
P2 is the number of arguments that the step function takes ...
|
Page generated by FTS5 in about 86.15 ms.