8. Testing Atomic Commit Behavior The developers of SQLite are confident that it is robust in the face of power failures and system crashes because the automatic test procedures do extensive checks on the ability of SQLite to recover from simulated power loss. We call ... 

 ... Disable the lookaside memory allocator When looking for memory allocation problems (memory leaks, use-after-free errors, buffer overflows, etc) it is sometimes useful to disable the lookaside memory allocator then run the test under valgrind or MSAN or some ... 

 ... No claim of copyright is made on any part of the core source code. (The documentation and test code is a different matter - some sections of documentation and test logic are governed by open-source licenses.) All contributors to the ... 

3. The BETWEEN Optimization  ... Thus if the BETWEEN term ends up being used as an index constraint no tests are ever performed on that term. On the other hand, the virtual terms themselves never causes tests to be performed on input rows. Thus if ... 

 ... When using SQLite as a shared library, an application can test to see whether or not mutexes have been disabled using the sqlite3_threadsafe() API. Applications that link against SQLite at run-time and use SQLite from multiple threads should probably ... 

1. Overview  ... Nevertheless, it is strongly recommended that the SQLite test-suite be executed to check for errors before using an SQLite library built with non-standard compilation options.

2. Virtual Tables  ... Used as part of the SQLite test suite. templatevtab A template virtual table implementation useful as a starting point for developers who want to write their own virtual tables unionvtab An experimental module providing on-demand read-only access to ... 

SQLite Download Page Source Code sqlite-src-3500100.zip(13.72 MiB) Complete canonical source tree for SQLite version 3.50.1, include test cases and extensions. This is a snapshot of all code under version control at the time ... 

4. When To Use WITHOUT ROWID  ... So it is a simple matter to run experiments on an application, late in the development cycle, to test whether or not the use of WITHOUT ROWID tables will be helpful. A good strategy is to simply not worry about ... 

2.2. Additional build documentation See the src/tcl-extension-testing.md document in the SQLite sources for step-by-step instructions on how the SQLite extension for TCL is tested. That document might provide further hints on how to build the SQLite extension for ...