How to Kill a 35 GB SQLite Database: Rethinking Pagination Without Offset

Tweet author here:

Apparently the poster wants to provide the context what circumstances lead to the problem and further down how to solve it.