Tracking my time in MySQL
CREATE TABLE `timetracking` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`username` enum('karamfil') NOT NULL,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`window_class` varchar(50) NOT NULL,
`window_title` varchar(200) NOT NULL,
`time` smallint(4) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `username` (`username`,`date`,`time`,`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1557 DEFAULT CHARSET=utf8
pip install flask
python traktor.py
python viewer.py