summaryrefslogtreecommitdiff
path: root/static/netbsd/man3/sqlite3_snapshot.3
diff options
context:
space:
mode:
Diffstat (limited to 'static/netbsd/man3/sqlite3_snapshot.3')
-rw-r--r--static/netbsd/man3/sqlite3_snapshot.336
1 files changed, 36 insertions, 0 deletions
diff --git a/static/netbsd/man3/sqlite3_snapshot.3 b/static/netbsd/man3/sqlite3_snapshot.3
new file mode 100644
index 00000000..367e56a9
--- /dev/null
+++ b/static/netbsd/man3/sqlite3_snapshot.3
@@ -0,0 +1,36 @@
+.Dd January 24, 2024
+.Dt SQLITE3_SNAPSHOT 3
+.Os
+.Sh NAME
+.Nm sqlite3_snapshot
+.Nd database snapshot
+.Sh SYNOPSIS
+.In sqlite3.h
+.Vt typedef struct sqlite3_snapshot { unsigned char hidden[48]; } sqlite3_snapshot;
+.Sh DESCRIPTION
+An instance of the snapshot object records the state of a WAL mode
+database for some specific point in history.
+.Pp
+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.
+.Pp
+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.
+.Sh IMPLEMENTATION NOTES
+These declarations were extracted from the
+interface documentation at line 10446.
+.Bd -literal
+typedef struct sqlite3_snapshot {
+ unsigned char hidden[48];
+} sqlite3_snapshot;
+.Ed
+.Sh SEE ALSO
+.Xr sqlite3 3