Small. Fast. Reliable.
Choose any three.
Choose any three.
|
What If OpenDocument Used SQLite?
(affcase1.html)
... idea that all
SQL database schemas must be factored into third normal form and store
only small primitive data types such as strings and integers. Certainly
relational theory is important and designers should strive to understand
it. But, as demonstrated ...
|
|
The Virtual Database Engine of SQLite
(vdbe.html)
... CREATE TABLE examp(one text, two int);
In words, we have a database table named "examp" that has two
columns of data named "one" and "two". Now suppose we want to insert a single
record into this table. Like this ...
|
|
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 ...
|
|
Query Planning
(queryplanner.html)
... CREATE TABLE FruitsForSale(
Fruit TEXT,
State TEXT,
Price REAL
);
With some (arbitrary) data, such a table might be logically stored on disk
as shown in figure 1:
Figure 1: Logical Layout Of Table "FruitsForSale"
In this example, the rowids are ...
|
|
Pragma statements supported by SQLite
(pragma.html)
... query the SQLite library for
internal (non-table) data. The PRAGMA statement is issued using the same
interface as other SQLite commands (e.g. SELECT, INSERT) but is
different in the following important respects:
The pragma command is specific to ...
|
|
SQLite Foreign Key Support
(foreignkeys.html)
... Attempting to insert
a row into the track table that does not correspond to any
row in the artist table will fail, as will attempting to
delete a row from the artist table when there exist dependent
rows in the ...
|
|
Compile-time Options
(compile.html)
9. Options To Omit Features
... Hence, this option also
disables the ability to insert more than a single row using an
INSERT INTO ... VALUES ... statement.
SQLITE_OMIT_CTE
This option causes support for common table expressions to be omitted.
SQLITE_OMIT_DATETIME_FUNCS
If this option is defined, SQLite's ...
|
|
The Tcl interface to the SQLite library
(tclsqlite.html)
3.7. The copy method
The "copy" method copies data from a file into a table.
It returns the number of rows processed successfully from the file.
The syntax of the copy method looks like this:
dbcmd copy conflict-algorithm
...
|
Page generated by FTS5 in about 125.27 ms.