Small. Fast. Reliable.
Choose any three.
Choose any three.
|
The WITH Clause
(lang_with.html)
... Recursive SELECT statements may not use
aggregate functions or window functions.
To put it another way, a recursive common table expression must
look something like the following:
In the diagram above, initial-select means one or more
non-recursive SELECT ...
|
|
Write-Ahead Logging
(wal.html)
7. Implementation Of Shared-Memory For The WAL-Index
... And we could not find any method to create nameless shared
memory blocks on windows. The only way we have found to guarantee
that all processes accessing the same database file use the same shared
memory is to create the ...
|
|
Maintaining Private Branches Of SQLite
(privatebranch.html)
3.3. Installing The SQLite Baseline In Fossil
... If you will
be changing the line ending to windows-style line endings
(ASCII codes 13, 10: "carriage-return" and "newline"; CR-NL) or if you will be
changing space indents into tab indents, make that change now
before you ...
|
|
Appropriate Uses For SQLite
(whentouse.html)
2. Situations Where A Client/Server RDBMS May Work Better
... Also, file locking logic is buggy in
many network filesystem implementations (on both Unix and Windows).
If file locking does not work correctly,
two or more clients might try to modify the
same part of the same database at the ...
|
|
SQLite Changes From Version 3.4.2 To 3.5.0
(34to35.html)
... 2.1.1 Registering New VFS Objects
Standard builds of SQLite for Unix or Windows come with a single
VFS named "unix" or "win32", as appropriate. This one VFS is also
the default. So if you are using the legacy ...
|
|
C API: Configuration Options
(c3ref/c_config_covering_index_scan.html)
SQLITE_CONFIG_SINGLETHREAD, SQLITE_CONFIG_MULTITHREAD, SQLITE_CONFIG_SERIALIZED, SQLITE_CONFIG_MALLOC, SQLITE_CONFIG_GETMALLOC, SQLITE_CONFIG_SCRATCH ...
... SQLITE_CONFIG_WIN32_HEAPSIZE
The SQLITE_CONFIG_WIN32_HEAPSIZE option is only available if SQLite is
compiled for Windows with the SQLITE_WIN32_MALLOC pre-processor macro
defined. SQLITE_CONFIG_WIN32_HEAPSIZE takes a 32-bit unsigned integer value
that specifies the maximum size of the created heap.
SQLITE_CONFIG_PCACHE_HDRSZ
The SQLITE_CONFIG_PCACHE_HDRSZ ...
|
|
TH3
(th3.html)
6. TH3 License
... Even though open-source users do not have direct access to TH3, all
users of SQLite benefit from TH3 indirectly since each version of SQLite is
validated running TH3 on multiple platforms (Linux, Windows, WinRT, Mac,
OpenBSD) prior to release ...
|
|
Temporary Files Used By SQLite
(tempfiles.html)
5. Temporary File Storage Locations
... On Windows systems, folders are searched in the following order:
The folder set by PRAGMA temp_store_directory or by the
sqlite3_temp_directory global variable
The folder returned by the GetTempPath() system interface.
SQLite itself does not pay any attention to environment variables ...
|
|
What If OpenDocument Used SQLite?
(affcase1.html)
... This author's primary use for OpenDocument is
building slide presentations with either
NeoOffice on Mac, or
LibreOffice on Linux and Windows.
An OpenDocument Presentation or "ODP" file is a
ZIP archive containing
XML files describing presentation slides and separate ...
|
|
Built-In Scalar SQL Functions
(lang_corefunc.html)
... Date & Time functions,
aggregate functions,
window functions,
math functions, and
JSON functions are documented separately. An
application may define additional
functions written in C and added to the database engine using
the sqlite3_create_function() API.
See the functions within expressions ...
|
Page generated by FTS5 in about 86.29 ms.