Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Recent SQLite News
(news.html)
... No need to upgrade if you are not using DROP COLUMN.
2021-03-12 - Release 3.35.0
SQLite version 3.35.0 is a routine maintenance release. This
release adds a number of new language features, including
support for ...
|
|
The Tcl interface to the SQLite library
(tclsqlite.html)
... Column-separator is an optional column separator string. The default is
the ASCII tab character \t.
Null-indicator is an optional string that indicates a column value is null.
The default is an empty string. Note that column-separator and ...
|
|
UPSERT
(lang_upsert.html)
... Column names in the expressions of a DO UPDATE refer to the original
unchanged value of the column, before the attempted INSERT. To use the
value that would have been inserted had the constraint not failed,
add the special "excluded ...
|
|
CREATE TRIGGER
(lang_createtrigger.html)
... Both the WHEN clause and the trigger actions may access elements of
the row being inserted, deleted or updated using references of the form
"NEW.column-name" and "OLD.column-name", where
column-name is the name of a column ...
|
|
The RBU Extension
(rbu.html)
... The data_% table must have all the same columns as the target table, plus
one additional column named "rbu_control". The data_% table should have no
PRIMARY KEY or UNIQUE constraints, but each column should have the same type as
the ...
|
|
Clustered Indexes and the WITHOUT ROWID Optimization
(withoutrowid.html)
1.1. Syntax
To create a WITHOUT ROWID table, simply add the keywords "WITHOUT ROWID"
to the end of the CREATE TABLE statement. For example:
CREATE TABLE IF NOT EXISTS wordcount(
word TEXT PRIMARY KEY,
cnt INTEGER
) WITHOUT ROWID;
As with all SQL ...
|
|
Distinctive Features Of SQLite
(different.html)
... SQLite thus allows the user to store
any value of any datatype into any column regardless of the declared type
of that column. (There are some exceptions to this rule: An INTEGER
PRIMARY KEY column may only store integers. And ...
|
|
The Advantages Of Flexible Typing
(flextypegood.html)
... Datatype names on column definitions are optional. A column definition
can consist of just the column name and nothing else.
When datatype names are provided, they can be just about any text.
SQLite attempts to deduce the preferred datatype for ...
|
|
The SQLITE_DBPAGE Virtual Table
(dbpage.html)
... There is
a third hidden column named "schema" that determines which
ATTACH-ed database should be read or written. Because
the "schema" column is hidden, it can be used as a parameter when
SQLITE_DBPAGE is invoked as a table-valued ...
|
|
The Virtual Table Mechanism Of SQLite
(vtab.html)
1. Introduction
... ADD COLUMN
commands against a virtual table.
Individual virtual table implementations might impose additional
constraints. For example, some virtual implementations might provide
read-only tables. Or some virtual table implementations might allow
INSERT or DELETE but not UPDATE. Or some ...
|
Page generated by FTS5 in about 65.28 ms.