Small. Fast. Reliable.
Choose any three.
Choose any three.
|
The SQLITE_DBPAGE Virtual Table
(dbpage.html)
1. Overview
... Use
the --unsafe-testing command-line option to the CLI to enable writing
to the sqlite_dbpage virtual table.
|
|
Built-in Aggregate Functions
(lang_aggfunc.html)
... Consider this test case:
CREATE TABLE t1(x REAL);
INSERT INTO t1 VALUES(1.55e+308),(1.23),(3.2e-16),(-1.23),(-1.55e308);
SELECT sum(x), decimal_sum(x) FROM t1;
The large values ±1.55e+308 cancel ...
|
|
Maintaining Private Branches Of SQLite
(privatebranch.html)
3.7. Merging Public SQLite Updates Into The Private Branch
... After resolving conflicts, many users like to compile and test the
new version before committing it to the repository. Or you can commit
first and test later. Either way, run the "fossil commit"
command to check-in the circle (5 ...
|
|
Appropriate Uses For SQLite
(whentouse.html)
1. Situations Where SQLite Works Well
... Stand-in for an enterprise database during demos or testing
Client applications typically use a generic database interface that allows
connections to various SQL database engines. It makes good sense to
include SQLite in the mix of supported databases and ...
|
|
Defense Against The Dark Arts
(security.html)
1. SQLite Always Validates Its Inputs
... SQLite is
extensively fuzz-tested to help ensure that it is resistant
to these kinds of errors.
Nevertheless, bugs happen.
If you are writing an application that sends untrusted SQL inputs
or database files to SQLite, there are additional steps ...
|
|
Imposter Tables
(imposter.html)
2.2. Transient Imposter Tables
... Imposter tables are for
analysis and testing use only.
To create a transient imposter table, first call sqlite3_test_control()
as follows:
sqlite3_test_control(SQLITE_TESTCTRL_IMPOSTER, db, "main", 1, tnum);
The "db" parameter is a pointer to the database connection.
The "main" argument is ...
|
|
Memory-Mapped I/O
(mmap.html)
... In fact,
it is possible to construct test cases where performance is reduced
by the use of memory-mapped I/O.
Windows is unable to truncate a memory-mapped file. Hence, on Windows,
if an operation such as VACUUM or ...
|
|
C API: Standard File Control Opcodes
(c3ref/c_fcntl_begin_atomic_write.html)
SQLITE_FCNTL_LOCKSTATE, SQLITE_FCNTL_GET_LOCKPROXYFILE, SQLITE_FCNTL_SET_LOCKPROXYFILE, SQLITE_FCNTL_LAST_ERRNO, SQLITE_FCNTL_SIZE_HINT, SQLITE_FCNTL_CHUNK_SIZE ...
... This capability is used during testing
and only needs to be supported when SQLITE_TEST is defined.
The SQLITE_FCNTL_NULL_IO opcode sets the low-level file descriptor
or file handle for the sqlite3_file object such that it will no longer
read or ...
|
|
Database Remote-Copy Tool For SQLite
(rsync.html)
5. Network Bandwidth
... In tests, a 500MB database will typically
synchronize with about 20KB of network traffic.
Prior to version 3.50.0 (2025-05-29), the protocol would only
send hashes of individual pages, not groups of pages. The meant that the ...
|
|
Books About SQLite
(books.html)
... The book covers basic SQL queries and how they can
be used to create a custom report that includes data from different
tables, and shows how one can use SQL queries to test hypotheses about
the relationships of data in ...
|
Page generated by FTS5 in about 132.51 ms.