Updated: 2022/Sep/29
Please read Privacy Policy. It's for your privacy.
SQLITE3_WAL_AUTOCHECKPOINT(3) Library Functions Manual NAME sqlite3_wal_autocheckpoint - configure an auto-checkpoint SYNOPSIS #include <sqlite3.h> int sqlite3_wal_autocheckpoint(sqlite3 *db, int N); DESCRIPTION The sqlite3_wal_autocheckpoint(D,N) is a wrapper around sqlite3_wal_hook() that causes any database on database connection D to automatically checkpoint after committing a transaction if there are N or more frames in the write-ahead log file. Passing zero or a negative value as the nFrame parameter disables automatic checkpoints entirely. The callback registered by this function replaces any existing callback registered using sqlite3_wal_hook(). Likewise, registering a callback using sqlite3_wal_hook() disables the automatic checkpoint mechanism configured by this function. The wal_autocheckpoint pragma can be used to invoke this interface from SQL. Checkpoints initiated by this mechanism are PASSIVE. Every new database connection defaults to having the auto-checkpoint enabled with a threshold of 1000 or SQLITE_DEFAULT_WAL_AUTOCHECKPOINT pages. The use of this interface is only necessary if the default setting is found to be suboptimal for a particular application. IMPLEMENTATION NOTES These declarations were extracted from the interface documentation at line 9441. SQLITE_API int sqlite3_wal_autocheckpoint(sqlite3 *db, int N); SEE ALSO sqlite3(3), sqlite3_wal_checkpoint_v2(3), sqlite3_wal_hook(3) NetBSD 10.99 August 24, 2023 NetBSD 10.99