Small. Fast. Reliable.
Choose any three.
Choose any three.
|
The Percentile Extension
(percentile.html)
4. Design Requirements
... All of median(), percentile(Y,P), percentile_cont(Y,P) and
percentile_disc(Y,P) can be used as window functions.
This page last modified on 2025-02-06 11:58:24 UTC
|
|
Architecture of SQLite
(arch.html)
... SQLite currently provides VFSes for unix (in the os_unix.c
file) and Windows (in the os_win.c file).
Utilities
Memory allocation, caseless string comparison routines,
portable text-to-number conversion routines, and other utilities
are located in util.c.
Symbol ...
|
|
Partial Indexes
(partialindex.html)
2. Creating Partial Indexes
... show
window-defn:
show
frame-spec:
show
type-name:
show
signed-number:
show
indexed-column:
show
Any index that includes the WHERE clause at the end is considered to be
a partial index. Indexes that omit the WHERE clause (or ...
|
|
SQL Language Expressions
(lang_expr.html)
... Functions
SQLite supports many simple, aggregate,
and window
SQL functions. For presentation purposes, simple functions are further
subdivided into core functions, date-time functions,
math functions, and JSON functions.
Applications can add new functions, written in C/C++, using the ...
|
|
SQLite Over a Network, Caveats and Considerations
(useovernet.html)
... When all process writes to the device have completed,
(when POSIX fsync() or Windows FlushFileBuffers() calls return),
the filesystem then either has
stored the "written" data or will do so
before storing any subsequently written data.
When network filesystem apparatus ...
|
|
WAL-mode File Format
(walformat.html)
This document describes low-level details on how WAL mode is
implemented on unix and windows.
The separate file format description provides details on the
structure of a database file and of the write-head log file used in
WAL ...
|
|
Date And Time Functions
(lang_datefunc.html)
... Non-Vista Windows platforms only support one set of DST rules.
Vista only supports two. Therefore, on these platforms,
historical DST calculations will be incorrect.
For example, in the US, in 2007 the DST rules changed.
Non-Vista Windows platforms ...
|
|
SQLite As An Application File Format
(appfileformat.html)
... SQLite database files are portable between 32-bit and 64-bit machines and
between big-endian and little-endian architectures and between any of the
various flavors of Windows and Unix-like operating systems.
The application using an SQLite application ...
|
|
Books About SQLite
(books.html)
... SQLite runs on Linux, Windows, Mac OS X, and a few other operating systems. It has been widely used in low-to-medium tier database applications.
This Short Cut discusses design principles, engineering trade-offs,
implementation issues, and operations of ...
|
|
SQLite Older News
(oldnews.html)
... 2013-04-12 - Release 3.7.16.2
SQLite version 3.7.16.2 fixes a long-standing flaw in the Windows
OS interface that
can result in database corruption under a rare race condition.
See https://sqlite.org/src ...
|
Page generated by FTS5 in about 121.20 ms.