“Making the Invisible Visible – Techniques for Recovering Deleted SQLite Data Records” - tons of great details and a clear algorithm.

[pdf] https://conceptechint.net/index.php/CFATI/article/download/17/6