View Single Post
Quote:
Originally Posted by Lucas View Post
Isn't there a way to run queries against the sqlite database? I thought that was how people were getting statistics on their open projects and stuff.
My Count Database Items script gets most of its information using the AppleScript API. Only the total number of actions is retrieved with an sqlite query.

There may well be more information that can be garnered from the sqlite database cache, but it's undocumented and unsupported as far as I know. The SQL query I use for the number of actions was originally posted by Ken Case on these forums a couple years ago -- still seems to work though.

-Dennis

Last edited by Toadling; 2010-02-10 at 12:09 PM..