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/c3ref/snapshot.html | 154 ++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 154 insertions(+) create mode 100644 www/c3ref/snapshot.html (limited to 'www/c3ref/snapshot.html') diff --git a/www/c3ref/snapshot.html b/www/c3ref/snapshot.html new file mode 100644 index 0000000..4a99b00 --- /dev/null +++ b/www/c3ref/snapshot.html @@ -0,0 +1,154 @@ + + + + + +Database Snapshot + + + +
+ + + +
+
+Small. Fast. Reliable.
Choose any three. +
+
+ +
+ +
+
+ + + +
+
+
+ + +
+

SQLite C Interface

 +

Database Snapshot

+
+
+typedef struct sqlite3_snapshot {
+  unsigned char hidden[48];
+} sqlite3_snapshot;
+
+

+An instance of the snapshot object records the state of a WAL mode +database for some specific point in history.

+ +

In WAL mode, multiple database connections that are open on the +same database file can each be reading a different historical version +of the database file. When a database connection begins a read +transaction, that connection sees an unchanging copy of the database +as it existed for the point in time when the transaction first started. +Subsequent changes to the database from other connections are not seen +by the reader until a new read transaction is started.

+ +

The sqlite3_snapshot object records state information about an historical +version of the database file so that it is possible to later open a new read +transaction that sees that historical version of the database rather than +the most recent version. +

1 Constructor using this object: sqlite3_snapshot_get()

+

1 Destructor using this object: sqlite3_snapshot_free()

+

3 Methods using this object: + sqlite3_snapshot_cmp(), +sqlite3_snapshot_open(), +sqlite3_snapshot_recover()

+

See also lists of + Objects, + Constants, and + Functions.

+ -- cgit v1.2.3