Small. Fast. Reliable.
Choose any three.
Choose any three.
|
C API: Automatically Load Statically Linked Extensions
(c3ref/auto_extension.html)
sqlite3_auto_extension(), struct sqlite3_api_routines
... Calling sqlite3_auto_extension(X) with an entry point X that is already
on the list of automatic extensions is a harmless no-op. No entry point
will be called more than once for each database connection that is opened.
See also ...
|
|
NUL Characters In Strings
(nulinstr.html)
3. How To Tell If You Have NUL Characters In Your Strings
... 1,X'6162630078797a'
In the BLOB output, you can clearly see the NUL character as the 4th
character in the 7-character string.
Another, more automated, way
to tell if a string value X contains embedded NUL characters is to ...
|
|
CREATE TABLE
(lang_createtable.html)
... CREATE TABLE t(x INTEGER PRIMARY KEY ASC, y, z);
CREATE TABLE t(x INTEGER, y, z, PRIMARY KEY(x ASC));
CREATE TABLE t(x INTEGER, y, z, PRIMARY KEY(x DESC));
But the following declaration does not result in ...
|
|
Window Functions
(windowfunctions.html)
1. Introduction to Window Functions
... CREATE TABLE t0(x INTEGER PRIMARY KEY, y TEXT);
INSERT INTO t0 VALUES (1, 'aaa'), (2, 'ccc'), (3, 'bbb');
-- The following SELECT statement returns:
--
-- x | y | row_number
-----------------------
-- 1 | aaa | 1
-- 2 | ccc | 3
-- 3 | bbb | 2
--
SELECT x, y, row_number ...
|
|
SQL Language Expressions
(lang_expr.html)
... The BETWEEN operator
The BETWEEN operator is logically equivalent to a pair of comparisons.
"x BETWEEN y AND z" is
equivalent to
"x>=y AND x<=z" except
that with BETWEEN, the x expression is only evaluated once ...
|
|
The SQLite Query Optimizer Overview
(optoverview.html)
8.2. Range Queries
... CREATE TABLE ex2(x,y,z);
CREATE INDEX ex2i1 ON ex2(x);
CREATE INDEX ex2i2 ON ex2(y);
SELECT z FROM ex2 WHERE x BETWEEN 1 AND 100 AND y BETWEEN 1 AND 100;
Further suppose that column x contains ...
|
|
SQLite In 5 Minutes Or Less
(quickstart.html)
... 01 #!/usr/bin/tclsh
02 if {$argc!=2} {
03 puts stderr "Usage: %s DATABASE SQL-STATEMENT"
04 exit 1
05 }
06 package require sqlite3
07 sqlite3 db [lindex $argv 0]
08 db eval [lindex $argv 1] x {
09 ...
|
|
SQLite Archive Files
(sqlar.html)
5. Managing SQLite Archives From Application Code
... sqlar_compress(X)
The sqlar_compress(X) function attempts to compress a copy of the
blob X using the Default algorithm and returns the
result as a blob. If the input X is not a compressible blob, then
a copy of X ...
|
|
The Spellfix1 Virtual Table
(spellfix1.html)
7. Auxiliary Functions
... spellfix1_phonehash(X)
This routine constructs a phonetic hash of the pure ascii input word X
and returns that hash. This routine is used internally by spellfix1 in
order to transform the K1 column of the shadow table into the K2 ...
|
|
Well-Known Users Of SQLite
(famous.html)
... Apple uses SQLite in many (most?) of the
native applications running on Mac OS-X desktops and servers and
on iOS devices such as iPhones and iPods. SQLite is also used in
iTunes, even on non-Apple hardware.
Bentley Systems ...
|
Page generated by FTS5 in about 73.63 ms.