Small. Fast. Reliable.
Choose any three.
Choose any three.
|
SQLite In 5 Minutes Or Less
(quickstart.html)
... At a shell or DOS prompt, enter: "sqlite3 test.db". This will
create a new database named "test.db". (You can use a different name if
you like.)
Enter SQL commands at the prompt to create and populate the
new ...
|
|
ALTER TABLE
(lang_altertable.html)
... When adding a column with a CHECK constraint, or a NOT NULL constraint
on a generated column, the added constraints are tested against all
preexisting rows in the table and the ADD COLUMN fails
if any constraint fails. The testing ...
|
|
The Amalgamation Versus Canonical Sources
(amalg-v-canon.html)
5. Advantages Of Building From The Amalgamation
... Why not just skip that first step
and go right to compiling the amalgamation directly?
You Know That The Amalgamation You Are Using
Has Been Testing And Vetted By The SQLite Developers
If you pull down the pre-build amalgamation ...
|
|
Architecture of SQLite
(arch.html)
... Test Code
Files in the "src/" folder of the source tree whose names begin with
test are for testing only and are not included in a standard
build of the library.
This page last modified on 2025-05-31 13 ...
|
|
The SQLite OS Interface or "VFS"
(vfs.html)
3.5. Other Example VFSes
... This shim is used during testing to verify that SQLite responds sanely
to hardware malfunctions or to other error conditions such as running out
of filesystem space that are difficult to test on a real system.
There are other VFS ...
|
|
SQLite Over a Network, Caveats and Considerations
(useovernet.html)
... Because these problems are inevitable with some usages,
but not frequent or repeatable,
it behooves application developers to not rely
on early testing success to decide
that their remote database use will work as desired.
Issues Arising with Remote Database ...
|
|
ANALYZE
(lang_analyze.html)
... This will populate the sqlite_stat1 table exactly as
it was during development and testing and ensure that the query plans
selected in the field are same as those selected during testing in the
lab. Maybe copy/paste the string generated ...
|
|
The Next-Generation Query Planner
(queryplanner-ng.html)
4.3. A Large Test Case
The test/starschema1.test
test script in the SQLite source tree shows a star-query with one
fact table and 63 dimension tables.
This test case is contrived, but it does demonstrate how the
N3 algorithm can fail unless it ...
|
|
The Lemon LALR(1) Parser Generator
(lemon.html)
2.2. Lemon Customizations Especially For SQLite
... In support of the 100% MC/DC testing goal for SQLite,
the parser code generated by Lemon has no unreachable branches,
and contains extra (compile-time selected) instrumentation useful
for measuring test coverage.
Lemon supports conditional compilation of grammar file ...
|
|
The COMPLETION() Table-Valued Function
(completion.html)
2.1. Example Usage
... Because the completion table is built into the command-line shell in order
to provide for tab-completions, you can run test queries against the
completion table directly in the command-line shell. Simply type a
query such as the ...
|
Page generated by FTS5 in about 133.22 ms.