From 63847496f14c813a5d80efd5b7de0f1294ffe1e3 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 13 Apr 2024 16:07:11 +0200 Subject: Adding upstream version 3.45.1. Signed-off-by: Daniel Baumann --- www/transactional.html | 157 +++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 157 insertions(+) create mode 100644 www/transactional.html (limited to 'www/transactional.html') diff --git a/www/transactional.html b/www/transactional.html new file mode 100644 index 0000000..101cb38 --- /dev/null +++ b/www/transactional.html @@ -0,0 +1,157 @@ + + + + + +SQLite Is Transactional + + + +
+ + + +
+
+Small. Fast. Reliable.
Choose any three. +
+
+ +
+ +
+
+ + + +
+
+
+ + + + +

SQLite is Transactional

+ +

A transactional database is one in which all changes and queries +appear to be +Atomic, Consistent, Isolated, and Durable +(ACID). +SQLite implements +serializable +transactions that are atomic, consistent, isolated, and durable, +even if the transaction is interrupted by a program crash, an +operating system crash, or a power failure to the computer. +

+ +

+We here restate and amplify the previous sentence for emphasis: +All changes within a single transaction in SQLite either occur +completely or not at all, even if the act of writing the change +out to the disk is interrupted by +

+

+ +

+The claim of the previous paragraph is extensively checked in the +SQLite regression test suite using a special test harness that +simulates the effects on a database file of operating system crashes +and power failures. +

+ +

+Additional information +

+

This page last modified on 2022-01-08 05:02:57 UTC

+ -- cgit v1.2.3