View Single Post
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.


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