Logging data locally

Step data is logged into an SQLite3 database current.db. From time to time, the database is archived to yyyyMMddHHmmss.adb, and current.db is truncated. current.db and the archives are located in the Steps data directory: c:\data\steps on Symbian, ~/.steps on Meego.

Database schema:

create table log (id integer primary key, date varchar, steps integer)
create table tags (name varchar, value varchar, logid integer, foreign key(logid) references log(id))

Columns:

Name	Description
log.date	Date of log, in yyyy-mm-ddThh:mm:ss format (local time, without time zone)
log.steps	Delta step count
tags.name	Arbitrary tag name
tags.value	Tag value

Known tags:

Name	Description
activity=n	Activity n has been selected (0: walking, 1: running, 2: custom1, 3: custom2)
appStarted=com.pipacs.steps	Application with the given name has been started
appStopped=com.pipacs.steps	Application has been stopped
appVersion=x.y.z	Application version is x.y.z
counting=true/false	Counter has been started/stopped
detectedActivity=n	Detected activity n (0: idle, 1: unknown, 2: walking, 3: running)
osName=name	Operating system name, like harmattan or symbian
reset=0	All counters have been reset
resetActivityCount=0:	Current activity step count has been reset
secondsFromUtc=secs	Current time zone (as seconds from UTC)