Manual Page Result
0
Command: sqlite3_snapshot | Section: 3 | Source: NetBSD | File: sqlite3_snapshot.3
SQLITE3_SNAPSHOT(3) FreeBSD Library Functions Manual SQLITE3_SNAPSHOT(3)
NAME
sqlite3_snapshot - Database Snapshot
SYNOPSIS
typedef struct sqlite3_snapshot { unsigned char hidden[48]; }
sqlite3_snapshot;
DESCRIPTION
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.
SEE ALSO
sqlite3(3)
FreeBSD 14.1-RELEASE-p8 December 19, 2018 FreeBSD 14.1-RELEASE-p8