Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Partial Indexes
(partialindex.html)
... Instead, SQLite uses
two simple rules to find the common cases where W⇒X is true, and
it assumes all the other cases are false. The rules used by SQLite
are these:
If W is AND-connected terms and ...
|
|
Temporary Files Used By SQLite
(tempfiles.html)
2.4. Super-Journal Files
The super-journal file is used as part of the atomic commit
process when a single transaction makes changes to multiple
databases that have been added to a single database connection
using the ATTACH statement. The super-journal file is ...
|
|
Datatypes In SQLite
(datatype3.html)
7.2. Collation Sequence Examples
... results of text comparisons that may be performed by various
SQL statements. Note that a text comparison may not be required, and no
collating sequence used, in the case of numeric, blob or NULL values.
CREATE TABLE t1(
x INTEGER ...
|
|
SQLite FTS5 Extension
(fts5.html)
5.1.2. The highlight() function
... SELECT highlight(ft, 0, '<b>', '</b>') FROM ft WHERE ft MATCH ?
In cases where two or more phrase instances overlap (share one or more
tokens in common), a single open and close marker is inserted for ...
|
|
VACUUM
(lang_vacuum.html)
... Unfinalized SQL
statements typically hold a read transaction open, so the VACUUM
might fail if there are unfinalized SQL statements on the same connection.
VACUUM (but not VACUUM INTO) is a write operation and so if another
database connection is ...
|
|
The RBU Extension
(rbu.html)
2.2.2. RBU Database Contents
... In this case, the new row silently replaces any existing row that
has the same primary key values. This is equivalent to a DELETE followed by an
INSERT with the same primary key values. It is not the same as ...
|
|
C API: Last Insert Rowid
(c3ref/last_insert_rowid.html)
sqlite3_last_insert_rowid()
... In this case subsequent calls to this function return the rowid
associated with these internal INSERT operations, which leads to
unintuitive results. Virtual table implementations that do write to rowid
tables in this way can avoid this problem by restoring ...
|
|
Result and Error Codes
(rescode.html)
6. Result Code Meanings
... If the database schema was changed by some other
process in between the time that the statement was prepared and the time
the statement was run, this error can result.
If a prepared statement is generated from sqlite3_prepare_v2() then
the ...
|
|
SQLite Shared-Cache Mode
(sharedcache.html)
... Before executing a statement that modifies the database schema (i.e.
a CREATE or DROP TABLE statement), a connection must obtain a write-lock on
sqlite_schema.
A connection may not compile an SQL statement if any other connection
is holding ...
|
|
The Tcl interface to the SQLite library
(tclsqlite.html)
3.7. The copy method
... SQLite conflict algorithms for
the INSERT statement: rollback, abort,
fail,ignore, or replace. See the SQLite Language
section for ON CONFLICT for
more information. The conflict-algorithm must be specified in lower case.
Table-name must already exists as a ...
|
Page generated by FTS5 in about 156.56 ms.