Stream of subconsciousness...

(Update database to v1.1 on 11/30/09 at 11:49AM)

It contains all alphanumeric messages from the WikiLeaks 9/11 dataset as an SQLite3 database:

911.wikileaks.org.sqlite3db_v1.1.zip, 14MB (uncompressed: 44MB)

There are three tables - textTable (main), emailTable and urlTable - with the following schemas:

• textTable: timestamp DATETIME, service TEXT, senderID INTEGER, text TEXT, key INTEGER PRIMARY KEY
• emailTable: address TEXT, domain TEXT, textKey INTEGER, key INTEGER PRIMARY KEY
• urlTable: url TEXT, textKey INTEGER, key INTEGER PRIMARY KEY

Notes:

• The textKey fields are pointers to the primary key (key) of an entry in the textTable table.
• For the senderID field, a string of all zeros is a translation from the same number of question marks in the original message, as I wanted this field to be integer typed.

More to come, including: the script used for generating this database (GitHub project), a more robust script and database (added in v1.1 update on 11/30/09) that will include email and URL lookup tables, and hopefully some cool analysis of all this amazing data.

Lastly: it turns out that this Jeff Clark guy has already done a bunch of analysis along the lines of what I thinking about doing, and it’s great stuff. In any case, hopefully this database will make things a tad easier for others wishing to do interesting analysis of their own.

I’ve spent days reading post after post after post after post that purported to solve the mystery of how to hook up the magic pieces just right to enable files to be dropped onto your app’s icon.

However, since none of the links I trawled included both up-to-date and complete examples, I figured I’d put one together for whoever has to fight this battle in the future. Caveat emptor, but really, it’s as simple as hell, so you can’t go wrong.

DockDrop.zip, 19KB, version 1.0 - GitHub

If you’re interested, the nitty gritty magic bits that need be plumbed up just right:

• Make sure your delegate implements NSApplicationDelegate, and that it is set as the delegate of NSApp.
• Implement application:openFile: in said delegate.
• Ensure you have a proper CFBundleDocumentTypes entry in your app’s Info.plist (see the example’s plist).

Update: Farktronix replied with some interesting information about some serious Dock shenanigans that Google is using with the Chrome browser.