Last active
December 15, 2015 09:49
-
-
Save John07/5241539 to your computer and use it in GitHub Desktop.
Export a list of your favorite podcast episodes from Instacast 2
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# get the db.sqlite file from Instacast (e.g. with iExplorer 2 http://www.macroplant.com/downloads.php) | |
# copy it on your desktop and run | |
sqlite3 db.sqlite | |
.output instacast-favorites.txt | |
SELECT FEEDS.title, EPISODES.title, EPISODES.link, datetime(EPISODES.pubdate, 'unixepoch', 'localtime'), CONSUMABLES.guid | |
FROM CONSUMABLES | |
LEFT OUTER JOIN EPISODES on CONSUMABLES.guid = EPISODES.guid | |
LEFT OUTER JOIN FEEDS on EPISODES.feed_id = FEEDS.id | |
WHERE CONSUMABLES.starred = 1; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment