/icbu-to-sqlite

Analyze your Apple Calendar with SQL!

Primary LanguageJavaScriptMIT LicenseMIT

icbu-to-sqlite

Run full SQL queries on your calendar!

This repo contains a small script to pipe your Apple Calendar data into an SQLite database.

Usage

  1. Clone this repository.
git clone https://github.com/skn0tt/icbu-to-sqlite /some-dir
  1. Export your calendar archive into /some-dir/cal.icbu.

  1. Run npm i && node index.js.

  2. Run your queries on db.sqlite!

Full Query 
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