Small. Fast. Reliable.
Choose any three.
Choose any three.
|
SQLite Version 3 Overview
(version3.html)
... To further support this capability, commits of transactions involving
two or more ATTACHed database are now atomic.
Credits
SQLite version 3.0 is made possible in part by AOL developers
supporting and embracing great Open-Source Software.
This page last ...
|
|
Why SQLite Uses Bytecode
(whybytecode.html)
3.2. Dataflow Programs Are Easy To Parallelize
... The primary focus of SQLite is transaction processing
(OLTP)
on the internet-of-things, so there is less need to
represent prepared statements as dataflow programs in SQLite.
This page last modified on 2025-05-09 15:56:17 UTC
|
|
Profiling SQL Queries
(profile.html)
5. Low-Level Profiling Data
... 0 0 output=r[6]
17 0.01% 1 Halt 0 0 0 0
18 0.0% 1 Transaction 0 0 1 0 1 usesStmtJournal=0
19 0.0% 1 Integer 5 4 0 0 r[4]=5 ...
|
|
How SQLite Is Tested
(testing.html)
8.5. Journal Tests
One of the things that SQLite does to ensure that transactions
are atomic across system crashes and power failures is to write
all changes into the rollback journal file prior to changing the
database. The TCL test harness contains an ...
|
|
Appropriate Uses For SQLite
(whentouse.html)
3. Checklist For Choosing The Right Database Engine
... But in most cases, a write transaction only takes milliseconds and
so multiple writers can simply take turns. SQLite will handle
more write concurrency than many people suspect. Nevertheless,
client/server database systems, because they have a long-running
server ...
|
|
TH3
(th3.html)
1. Overview
... test."
TH3 checks SQLite's response to out-of-memory errors, disk I/O
errors, and power loss during transaction commit.
TH3 exercises SQLite in a variety of run-time configurations
(UTF8 vs UTF16, different pages sizes, varying journal modes ...
|
|
The C language interface to SQLite Version 2
(c_interface.html)
... If a transaction is active when the database is closed, the transaction
is rolled back.
1.3 Executing SQL statements
The sqlite_exec function is used to process SQL statements
and queries. This function requires 5 parameters as follows:
A pointer ...
|
|
SQLite Session Module C/C++ Interface
(session.html)
... All changes made by these functions are enclosed in a savepoint transaction.
If any other error (aside from a constraint failure when attempting to
write to the target database) occurs, then the savepoint transaction is
rolled back, restoring the target ...
|
|
The RBU Extension
(rbu.html)
1. The RBU Extension
... Both of the RBU functions may be accomplished using SQLite's built-in
SQL commands - RBU update via a series of INSERT, DELETE and
UPDATE commands within a single transaction, and RBU vacuum by a single
VACUUM command. The RBU ...
|
|
SQLite FTS5 Extension
(fts5.html)
6.1. The 'automerge' Configuration Option
... Each time a new transaction is
committed, a new b-tree containing the contents of the committed transaction
is written into the database file. When the full-text index is queried, each
b-tree must be queried individually and the ...
|
Page generated by FTS5 in about 106.59 ms.