Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Appropriate Uses For SQLite
(whentouse.html)
1. Situations Where SQLite Works Well
... the data into
an in-memory SQLite database and use queries with joins and ORDER BY
clauses to extract the data in the form and order needed rather than
to try to code the same operations manually.
Using an SQL ...
|
|
C API: Obtaining SQL Values
(c3ref/value_blob.html)
sqlite3_value_blob(), sqlite3_value_double(), sqlite3_value_int(), sqlite3_value_int64(), sqlite3_value_pointer(), sqlite3_value_text ...
... The sqlite3_value_text16() interface extracts a UTF-16 string
in the native byte-order of the host machine. The
sqlite3_value_text16be() and sqlite3_value_text16le() interfaces
extract UTF-16 strings as big-endian and little-endian respectively.
If sqlite3_value object V was initialized
using ...
|
|
Atomic Commit In SQLite
(atomiccommit.html)
6.1. Always Journal Complete Sectors
... In order to write
the changes to page 2, the underlying hardware must also rewrite the
content of pages 1, 3, and 4 since the hardware must write the complete
sector. If this write operation is interrupted by a power ...
|
|
How To Corrupt An SQLite Database File
(howtocorrupt.html)
3.1. Disk drives that do not honor sync requests
... There is no way for SQLite to
detect that either is lying and that writes might be occurring out-of-order.
However, SQLite in WAL mode is far more forgiving of
out-of-order writes than in the default rollback ...
|
|
The ON CONFLICT Clause
(lang_conflict.html)
... When the REPLACE conflict resolution strategy deletes rows in order to
satisfy a constraint, delete triggers fire if and only if
recursive triggers are enabled.
The update hook is not invoked for rows that
are deleted by the REPLACE conflict ...
|
|
Hints for Debugging SQLite
(debugging.html)
Debugging Hints
The following is a random assortment of techniques used by the
SQLite developers to trace, examine, and understand the behavior of the
core SQLite library.
These techniques are designed to aid in understanding the
core SQLite library itself ...
|
|
sqldiff.exe: Database Difference Utility
(sqldiff.html)
3. Limitations
... Normally, only the column names and their order are compared
for like-named tables before content comparison proceeds.
However, the single-table comparison option, with "sqlite_schema"
named, can be used to show or detect detailed schema differences
between a pair ...
|
|
SQLite Frequently Asked Questions
(faq.html)
... SELECT name FROM sqlite_schema
WHERE type='table'
ORDER BY name;
For indices, type is equal to 'index', name is the
name of the index and tbl_name is the name of the table to which
the index belongs. For both tables ...
|
|
C API: Compiling An SQL Statement
(c3ref/prepare.html)
sqlite3_prepare(), sqlite3_prepare_v2(), sqlite3_prepare_v3(), sqlite3_prepare16(), sqlite3_prepare16_v2(), sqlite3_prepare16_v3()
... The UTF-16 interfaces work by converting the
input text into UTF-8, then invoking the corresponding UTF-8 interface.
The first argument, "db", is a database connection obtained from a
prior successful call to sqlite3_open(), sqlite3_open_v2() or
sqlite3_open16(). The ...
|
|
Custom Builds Of SQLite
(custombuild.html)
... SQLite builds for other
operating systems do not contain a VFS by default, but the application
can register one or more at run-time.
5.0 Porting SQLite To A New Operating System
In order to port SQLite to a ...
|
Page generated by FTS5 in about 228.99 ms.