Analyze your Apple Calendar with SQL!
MIT License
Run full SQL queries on your calendar!
This repo contains a small script to pipe your Apple Calendar data into an SQLite database.
git clone https://github.com/skn0tt/icbu-to-sqlite /some-dir
/some-dir/cal.icbu
.Run npm i
&& node index.js
.
Run your queries on db.sqlite
!
SELECT
SUM((strftime('%s', dtend) - strftime('%s', dtstart)) / 3600) as duration,
calendar.title as calendar
FROM event
JOIN calendar ON calendar.id = calendarId
WHERE event.transp <> 'TRANSPARENT'
AND dtstart BETWEEN {{start}} AND {{end}}
GROUP BY calendarId