Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Recovering Data From A Corrupt SQLite Database
(recovery.html)
1.1. Limitations
It is sometimes possible to perfectly restore a database that has
gone corrupt, but that is the exception. Usually
the recovered database will be defective in a number of ways:
Some content might be permanently deleted and unrecoverable.
This can ...
|
|
Database Remote-Copy Tool For SQLite
(rsync.html)
3. Limitations
The database files must both be in WAL mode, and must have the
same page-size.
While sqlite3_rsync is running, REPLICA is read-only.
Queries can be run against REPLICA while this utility is running,
just not write transactions.
Only ...
|
|
Appropriate Uses For SQLite
(whentouse.html)
2. Situations Where A Client/Server RDBMS May Work Better
... Very large datasets
An SQLite database is limited in size to 281 terabytes
(248 bytes, 256 tibibytes).
And even if it could handle larger databases, SQLite stores the entire
database in a single disk file and many filesystems limit the ...
|
|
The SQLite Amalgamation
(amalgamation.html)
3. The Split Amalgamation
... To circumvent this limitation, the amalgamation is also available in
a split form, consisting of files "sqlite3-1.c", "sqlite3-2.c", and
so forth, where each file is less than 32,768 lines in length and
where the concatenation ...
|
|
SQLite's Built-in printf()
(printf.html)
1.2. Disadvantages
... The floating-point to text conversion subfunction for the built-in printf()
is limited in precision to 16 significant digits or 26 significant digits
if the "!" alternate-form-2 flag is used.
Every IEEE-754 double can be represented exactly ...
|
|
What If OpenDocument Used SQLite?
(affcase1.html)
... SELECT manifest, versionId FROM version ORDER BY versionId DESC LIMIT 1;
Or perhaps the application would rather use the
most recent checkinTime:
SELECT manifest, versionId, max(checkinTime) FROM version;
Using a single query such as the above, the application obtains ...
|
|
An Asynchronous I/O Module For SQLite
(asyncvfs.html)
... 1.2 Limitations
In order to gain experience with the main ideas surrounding asynchronous
IO, this implementation is deliberately kept simple. Additional
capabilities may be added in the future.
For example, as currently implemented, if writes are happening at a ...
|
|
SQLite Changes From Version 3.4.2 To 3.5.0
(34to35.html)
... Each thread could have its own heap limit. Beginning
in version 3.5.0, there is a single heap limit for the entire process.
This seems more restrictive (one limit as opposed to many) but in
practice it is what ...
|
|
C API: Configuration Options
(c3ref/c_config_covering_index_scan.html)
SQLITE_CONFIG_SINGLETHREAD, SQLITE_CONFIG_MULTITHREAD, SQLITE_CONFIG_SERIALIZED, SQLITE_CONFIG_MALLOC, SQLITE_CONFIG_GETMALLOC, SQLITE_CONFIG_SCRATCH ...
... SQLITE_CONFIG_MMAP_SIZE
SQLITE_CONFIG_MMAP_SIZE takes two 64-bit integer (sqlite3_int64) values
that are the default mmap size limit (the default setting for
PRAGMA mmap_size) and the maximum allowed mmap size limit.
The default setting can be overridden by each database connection using ...
|
|
The Session Extension
(sessionintro.html)
1.3. Limitations
Prior to SQLite version 3.17.0, the session extension only worked with
rowid tables, not WITHOUT ROWID tables. As of 3.17.0, both
rowid and WITHOUT ROWID tables are supported. However, extra steps are
needed to record primary ...
|
Page generated by FTS5 in about 128.23 ms.