Small. Fast. Reliable.
Choose any three.
Choose any three.
|
SQLite As An Application File Format
(appfileformat.html)
... SQLite is carefully tested and proven reliable. It is not
a component that needs much tuning or debugging, allowing developers
to stay focused on application logic.
Single-File Documents.
An SQLite database is contained in a single file, which is ...
|
|
JSON Functions And Operators
(json1.html)
4.1. The json() function
... json(' { "this" : "is", "a": [ "test" ] } ')
→ '{"this":"is","a":["test"]}'
|
|
The RBU Extension
(rbu.html)
1. The RBU Extension
... On the other hand, an RBU Vacuum uses more CPU than a regular SQLite
VACUUM - in one test as much as five times as much. For this reason, an RBU
Vacuum is often significantly slower than an SQLite VACUUM under ...
|
|
What If OpenDocument Used SQLite?
(affcase1.html)
... This file is a good stress-test for a text editor.
Thankfully, the file is not some obscure
binary format, but in terms of accessibility, it might as well be
written in Klingon.
First Improvement: Replace ZIP with SQLite
Let ...
|
|
File Locking And Concurrency In SQLite Version 3
(lockingv3.html)
... If all file journals are either missing
or refer to other super-journals or no super-journal at all, then the
super-journal we are testing is stale and can be safely deleted.
5.0 Writing to a database file ...
|
|
Pragma statements supported by SQLite
(pragma.html)
PRAGMA stats
... The returned information is used during testing to help
verify that the query planner is operating correctly. The format
and meaning of this pragma will likely change from one release
to the next. Because of its volatility, the behavior and ...
|
|
Write-Ahead Logging
(wal.html)
2.3. Performance Considerations
... The default strategy is to run a checkpoint once the WAL
reaches 1000 pages and this strategy seems to work well in test applications on
workstations, but other strategies might work better on different
platforms or for different workloads.
|
|
SQL Language Expressions
(lang_expr.html)
... Both GLOB and LIKE may be preceded by
the NOT keyword to invert the sense of the test. The infix GLOB
operator is implemented by calling the function
glob(Y,X) and can be modified by overriding
that function.
The ...
|
|
WAL-mode File Format
(walformat.html)
2.2. WAL-Index Hash Tables
... The largest frame number that passes
those two tests is the answer.
Each entry in the aPgno array has a single corresponding entry
in the aHash array. There are more available slots in aHash than
there are in aPgno. The ...
|
|
SQLite FTS3 and FTS4 Extensions
(fts3.html)
8.2. Querying Tokenizers
... SELECT token, start, end, position
FROM tok1
WHERE input='This is a test sentence.';
The virtual table will return one row of output for each token in the
input string. The "token" column is the text of the token. The ...
|
Page generated by FTS5 in about 120.86 ms.