John07

# counts the number of open tasks in Wunderlist across all lists 
# (pretty sure there's a more elegant way of doing this but works for now)
sqlite3 "/Users/USERNAME/Library/Containers/com.wunderkinder.wunderlistdesktop/Data/Library/Application Support/Wunderlist/WKModel.sqlite" "select ZTITLE from ZRESOURCE where ZOWNER1 is not 1 and ZPARENTTASK is null and ZCOMPLETEDAT is null" | wc -l

John07

sqlite3 backup-catalog.lrcat
.output export.txt

-- get all keywords with their id
SELECT id_local, name FROM AgLibraryKeyword;

-- get list of all files with keyword id 88890
SELECT stackParent_fileName, stackParent____colorLabels, rating FROM Adobe_images AS a JOIN AgLibraryKeywordImage AS b WHERE b.tag=88890 AND a.id_local=b.image;

-- get list of all files for keyword Bob

John07

<xsl:transform xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">

	<xsl:output method="text" indent="no" encoding="utf-8" />

	<xsl:template match='text()|@*' />

	<xsl:template match="event">
|-		
| ? || ? || FOSSGIS2011-<xsl:value-of select="@id" />-<xsl:value-of select="normalize-space(language)" /><xsl:if test="not(normalize-space(language))">de</xsl:if>-<xsl:value-of select="slug" /> || <xsl:value-of select="title" /> || <xsl:for-each select="persons/person"><xsl:value-of select="." /><xsl:text> </xsl:text></xsl:for-each> || <xsl:value-of select="../../@date" /><xsl:text> </xsl:text><xsl:value-of select="start" /> || <xsl:value-of select="room" /> 
    </xsl:template>

John07

<xsl:transform xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">

	<xsl:output method="text" indent="no" encoding="utf-8" />

	<xsl:template match='text()|@*' />

	<xsl:template match="event">
FOSSGIS2011-<xsl:value-of select="@id" />-<xsl:value-of select="normalize-space(language)" /><xsl:if test="not(normalize-space(language))">de</xsl:if>-<xsl:value-of select="slug" />;<xsl:value-of select="title" />;<xsl:for-each select="persons/person"><xsl:value-of select="." /><xsl:text> </xsl:text></xsl:for-each>; <xsl:value-of select="../../@date" /><xsl:text> </xsl:text><xsl:value-of select="start" />;<xsl:value-of select="room" />
    </xsl:template>

John07

…
webView <WebView: 0x102050190> didCommitLoadForFrame <WebFrame: 0x1181b4bd0>
identifierForInitialRequest request: <NSMutableURLRequest https://plusone.google.com/_/apps-static/_/ss/plusone/ver=-yf4rtzu2qv6i/am=!QiLm8C5UadSNAbdIjAs/bf=BA/r=O/rs=AItRSTPBu5k2X1PY5oo7Zv2WE0tHa20H2g> dataSource: <WebDataSource: 0x11817bf90> (resource id: 165)
didFinishLoadingFromDataSource identifier: 151 dataSource: <WebDataSource: 0x11817bf90>
didFinishLoadingFromDataSource identifier: 159 dataSource: <WebDataSource: 0x118183e10>
webView <WebView: 0x102050190> didCommitLoadForFrame <WebFrame: 0x1181923f0>
webView <WebView: 0x102050190> didFinishLoadForFrame <WebFrame: 0x1181923f0>, parentFrame: <WebFrame: 0x1030ad4b0>
didFinishLoadingFromDataSource identifier: 150 dataSource: <WebDataSource: 0x1181af6f0>
didFinishLoadingFromDataSource identifier: 149 dataSource: <WebDataSource: 0x10304a400>
webview <WebView: 0x102050190> didStartProvisionalLoadForFrame <WebFrame: 0x118168d50>

John07

# location of the Wunderlist 2 database (App Store version)
~/Library/Containers/com.wunderkinder.wunderlistdesktop/Data/Library/Application Support/Wunderlist/WKModel.sqlite

# example
# get title of all tasks in list 400
sqlite3 WKModel.sqlite "SELECT rowid, ZTITLE FROM ZRESOURCE WHERE ZTASKLIST = 400 ORDER BY rowid;"

John07

# 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;

John07

# read a podcast mp3 file and print a list of its chapter marks
ffprobe -v quiet -show_chapters -pretty -print_format csv *.mp3

# more readable, timestamps with seconds
ffprobe -v quiet -show_chapters -pretty -print_format csv *.mp3 | awk -F "," '{print $5 " " $7 " " $8}' | sed 's/\.[0-9]*\ /\ /g'

# more readable, timestamps without seconds
ffprobe -v quiet -show_chapters -pretty -print_format csv *.mp3 | awk -F "," '{print $5 " " $7 " " $8}' | sed 's/\:[0-9][0-9]\.[0-9]*\ /\ /g'

John07

--
-- open currently active Chrome tab with Safari
-- forked from https://gist.github.com/3151932 and https://gist.github.com/3153606
--
property theURL : ""
tell application "Google Chrome"
  set theURL to URL of active tab of window 0
end tell

if appIsRunning("Safari") then

John07

#!/bin/bash
URL=$(pbpaste)
curl "$URL" --insecure --write-out %{redirect_url}