hours read - where in sqlite-Database

SONOiO · 11-06-2013, 03:14 AM

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

davidfor · 11-06-2013, 04:41 AM

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.

11-06-2013, 03:14 AM	#1
SONOiO Junior Member 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

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

11-06-2013, 04:41 AM	#2
davidfor Grand Sorcerer Posts: 24,907 Karma: 47303748 Join Date: Jul 2011 Location: Sydney, Australia Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos	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.