Skip to content

Glossary

SQLite freelist

The list of whole database pages that SQLite no longer uses and keeps for reuse, often with their old content still in place.

When a page no longer holds any row, SQLite puts it on the freelist, reachable from the database header through trunk pages (file format). Its bytes are not cleared by default, so a freelist page can still contain every notification that used to live on it. The parser scans freelist pages and labels what it recovers there. See recovering deleted notifications.