Jon Gibbins dotjay

To open SQLite Things.app database run this command in Terminal.app:

$ sqlite3 ~/Library/Containers/com.culturedcode.things/Data/Library/Application\ Support/Cultured\ Code/Things/ThingsLibrary.db

In SQLite command-line type this query to get your tasks stats:

sqlite> .mode column
sqlite> .header on
sqlite> select zscheduler, zstatus, ztrashed, count(*) from ZTHING where z_ent = 13 group by  zstatus,ztrashed order by Z_pk desc;

ZSCHEDULER ZSTATUS ZTRASHED count(*)

	property defaultAccountName : "iCloud"
	property defaultFolderName : "Saved iCloud Tabs"

	global html
	global processedURLs

	on appendLineWithURLItem(urlItem)
	my appendHTML(" <li>")
	my appendHTML("<a href=\"" & \|url\| of urlItem & "\">")
	my appendHTML(\|Title\| of urlItem)

	<!DOCTYPE html>
	<html lang="en">
	<head>
	<meta charset="utf-8">
	<meta http-equiv="X-UA-Compatible" content="IE=edge">
	<title></title>
	<meta name="description" content="">
	<meta name="author" content="Todd Kloots">

	<style type="text/css">

	- (UIAccessibilityTraits)accessibilityTraits
	{
	UIAccessibilityTraits traits = UIAccessibilityTraitButton \| UIAccessibilityTraitAllowsDirectInteraction \| UIAccessibilityTraitStaticText;

	if (self.disabled == YES)
	{
	traits = traits \| UIAccessibilityTraitNotEnabled;
	}

	return traits;

	// $('img.photo',this).imagesLoaded(myFunction)
	// execute a callback when all images have loaded.
	// needed because .load() doesn't work on cached images

	// Modified with a two-pass approach to changing image
	// src. First, the proxy imagedata is set, which leads
	// to the first callback being triggered, which resets
	// imagedata to the original src, which fires the final,
	// user defined callback.

	if (typeof window.localStorage == 'undefined' \|\| typeof window.sessionStorage == 'undefined') (function () {

	var Storage = function (type) {
	function createCookie(name, value, days) {
	var date, expires;

	if (days) {
	date = new Date();
	date.setTime(date.getTime()+(days2460601000));
	expires = "; expires="+date.toGMTString();

	#!/bin/bash
	FROM=$1
	TO=$2
	echo "Spliting '$TO' from '$FROM'"
	git clone --no-hardlinks $FROM $TO
	cd $TO
	git filter-branch --prune-empty --subdirectory-filter $TO HEAD -- --all
	git reset --hard
	git gc --aggressive
	git prune