thunderbird-calendar-events-sqlite

Emergency plan if Thunderbird is stuck and you still need to partecipate to conference calls!

Copy your calendar-data

Since it's locked you can't open your SQLite database while TB is running:

cd ~/.thunderbird/XXXXXXXXXX.default/calendar-data
cp local.sqlite /tmp/

Fetch events using SQLite Browser

Open SQLite Browser:

sqlitebrowser /tmp/local.sqlite

Execute the query:

SELECT
	`cal_events`.`title`,
	/* localtime should be `event_start_tz` and `event_end_tz` */
	DATETIME(SUBSTR(`cal_events`.`event_start`, 0, (LENGTH(`cal_events`.`event_start`)-5)), 'unixepoch', 'localtime') AS `event_start`,
	DATETIME(SUBSTR(`cal_events`.`event_end`, 0, (LENGTH(`cal_events`.`event_end`)-5)), 'unixepoch', 'localtime') AS `event_end`,
	`cal_properties`.`value`
FROM
	`cal_events`,
	`cal_properties`
WHERE
	`cal_events`.`event_start` > (STRFTIME('%s', 'now', 'start of day')*1000000) AND
	`cal_events`.`event_end` < (STRFTIME('%s', 'now', 'start of day', '+1 day')*1000000) AND
	`cal_properties`.`key` = 'DESCRIPTION' AND
	`cal_properties`.`item_id` = `cal_events`.`id`
;