Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Datatypes In SQLite version 2
(datatypes.html)
... CREATE TABLE ex2(
a VARCHAR(10),
b NVARCHAR(15),
c TEXT,
d INTEGER,
e FLOAT,
f BOOLEAN,
g CLOB,
h BLOB,
i TIMESTAMP,
j NUMERIC(10,5)
k VARYING CHARACTER (24),
l NATIONAL VARYING CHARACTER(16)
);
And so forth. Basically ...
|
|
SQLite Shared-Cache Mode
(sharedcache.html)
2.2.1. Read-Uncommitted Isolation Mode
... the value of the read-uncommitted flag:
**
** True -> Set the connection to read-uncommitted mode.
** False -> Set the connection to serialized (the default) mode.
*/
PRAGMA read_uncommitted = <boolean>;
/* Retrieve the current value of the read-uncommitted flag */
PRAGMA read_uncommitted;
|
|
Custom Builds Of SQLite
(custombuild.html)
... sqlite3_config(SQLITE_CONFIG_SINGLETHREAD);
Disabling mutexes at run-time is not as effective as disabling them
at compile-time since SQLite still must do a test of a boolean variable
to see if mutexes are enabled or disabled at each point where ...
|
|
How SQLite Is Tested
(testing.html)
7.3. Forcing coverage of boundary values and boolean vector tests
Another macro used in conjunction with test coverage measurement is
the testcase() macro. The argument is a condition for which
we want test cases that evaluate to both true and false.
In non-coverage builds (that is to say, in ...
|
|
Appropriate Uses For SQLite
(whentouse.html)
1. Situations Where SQLite Works Well
... The data can be a complex mix of large binary blobs, text, and small
numeric or boolean values. The data format can be easily extended
by adding new tables and/or columns, without breaking legacy receivers.
The SQL query language ...
|
|
C API: Standard File Control Opcodes
(c3ref/c_fcntl_begin_atomic_write.html)
SQLITE_FCNTL_LOCKSTATE, SQLITE_FCNTL_GET_LOCKPROXYFILE, SQLITE_FCNTL_SET_LOCKPROXYFILE, SQLITE_FCNTL_LAST_ERRNO, SQLITE_FCNTL_SIZE_HINT, SQLITE_FCNTL_CHUNK_SIZE ...
... The SQLITE_FCNTL_HAS_MOVED file control interprets its argument as a
pointer to an integer and it writes a boolean into that integer depending
on whether or not the file has been renamed, moved, or deleted since it
was first opened.
The ...
|
|
Many Small Queries Are Efficient In SQLite
(np1queryprob.html)
4. The Need For Over 200 SQL Statements Per Webpage
... TEMP TABLE IF NOT EXISTS timeline(
rid INTEGER PRIMARY KEY,
uuid TEXT,
timestamp TEXT,
comment TEXT,
user TEXT,
isleaf BOOLEAN,
bgcolor TEXT,
etype TEXT,
taglist TEXT,
tagid INTEGER,
short TEXT,
sortby REAL
)
;
INSERT OR IGNORE INTO timeline SELECT
blob.rid ...
|
|
The Virtual Table Mechanism Of SQLite
(vtab.html)
2.14. The xFindFunction Method
... If xFindFunction returns
SQLITE_INDEX_CONSTRAINT_FUNCTION or greater, than means that the function
takes two arguments and the function
can be used as a boolean in the WHERE clause of a query and that
the virtual table is able to exploit that ...
|
|
The SQLite Bytecode Engine
(opcode.html)
4. The Opcodes
... Interpret the value in register P1 as a boolean value. Store that
boolean (a 0 or 1) in register P2. Or if the value in register P1 is
NULL, then the P3 is stored in register P2. Invert the answer ...
|
|
SQLite Frequently Asked Questions
(faq.html)
... You can put arbitrary length
strings into integer columns, floating point numbers in boolean columns,
or dates in character columns. The datatype you assign to a column in the
CREATE TABLE command does not restrict what data can be put ...
|
Page generated by FTS5 in about 90.00 ms.