Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Datatypes In SQLite
(datatype3.html)
3. Type Affinity
... The type affinity of a column is the recommended type for data stored
in that column. The important idea here is that the type is recommended, not
required. Any column can still store any type of data.
It is just ...
|
|
CREATE TABLE
(lang_createtable.html)
... Column Data Types
Unlike most SQL databases, SQLite does not restrict the type of data that
may be inserted into a column based on the columns declared type. Instead,
SQLite uses dynamic typing. The declared type of a column is ...
|
|
C API: Result Values From A Query
(c3ref/column_blob.html)
sqlite3_column_blob(), sqlite3_column_double(), sqlite3_column_int(), sqlite3_column_int64(), sqlite3_column_text(), sqlite3_column_text16 ...
... The sqlite3_column_type() routine returns the
datatype code for the initial data type
of the result column. The returned value is one of SQLITE_INTEGER,
SQLITE_FLOAT, SQLITE_TEXT, SQLITE_BLOB, or SQLITE_NULL.
The return value of sqlite3_column_type() can be used to decide which
of ...
|
|
Quirks, Caveats, and Gotchas In SQLite
(quirks.html)
3. Flexible Typing
... If the application is initially taking advantage of SQLite's flexible typing,
then it will fail when moved to another database that is more judgmental
about data types.
Flexible typing is a feature of SQLite, not a bug. Flexible typing ...
|
|
Pointer Passing Interfaces
(bindptr.html)
... Except, the statement above does not work, thanks to pointer types.
The pointer generated by the MATCH operator has a type of "fts3cursor"
but the carray() function expects to receives a pointer of type "carray".
Because the pointer type on ...
|
|
C/C++ Interface For SQLite Version 3 (old)
(capi3.html)
... 17 /* The database schema changed */
#define SQLITE_TOOBIG 18 /* Too much data for one row of a table */
#define SQLITE_CONSTRAINT 19 /* Abort due to contraint violation */
#define SQLITE_MISMATCH 20 /* Data type mismatch */
#define SQLITE_MISUSE 21 /* Library used incorrectly */
#define SQLITE_NOLFS 22 ...
|
|
C API: Extract Metadata About A Column Of A Table
(c3ref/table_column_metadata.html)
sqlite3_table_column_metadata()
... data type: "INTEGER"
collation sequence: "BINARY"
not null: 0
primary key: 1
auto increment: 0
This function causes all database schemas to be read from disk and
parsed, if that has not already been done, and returns an error if ...
|
|
Recovering Data From A Corrupt SQLite Database
(recovery.html)
1.1. Limitations
... CHECK constraints,
FOREIGN KEY constraints, UNIQUE constraints, type constraints on
STRICT tables - any of these might be violated in the recovered
database.
Content might be moved from one table into another.
The recovery API does as good of a job ...
|
|
The SQLite R*Tree Module
(rtree.html)
3.1.1. Column naming details
... In an RTREE virtual table, the first column always has a
type affinity of INTEGER and all other data columns have a
type affinity of REAL.
In an RTREE_I32 virtual table, all columns have type affinity of INTEGER.
Recommended practice ...
|
|
Command Line Shell For SQLite
(cli.html)
4. Changing Output Formats
... sqlite> .mode list
sqlite> select * from tbl1;
hello!|10
goodbye|20
sqlite>
Type ".mode" with no arguments to show the current mode:
sqlite> .mode
current output mode: list
sqlite>
Use the ".separator" dot command to ...
|
Page generated by FTS5 in about 114.94 ms.