On Jun 24, 2010, at 5:02 PM, Chris Idou wrote: > I've got a core data database in sqlite format, and I thought I'd download a > utility to look inside it. But I've downloaded about 4 utilities that purport > to be able to open sqlite databases and none of them can open it, they give > errors along the lines of it being encrypted and needing a password. Can > anyone enlighten me about the situation?
Umm … that’s weird. I thought they were just regular sqlite databases. I’m pretty certain they’re not encrypted, as encryption isn’t supported in the version of sqlite built into the OS. Try using the command-line tool. Enter “sqlite3 /path/to/file”, then at the prompt type “pragma integrity_check;” including the semicolon at the end. If that doesn’t give errors, try entering “.schema” (without a semicolon!) to check the db schema, or your favorite SQL command. —Jens_______________________________________________ Cocoa-dev mailing list (Cocoa-dev@lists.apple.com) Please do not post admin requests or moderator comments to the list. Contact the moderators at cocoa-dev-admins(at)lists.apple.com Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/cocoa-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com