Small. Fast. Reliable.
Choose any three.
Choose any three.
|
The Virtual Table Mechanism Of SQLite
(vtab.html)
2.1.3. WITHOUT ROWID Virtual Tables
... This is useful for cases where the virtual table rows
cannot easily be mapped into unique integers. A CREATE TABLE
statement that includes WITHOUT ROWID must define one or more columns as
the PRIMARY KEY. Every column of the PRIMARY ...
|
|
Result and Error Codes
(rescode.html)
6. Result Code Meanings
... the sqlite3_io_methods object.
(2067) SQLITE_CONSTRAINT_UNIQUE
The SQLITE_CONSTRAINT_UNIQUE error code
is an extended error code
for SQLITE_CONSTRAINT indicating that a UNIQUE constraint failed.
(2314) SQLITE_IOERR_RDLOCK
The SQLITE_IOERR_RDLOCK error code is an extended error code
for SQLITE_IOERR indicating an I/O error ...
|
|
SQLite Consortium Agreement
(consortium_agreement-20071201.html)
... The parties acknowledge that the unique nature of
Hwaci's services are substantial consideration for the
parties' entering into this Agreement. Neither this
Agreement nor any rights under this Agreement may be
assigned or otherwise transferred by Hwaci, in whole ...
|
|
JSON Functions And Operators
(json1.html)
4.23.1. Examples using json_each() and json_tree()
... SELECT big.rowid, fullkey, atom
FROM big, json_tree(big.json)
WHERE atom IS NOT NULL;
Suppose each entry in the BIG table is a JSON object
with a '$.id' field that is a unique identifier
and a '$.partlist' field that ...
|
|
SQLite Session Module C/C++ Interface
(session.html)
... For each unique primary key value, data is only
recorded once - the first time a row with said primary key is inserted,
updated or deleted in the lifetime of the session.
There is one exception to the previous paragraph: when ...
|
|
Built-In Scalar SQL Functions
(lang_corefunc.html)
... applications can generate globally unique identifiers
using this function together with hex() and/or
lower() like this:
hex(randomblob(16))
lower(hex(randomblob(16)))
replace(X,Y,Z)
The replace(X,Y,Z) function returns a string formed by substituting ...
|
|
What If OpenDocument Used SQLite?
(affcase1.html)
... instead of each slide having a page number that determines
its order within the presentation, each slide has a unique
integer identifier that is unrelated to where it occurs in sequence.
The order of slides in the presentation is determined ...
|
|
SQL Language Expressions
(lang_expr.html)
... The three special identifiers describe the
unique integer key (the rowid) associated with every
row of every table and so are not available on WITHOUT ROWID tables.
The special identifiers only refer to the row key if the CREATE TABLE ...
|
|
The SQLite Bytecode Engine
(opcode.html)
4. The Opcodes
... If P3==1, that
means P1 is an SQL index and that this instruction could have been
omitted if that index had been unique. P3 is usually 0. P3 is
always either 0 or 1.
If P5 is positive and ...
|
|
The SQLite Query Optimizer Overview
(optoverview.html)
14. Automatic Query-Time Indexes
... Do not confuse automatic indexes with the internal indexes (having names
like "sqlite_autoindex_table_N") that are sometimes
created to implement a PRIMARY KEY constraint or UNIQUE constraint.
The automatic indexes described here exist only for the duration of a
single query ...
|
Page generated by FTS5 in about 113.24 ms.