Small. Fast. Reliable.
Choose any three.
Choose any three.
|
Dynamic Memory Allocation In SQLite
(malloc.html)
2. Testing
Most of the code in the SQLite source tree is devoted purely to
testing and verification. Reliability is important to SQLite.
Among the tasks of the test infrastructure is to ensure that
SQLite does not misuse dynamically allocated memory, that ...
|
|
Swarmvtab Virtual Table
(swarmvtab.html)
1. Overview
... Database URITable nameMinimum rowidMaximum rowid
test.db1 t1 0 10
test.db2 t2 11 20
test.db3 t1 21 30
test.db4 t1 31 40
and the user queries the swarmvtab table for the row with rowid value
25. The ...
|
|
C API: OS Interface Object
(c3ref/vfs.html)
sqlite3_syscall_ptr(), struct sqlite3_vfs
... The flags argument to xAccess() may be SQLITE_ACCESS_EXISTS
to test for the existence of a file, or SQLITE_ACCESS_READWRITE to
test whether a file is readable and writable, or SQLITE_ACCESS_READ
to test whether a file is at least readable. The SQLITE_ACCESS_READ ...
|
|
The SQLite Zipfile Module
(zipfile.html)
3.1. Table-Valued Function (read-only access)
... For example, to inspect the contents of zip archive "test.zip" from
the current directory:
SELECT * FROM zipfile('test.zip');
Or, from the SQLite shell tool (the readfile()
function reads the contents of a file from the file-system and ...
|
|
Internal Versus External BLOBs
(intern-v-extern-blob.html)
... For each test case, a database was created containing 100MB of BLOB
content. The sizes of the BLOBs ranged from 10KB to 1MB. The number
of BLOBs varied in order to keep the total BLOB content at about 100MB.
(Hence ...
|
|
C API: Report the internal text encoding state of an sqlite3_value object
(c3ref/value_encoding.html)
sqlite3_value_encoding()
... This routine is intended for used by applications that test and validate
the SQLite implementation. This routine is inquiring about the opaque
internal state of an sqlite3_value object. Ordinary applications should
not need to know what the internal state of ...
|
|
The INDEXED BY Clause
(lang_indexedby.html)
... The INDEXED BY clause is designed to help detect
undesirable query plan changes during regression testing.
Application
developers are admonished to omit all use of INDEXED BY during
application design, implementation, testing, and tuning. If
INDEXED BY is to be ...
|
|
SQLite Older News
(oldnews.html)
... 2009-07-25 - 100% Branch Test Coverage
A subset of the TH3 test suite was measured by gcov to provide
100% branch test coverage over the SQLite core
(exclusive of the VFS backend and of extensions such as FTS3 and ...
|
|
SQLite Frequently Asked Questions
(faq.html)
... Most of the SQLite code base is devoted purely to testing.
The SQLite test suite runs tens of thousands of separate test cases and
many of those test cases are parameterized so that hundreds of millions
of tests involving billions ...
|
|
Measuring and Reducing CPU Usage in SQLite
(cpu.html)
2.2. Workload
... Of course, every application is different, and so
no test program can exactly mirror the behavior of all applications.
The speedtest1.c program is updated from time to time as the SQLite
developers' understanding of what constitutes "typical" usage evolves ...
|
Page generated by FTS5 in about 121.99 ms.