Small. Fast. Reliable.
Choose any three.
Choose any three.
|
SQLite FTS5 Extension
(fts5.html)
8. The fts5vocab Virtual Table Module
... CREATE VIRTUAL TABLE ft USING fts5(c1, c2);
INSERT INTO ft VALUES('apple banana cherry', 'banana banana cherry');
INSERT INTO ft VALUES('cherry cherry cherry', 'date date date');
-- Then querying the following fts5vocab table (type "col") returns:
--
-- apple | c1 | 1 ...
|
|
Compile-time Options
(compile.html)
3. Platform Configuration
... In the usual case
where SQLITE_OMIT_DATETIME_FUNCS is not defined or is false, then the
built-in date and time functions are used to implement the CURRENT_TIME,
CURRENT_DATE, and CURRENT_TIMESTAMP keywords and neither gmtime_r() nor
gmtime() is ever called.
HAVE_ISNAN
If ...
|
|
Built-In Scalar SQL Functions
(lang_corefunc.html)
... The string returned by sqlite_source_id() is
the date and time that the source code was checked in followed by
the SHA3-256 hash for that check-in. This function is
an SQL wrapper around the sqlite3_sourceid() C interface.
sqlite_version()
The ...
|
|
What If OpenDocument Used SQLite?
(affcase1.html)
... self2014.odp
Length Date Time Name
--------- ---------- ----- ----
47 2014-06-21 12:34 mimetype
0 2014-06-21 12:34 Configurations2/statusbar/
0 2014-06-21 12:34 Configurations2/accelerator/current.xml
0 2014-06-21 12:34 Configurations2/floater/
0 ...
|
|
The SQLite OS Interface or "VFS"
(vfs.html)
4. VFS Implementations
... The sqlite3_vfs object also contains
methods for obtaining randomness from the operating system, for
suspending a process (sleeping) and for finding the current date and
time.
The sqlite3_file object represents an open file.
The xOpen method of sqlite3_vfs constructs an ...
|
|
SQLite Version 3 Overview
(version3.html)
... Modern programmers should refer to
more up-to-date documentation on SQLite available elsewhere
on this website.
SQLite Version 3 Overview
SQLite version 3.0 introduces important changes to the library, including:
A more compact format for database files.
Manifest ...
|
|
An Introduction To The SQLite C/C++ Interface
(cintro.html)
8. Extending SQLite
... Refer to the SQLite source code, and in particular
the
date.c and
func.c source files
for examples.
Shared libraries or DLLs can be used as loadable extensions to SQLite.
|
|
SQLite Backup API
(backup.html)
3.1. File and Database Connection Locking
... can be sure that when the backup
operation is completed the backup database contains a consistent and
up-to-date snapshot of the original. However:
Writes to an in-memory source database, or writes to a file-based
source database ...
|
|
SQLite Changes From Version 3.4.2 To 3.5.0
(34to35.html)
... The xCurrentTime method finds the current time and date and writes
the result as a double-precision floating point value into pointer
provided by the second parameter. The time and date is in
coordinated universal time (UTC) and is a ...
|
|
CREATE TABLE
(lang_createtable.html)
... If the default value of a column is CURRENT_TIME, CURRENT_DATE or
CURRENT_TIMESTAMP, then the value used in the new row is a text
representation of the current UTC date and/or time. For CURRENT_TIME, the
format of the value is ...
|
Page generated by FTS5 in about 69.44 ms.