SQLiteI recently started doing some iPhone dev with PhoneGap. I’m using the Simulator included with Xcode and the iPhone SDK because it makes debugging faster and easier than an actual iPhone, and also I don’t have an actual iPhone. I do have an iPod Touch, but it’s lacking a lot of the features that make mobile apps cool, so I’m stuck with the Simulator for now. At any rate, I realized quickly that having a facility to browse the Safari-created SQLite databases would simplify my life profusely.

Assuming you’re on a Mac (and I’m not sure how you’d be using the iPhone Simulator if you weren’t), the path to the Simulator’s SQLite databases is

~/Library/Application Support/iPhone Simulator/User/Library/Webkit/Databases

And to browse the .db files in there you can use the cross-platform FOSS SQLite Database Browser.

I love it when a plan comes together.