View Single Post
Old 04-12-2017, 08:19 AM   #4
Skeeve
Zealot
Skeeve ought to be getting tired of karma fortunes by now.Skeeve ought to be getting tired of karma fortunes by now.Skeeve ought to be getting tired of karma fortunes by now.Skeeve ought to be getting tired of karma fortunes by now.Skeeve ought to be getting tired of karma fortunes by now.Skeeve ought to be getting tired of karma fortunes by now.Skeeve ought to be getting tired of karma fortunes by now.Skeeve ought to be getting tired of karma fortunes by now.Skeeve ought to be getting tired of karma fortunes by now.Skeeve ought to be getting tired of karma fortunes by now.Skeeve ought to be getting tired of karma fortunes by now.
 
Skeeve's Avatar
 
Posts: 142
Karma: 669192
Join Date: Nov 2013
Device: Kindle 4.1.1 no touch
Quote:
Originally Posted by davidfor View Post
But, the real question is how the status is stored on the device. Is it in an accessible database?
Yes. It is an accessible SQLite DB.

Query is

Code:
select
    title,
    strftime('%Y-%m-%d', datetime(opentime, 'unixepoch')) AS FINISHED
from
    books_impl
join
    books_settings
on
    id=bookid
where
    completed = 1
order by 2 desc
Filename is <mountpoint>/system/explorer-3/explorer-3.db
Skeeve is offline   Reply With Quote