Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Readers > Kobo Reader

Notices

Reply
 
Thread Tools Search this Thread
Old 11-06-2013, 04:14 AM   #1
SONOiO
Junior Member
SONOiO began at the beginning.
 
Posts: 6
Karma: 10
Join Date: Nov 2013
Device: Kobo Aura
hours read - where in sqlite-Database

Hello, does someone know where to find the statistics (hours read, books read etc.) in the KoboReader.sqlite database (I own a Kobo Aura, but I suppose the database structure is the same in all models)?

Thanks, SONOiO
SONOiO is offline   Reply With Quote
Old 11-06-2013, 05:41 AM   #2
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 6,070
Karma: 6108201
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo Touch, Kobo Glo
All the Kobo devices share the same database design. The desktop app as well. Don't know about the Android based devices and apps.

What you are after is in the Event table. When a book finished books have a row with EventType=5 is added, or the EventCount is updated.

You might also need to look at EventType=1020 and 1021 rows. These seem to be open and close records for the books.

Times are recorded in the ExtraData column. Unfortunately, it is a BLOB and I don't know how it is encoded.

I have posted comments the different event types before. A search should find the list I have.
davidfor is online now   Reply With Quote
 
Advertisement
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Kobo sqlite database darkadept Kobo Reader 38 09-08-2013 09:12 PM
How to transfer bookmarks and comments to a new SQLite database mjost Kobo Reader 4 08-31-2013 04:07 AM
Sqlite database replacement instructions pholy Kobo Reader 62 10-11-2012 10:19 AM
Sqlite database clean up mapline Kobo Reader 2 08-02-2012 12:12 AM
Kobo Database Browser - SQLite JBlyth Kobo Reader 2 06-06-2010 10:27 PM


All times are GMT -4. The time now is 08:42 PM.


MobileRead.com is a privately owned, operated and funded community.