Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Window Functions
(windowfunctions.html)
1. Introduction to Window Functions
A window function is an SQL function where the input
values are taken from
a "window" of one or more rows in the results set of a SELECT statement.
Window functions are distinguished from scalar functions and
aggregate functions by ...
|
|
List of SQLite Syntax Diagrams
(syntax.html)
... select-stmt
signed-number
simple-function-invocation
simple-select-stmt
sql-stmt
sql-stmt-list
table-constraint
table-options
table-or-subquery
type-name
update-stmt
update-stmt-limited
upsert-clause
vacuum-stmt
window-defn
window-function-invocation
with-clause
|
|
C API: Name Of The Folder Holding Temporary Files
(c3ref/temp_directory.html)
... It is required to set a temporary folder on Windows Runtime (WinRT).
But for all other platforms, it is highly recommended that applications
neither read nor write this variable. This global variable is a relic
that exists for backwards compatibility ...
|
|
C API: Win32 Directory Types
(c3ref/c_win32_data_directory_type.html)
SQLITE_WIN32_DATA_DIRECTORY_TYPE, SQLITE_WIN32_TEMP_DIRECTORY_TYPE
These macros are only available on Windows. They define the allowed values
for the type argument to the sqlite3_win32_set_directory interface.
See also lists of
Objects,
Constants, and
Functions.
|
|
C API: Name Of The Folder Holding Database Files
(c3ref/data_directory.html)
... directory), then all database files
specified with a relative pathname and created or accessed by
SQLite when using a built-in windows VFS will be assumed
to be relative to that directory. If this variable is a NULL
pointer, then ...
|
|
The dbhash.exe Utility Program
(dbhash.html)
3. Building
To build a copy of the dbhash utility program on unix, get a copy of the
canonical SQLite source code and enter:
./configure
make dbhash
On Windows, enter:
nmake /f makefile.msc dbhash.exe
The dbhash program is implemented by ...
|
|
Uniform Resource Identifiers
(uri.html)
3.1. The URI Path
... On windows only, convert all "\" characters into "/".
Convert all sequences of two or more "/" characters into a
single "/" character.
On windows only, if the filename begins with a drive letter, prepend
a single "/" character.
Prepend the "file:" scheme.
|
|
Well-Known Users Of SQLite
(famous.html)
... Microsoft uses SQLite as a core component
of Windows 10, and in other products.
SQLite is the primary meta-data storage format for
the Firefox Web Browser and the
Thunderbird Email Reader from
Mozilla.
The Navigation Data Standard uses
SQLite ...
|
|
How To Compile SQLite
(howtocompile.html)
6. Building A Windows DLL
To build a DLL of SQLite for use in Windows, first acquire the
appropriate amalgamated source code files, sqlite3.c and sqlite3.h.
These can either
be downloaded from the SQLite website
or custom generated from sources as shown above ...
|
|
The SQLite OS Interface or "VFS"
(vfs.html)
3.2. Standard Windows VFSes
... The default
Windows VFS is called "win32" and is used in most applications.
Other VFSes that might be found on windows builds include:
win32-longpath - like "win32" except that pathnames can
be up to 65534 bytes in length, whereas pathnames ...
|
Page generated by FTS5 in about 82.65 ms.