Jon Orlin's Blog

Jun 23

Omnifocus Dashboard - my php script that gives me better views into my task list

I’m a big fan of Omnifocus.  It takes a mostly GTD (Getting Things Done) approach to managing my task list.  It syncs to my mac, iPhone and iPad.   But it doesn’t give me all the dashboard views that I want.  For example, I want to see all my overdue and current tasks based on both start dates and due dates.  The Omnifocus app doesn’t offer this.  And its task list sorting is limited.

I discovered that Omnifocus keeps a SQLite database that stores a cache of the actual data.  Using this database, I was able to build a local website to gives me the views I want.

I’ve shared the code on Github here:

(My first GitHub project.)

Here’s more details from the the GitHub read me page.


Home Page Screenshot



How It Works

Omnifocus stores your data in multiple zipped XML files for quick synchronization at:

/Users/[username]/Library/Application Support/OmniFocus/OmniFocus.ofocus.

But it also stores a cache on your data in a SQLite database at:


This script reads the SQLite database and displays it on a local web browser.

If Omnifocus changes its sqlite database structure, it could break this script.

Code Libraries Used

Future Features


Mar 24

From The New Yorker 

From The New Yorker 

Mar 21

“Despite the amazingly high cost of living and the extraordinary opportunities for frittering away money, everyone in early San Francisco was supremely confident that he would soon be able to return home with an incalculable amount of gold,” the author writes in the book while describing the city decades ago. “Everything was conceived on a vast scale, and there was always plenty of cash available for any scheme that might be proposed, no matter how impossible or bizarre it seemed.” — Via Nick Bilton, , quoting from the book “The Annals of San Francisco,” about the 1840s Gold Rush.

Feb 04

Have 24-hour TV news channels had their day?

"When CNN launched in the 1980s the live capability of a satellite network was breathtaking and transformative.

Now, technological developments mean that for the most part the internet has replaced satellite links for capturing and distributing the news. At the same time, consumers have broadband links to home, office, tablet and phone. Yet the industry remains wedded to the idea of a single, linear channel. Audiences have never been convinced. Viewing figures for news channels have always been low – spiking when a big event happens. The justification for broadcasters was to have a rolling spine of coverage that could be turned to at moments of need. Increasingly, however, we turn to the internet.”

A very good article about the 24/7 TV News business, Having worked at CNN in the 1980s and 1990s, I agree their day has been over for awhile.


Jan 17

ALL the 15 products listed on this 1991 Radio Shack Ad can be done on the iPhone


Wow. Great find and article by Steve Cichon

Oct 05

“With Jobs’s approval, they preprogrammed the phone’s display to always show five bars of signal strength regardless of its true strength. …. If the radio crashed and restarted, as we suspected it might, we didn’t want people in the audience to see that,” Grignon says. “So we just hard-coded it to always show five bars.” — On Steve Job’s and the first iPhone demo at Macworld.  What you see isn’t always what is true

Sep 26

I recall that some of the real top search terms at Yahoo were for Google, Amazon, and other big websites. 

I recall that some of the real top search terms at Yahoo were for Google, Amazon, and other big websites. 

Jul 24

TIL from Tumblr that this blog just turned two.  Happy Birthday.

Apr 08

“My iPhone has 2 million times the storage of the 1969 Apollo 11 spacecraft computer. They went to the moon. I throw birds at pig houses.” — @BillMurray

Mar 27