free list
The list of pages inside an SQLite database file that are no longer in use and are waiting to be reused.
In more detail
When rows are deleted, SQLite by default neither shrinks the file nor erases the old bytes; it adds emptied pages to this list, so deleted data can often be recovered by reading the raw file. The secure_delete setting overwrites deleted content with zeros, and the vacuum command rebuilds the file without the unused pages. The fast option of secure_delete only overwrites where it costs no extra disk writes, so data may still survive in free pages.
Examples
PRAGMA secure_delete=ONsecure_delete OFF: rows visible 0, note still in file: TruePRAGMA freelist_count;Related terms
- SQLite — A small relational database that runs as a library inside your program and keeps the whole database in one file.
- overwriting — Replacing stored data by writing new data, such as zeros or random bytes, over the same storage locations.
- media sanitisation — Making data on a storage device impossible to recover, to a chosen level of effort, before the device is reused, sold or thrown away.
- PRAGMA — A SQLite statement that reads or changes a setting of the database library or of the current connection.
Taught in
- Asset Lifecycle Management & Media Sanitization — Cybersecurity Fundamentals, GRC & Cryptography