Small. Fast. Reliable.
Choose any three.
Choose any three.
|
C API: OS Interface Object
(c3ref/vfs.html)
sqlite3_syscall_ptr(), struct sqlite3_vfs
... The xCurrentTime()
method returns a Julian Day Number for the current date and time as
a floating point value.
The xCurrentTimeInt64() method returns, as an integer, the Julian
Day Number multiplied by 86400000 (the number of milliseconds in
a 24 ...
|
|
Architecture of SQLite
(arch.html)
... Date and time conversion functions are found in date.c.
Some functions such as coalesce() and typeof() are implemented
as bytecode directly by the code generator.
B-Tree
An SQLite database is maintained on disk using a B-tree implementation ...
|
|
SQLite Consortium Agreement
(consortium_agreement-20071201.html)
SQLite Consortium Agreement
This SQLite Consortium Agreement ("Agreement") is made and
entered into as of the _____ day of ______________, 2007 ("Effective Date")
by and between ___________________ (the "Company"), and
Hipp, Wyrick & Company, Inc., a Georgia Corporation with
headquarters at ...
|
|
Quirks, Caveats, and Gotchas In SQLite
(quirks.html)
3.2. No Separate DATETIME Datatype
... The built-in date and time functions of SQLite understand date/times in
all of the formats above, and can freely change between them.
Which format you use, is entirely up to your application.
|
|
The Checksum VFS Shim
(cksumvfs.html)
6. Controlling Checksum Verification
... Checksums are always kept up-to-date as long as the
reserve bytes value of the database is 8, regardless of the setting
of this pragma. Checksum verification can be disabled (for example)
to do forensic analysis of a database ...
|
|
The Lemon LALR(1) Parser Generator
(lemon.html)
3. History Of Lemon
... The original creation date of Lemon has been lost, but was probably sometime
around 1990. Lemon generates an LALR(1) parser. There was a companion
LL(1) parser generator tool named "Lime", but the source code for Lime
has been ...
|
|
UPSERT
(lang_upsert.html)
... CREATE TABLE phonebook2(
name TEXT PRIMARY KEY,
phonenumber TEXT,
validDate DATE
);
INSERT INTO phonebook2(name,phonenumber,validDate)
VALUES('Alice','704-555-1212','2018-05-08')
ON CONFLICT(name) DO UPDATE SET
phonenumber=excluded.phonenumber,
validDate=excluded.validDate
WHERE excluded.validDate ...
|
|
The SQLite Amalgamation
(amalgamation.html)
5.1. Dependencies
... https://sqlite.org/src/doc/trunk/doc/compile-for-unix.md
https://sqlite.org/src/doc/trunk/doc/compile-for-windows.md
In the links above, you can replace the "trunk" path component with
a different symbol or a date ...
|
|
The Advantages Of Flexible Typing
(flextypegood.html)
3.3. Storage for dirty data
... For example, a data column might contain the number
of seconds since 1970 sometimes, or a text date string in other cases.
It is desirable to clean up these inconsistent representations,
but at the same time it is convenient to ...
|
|
RETURNING
(lang_returning.html)
... CREATE TABLE t0(
a INTEGER PRIMARY KEY,
b DATE DEFAULT CURRENT_TIMESTAMP,
c INTEGER
);
INSERT INTO t0(c) VALUES(random()) RETURNING *;
In the INSERT statement above, SQLite computes the values for all
three columns. The RETURNING clause causes SQLite to report ...
|
Page generated by FTS5 in about 71.64 ms.