Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Appropriate Uses For SQLite
(whentouse.html)
1. Situations Where SQLite Works Well
... Raw data can be imported from CSV files, then that
data can be sliced and diced to generate a myriad of summary
reports. More complex analysis can be done using simple scripts written
in Tcl or Python (both of which ...
|
|
An Introduction To The SQLite C/C++ Interface
(cintro.html)
... sqlite3_prepare() →
Compile SQL text into
byte-code that will do the work of querying or updating the database.
The constructor for sqlite3_stmt.
sqlite3_bind() →
Store application data into
parameters of the original SQL.
sqlite3_step() →
Advance an sqlite3_stmt to ...
|
|
The SQLite R*Tree Module
(rtree.html)
... Unlike regular SQLite tables which can store data in a variety of
datatypes and formats, the R*Tree rigidly enforce these storage types.
If any other type of value is inserted into such a column, the r-tree
module silently ...
|
|
SQLite Autoincrement
(autoinc.html)
... The ROWID chosen for the new row is at least one larger than the largest ROWID
that has ever before existed in that same table. If the table has never
before contained any data, then a ROWID of 1 is ...
|
|
Datatypes In SQLite
(datatype3.html)
3. Type Affinity
... If numerical data is inserted into a column with
TEXT affinity it is converted into text form before being stored.
A column with NUMERIC affinity may contain values using all five
storage classes. When text data is inserted into a ...
|
|
Recent SQLite News
(news.html)
... The ALTER TABLE command was enhanced to support renaming of columns, and
so that column and table renames are propagated into trigger bodies and views.
In addition, there are various performance enhancements and minor fixes.
One bug of note is ...
|
|
C/C++ Interface For SQLite Version 3 (old)
(capi3.html)
... The API for version 3.0 is similar to the version 2.X API,
but with some important changes. Most noticeably, the "sqlite_"
prefix that occurs on the beginning of all API functions and data
structures are changed to "sqlite3_ ...
|
|
SELECT
(lang_select.html)
... If there is more than one table or subquery in FROM clause
then the contents of all tables and/or subqueries
are joined into a single dataset for the simple SELECT statement to operate on.
Exactly how the data is ...
|
|
SQLite As An Application File Format
(appfileformat.html)
... Show me your tables, and I won't usually
need your flowcharts; they'll be obvious.
Rob Pike, in his
Rules of Programming expresses the same idea this way:
Data dominates. If you've chosen the right data structures
and ...
|
|
SQLite FTS3 and FTS4 Extensions
(fts3.html)
... Data-types specified as part of the "CREATE VIRTUAL TABLE" statement
used to create an FTS table are ignored completely. Instead of the
normal rules for applying type affinity to inserted values, all
values inserted into FTS table columns (except ...
|
Page generated by FTS5 in about 109.92 ms.