Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Using SQLite In Multi-Threaded Applications
(threadsafe.html)
3. Start-time selection of threading mode
Assuming that the compile-time threading mode is not single-thread, then
the threading mode can be changed during initialization using the
sqlite3_config() interface. The SQLITE_CONFIG_SINGLETHREAD verb
puts SQLite into single-thread mode, the SQLITE_CONFIG_MULTITHREAD
verb sets multi-thread mode ...
|
|
Row Values
(rowvalue.html)
2.2. Row Value IN Operators
... CREATE TABLE t2(x,y,z);
INSERT INTO t2(x,y,z) VALUES(1,2,3),(2,3,4),(1,NULL,5);
SELECT
(1,2,3) IN (SELECT * FROM t2), -- 1
(7,8,9) IN (SELECT * FROM t2), -- 0
(1 ...
|
|
Isolation In SQLite
(isolation.html)
... And the SELECT statement
obviously does not see any changes that occur after the SELECT statement
completes. But what about changes that occur while the SELECT statement
is running? What if a SELECT statement is started and the sqlite3_step()
interface ...
|
|
Swarmvtab Virtual Table
(swarmvtab.html)
3.4. The "missing" Callback
... SELECT openclose_udf(<database-name>, 0);
if( error ) return error;
if( db does not exist ){
SELECT missing_udf(<database-name>);
if( error ){
SELECT openclose_udf(<database-name>, 1);
return error;
}
}
sqlite3_open_v2(<database-name>);
if( error ...
|
|
Datatypes In SQLite
(datatype3.html)
6. Sorting, Grouping and Compound SELECTs
... The compound SELECT operators UNION,
INTERSECT and EXCEPT perform implicit comparisons between values.
No affinity is applied to comparison operands for the implicit
comparisons associated with UNION, INTERSECT, or EXCEPT - the values
are compared as is.
|
|
SQLite Database Speed Comparison
(speed.html)
... 100 SELECTs without an index
BEGIN;
SELECT count(*), avg(b) FROM t2 WHERE b>=0 AND b
SELECT count(*), avg(b) FROM t2 WHERE b>=100 AND b
... 96 lines omitted
SELECT count(*), avg(b) FROM t2 WHERE b>=9800 ...
|
|
C API: Declared Datatype Of A Query Result
(c3ref/column_decltype.html)
sqlite3_column_decltype(), sqlite3_column_decltype16()
... If this statement is a SELECT statement and the Nth column of the
returned result set of that SELECT is a table column (not an
expression or subquery) then the declared type of the table
column is returned. If the ...
|
|
NUL Characters In Strings
(nulinstr.html)
2. Unexpected Behavior
... CREATE TABLE t1(
a INTEGER PRIMARY KEY,
b TEXT
);
INSERT INTO t1(a,b) VALUES(1, 'abc'||char(0)||'xyz');
SELECT a, b, length(b) FROM t1;
The SELECT statement above shows output of:
1,'abc',3
(Through this document ...
|
|
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 ...
|
|
C API: Retrieving Statement SQL
(c3ref/expanded_sql.html)
sqlite3_sql(), sqlite3_expanded_sql(), sqlite3_normalized_sql()
... For example, if a prepared statement is created using the SQL
text "SELECT $abc,:xyz" and if parameter $abc is bound to integer 2345
and parameter :xyz is unbound, then sqlite3_sql() will return
the original string, "SELECT $abc,:xyz" but ...
|
Page generated by FTS5 in about 175.26 ms.