markusfisch
commented
2 years ago I see, and I was already thinking of adding the option to export the (SQLite) database. Of course, a CSV export is also possible, and it's probably the more useful format for most people.
The data is currently stored in rows with a _from and a _to column of the type TIMESTAMP. So a direct export would look more like this:
_from;_to
1655323662;1655323667Would that still be useful for you?
Although it's likely that I will need to change the type of these fields in the near future, because Unix timestamp don't go well with DST changes and things like that 😬 Working with dates (and times) is really hard 😉 So I might change the type to a proper DATETIME field, which would change the export too, of course.
Ultimately it's probably:
_from;_to
"Mi 15 Jun 2022 22:07:42";"Mi 15 Jun 2022 22:07:47"And maybe it's even necessary to add a timezone too 🤔
About the notification and the "running in the background", these are actually closely related. Android's battery optimization doesn't allow apps to run silently in the background. There are exceptions, of course, but the recommended behavior for apps that should be kept running is to show an ongoing foreground notification. This should make it clear to the user that the app is constantly running.
Which is fine for this app because I wanted to have a permanent notification anyway 😉 What doesn't mean this app is doing any work in the background. It's only ever active (and using energy) when you unlock your device.
ohhai
linesquarecube
meiji163
Why I'm asking for this: I look for phone app for automatic sleep tracking. Easiest way is to define sleep as longest time of screen turned off. Existing sleep trackers usually require manual start/stop and are overbloated for such a simple purpose. Same for phone activity trackers - they usually include apps usage analytics, time warnings, blocking of overusage, etc. So you app is very close to a perfect match. Anyone can easily implement any analyzing logic, charts and statistics in a spreadsheet table basing on data from Screen Time.
CSV seems to be an optimal export format, containing just event and its timestamp. The latter might be Unixtime, easiest to do computations with it. So it might be like following:
Additional dependency is to save history log for a long time, it is not preserved for now, as far as I see.
I believe all of that should add small overhead to code and UI (just one "export" button).
Couple of unrelated things, I can create separate issues for them if necessary:
1) As far as I see, there is no option to disable notification from Screen Time. I did it in Android system settings, but some people might miss this way. 2) I have "Screen Time is running in background" system notification on Android 8. Not sure why it appears since a lot of apps are working in background without this notification.
Paid version with that features is also an option, especially taking into account it's opensource 👍