MobileRead Forums - View Single Post - Are there additionnal reading statistics available while looking in the databases?

jlemonde · 11-25-2018, 07:51 AM

Thank you for you response !

I was able to set the BookSpecificStats, which I didn't know existed.

As for the stats I was really looking for: I opened the KoboReader.sqlite database, and in the table Events, I noticed that I had a lot of 46 in the column EventType. Looking at the BLOBs in the ExtraData column, I discovered that there was a lot of other information inside, which I was not actually able to decode. But using a simple binary-to-text conversion (most probably through ASCII), I get results similar to ".............P.a.g.e.s.T.u.r.n.e.d.T.h.i.s.S.e.s. s.i.o.n......." Or excerpts much longer with sometimes some not legible characters such as ] or ÿ.
But taking into account this example, where is the number of 'pages turned this session' actually stored? Is the key of the problem to find a way to give a sense to the ContentID column?

11-25-2018, 07:51 AM	#3
jlemonde Enthusiast Posts: 45 Karma: 19864 Join Date: Sep 2018 Device: Kobo Clara HD	Thank you for you response ! I was able to set the BookSpecificStats, which I didn't know existed. As for the stats I was really looking for: I opened the KoboReader.sqlite database, and in the table Events, I noticed that I had a lot of 46 in the column EventType. Looking at the BLOBs in the ExtraData column, I discovered that there was a lot of other information inside, which I was not actually able to decode. But using a simple binary-to-text conversion (most probably through ASCII), I get results similar to ".............P.a.g.e.s.T.u.r.n.e.d.T.h.i.s.S.e.s. s.i.o.n......." Or excerpts much longer with sometimes some not legible characters such as ] or ÿ. But taking into account this example, where is the number of 'pages turned this session' actually stored? Is the key of the problem to find a way to give a sense to the ContentID column?