MobileRead Forums - View Single Post

stp · 10-31-2024, 07:55 AM

Hi,

This is not really a major issue, just curious if somebody knows the reason behind it.

In the "Activity" tab, the field that shows "Average pages per minute" is always blank for all the books I read/open (like in this image, not mine, just to illustrate what I mean).

All my books are converted to kepub using kepubify.

I have a Kobo Clara BW set up with side load mode enabled, plus I added this trigger to the KoboReader.sqlite database out of privacy concerns:

Code:

DROP INDEX IF EXISTS analytics_events_timestamp;
 
CREATE TRIGGER IF NOT EXISTS delete_analytics
after INSERT ON AnalyticsEvents BEGIN
  DELETE FROM AnalyticsEvents;
END;

I wonder if that statistic is derived from data that this trigger removes. I guess I can do the test myself by removing the trigger, but I wanted to see if any of you have a clue first.

Cheers!

10-31-2024, 07:55 AM	#1
stp Junior Member Posts: 6 Karma: 10 Join Date: May 2024 Device: none	Blank "Average pages per minute" Hi, This is not really a major issue, just curious if somebody knows the reason behind it. In the "Activity" tab, the field that shows "Average pages per minute" is always blank for all the books I read/open (like in this image, not mine, just to illustrate what I mean). All my books are converted to kepub using kepubify. I have a Kobo Clara BW set up with side load mode enabled, plus I added this trigger to the KoboReader.sqlite database out of privacy concerns: Code: DROP INDEX IF EXISTS analytics_events_timestamp; CREATE TRIGGER IF NOT EXISTS delete_analytics after INSERT ON AnalyticsEvents BEGIN DELETE FROM AnalyticsEvents; END; I wonder if that statistic is derived from data that this trigger removes. I guess I can do the test myself by removing the trigger, but I wanted to see if any of you have a clue first. Cheers!