Small. Fast. Reliable.
Choose any three.
Choose any three.
|
The Session Extension
(sessionintro.html)
2.2. Conflicts
... Some other database constraint, for example a UNIQUE or CHECK
constraint, may be violated when the new row is inserted.
When processing a DELETE change, the following conflicts may be
detected:
The target database may contain no row with the ...
|
|
The SQLite R*Tree Module
(rtree.html)
4.1.1. Limitations
... Constraints such as NOT NULL, UNIQUE, REFERENCES, or CHECK
are also ignored. However, future versions
of SQLite might start paying attention to the type affinity and
constraints, so users of auxiliary columns are advised to leave
both blank, to avoid ...
|
|
The WITH Clause
(lang_with.html)
... If the original sudoku problem did not have a unique solution, then
the query will return all possible solutions. If the original problem
was unsolvable, then no rows will be returned. In this case, the unique
answer is:
534678912672195348198342567859761423426853791713924856961537284287419635345286179
The ...
|
|
The SQLite OS Interface or "VFS"
(vfs.html)
3. Multiple VFSes
... Each VFS has a unique names.
Separate database connections within the same process can be using
different VFSes at the same time. For that matter, if a single
database connection has multiple database files open using
the ATTACH command, then ...
|
|
Run-Time Loadable Extensions
(loadext.html)
7. Implementation Details
... not work (though
you will still be able to statically link the extension code, assuming
the entry pointers are uniquely named).
SQLite can be compiled with
SQLITE_OMIT_LOAD_EXTENSION to omit the extension loading code
from the build.
This page last modified ...
|
|
The C language interface to SQLite Version 2
(c_interface.html)
... 3.1 The ROWID of the most recent insert
Every row of an SQLite table has a unique integer key. If the
table has a column labeled INTEGER PRIMARY KEY, then that column
serves as the key. If there is ...
|
|
SQLite Version 3 Overview
(version3.html)
... 64-bit ROWIDs
Every row of a table has a unique rowid.
If the table defines a column with the type "INTEGER PRIMARY KEY" then that
column becomes an alias for the rowid. But with or without an INTEGER PRIMARY ...
|
|
The Next-Generation Query Planner
(queryplanner-ng.html)
5.2. Fixing The Problem
... Algorithm-1 is faster in common repositories, but
it is possible to construct a repository in which
every check-in is on a different uniquely-named branch and
all check-ins are children of the root check-in.
In that ...
|
|
Implementation Limits For SQLite
(limits.html)
... An "index" in
the previous sentences means an index created explicitly using a
CREATE INDEX statement or implicit indices created by UNIQUE and
PRIMARY KEY constraints.
Whenever a database is opened, the entire schema is scanned and parsed
and a ...
|
|
The Advantages Of Flexible Typing
(flextypegood.html)
3.5. Data typename cross-compatibility
Every SQL database engine seems to have its own unique set of supported
datatype names:
BIGINT
UNSIGNED SMALL INT
TEXT
VARCHAR
VARYING CHARACTER
NATIONAL VARYING CHARACTER
NVARCHAR
JSON
REAL
FLOAT
DOUBLE PRECISION
... and so forth ...
The fact that SQLite will ...
|
Page generated by FTS5 in about 97.92 ms.