OK, my stupidity, I was looking at a NSBinaryStoreType and not sqlite. Next question: is there any utility for looking inside a NSBinaryStoreType?
----- Original Message ---- From: Jens Alfke <j...@mooseyard.com> To: Chris Idou <idou...@yahoo.com> Cc: cocoa-dev@lists.apple.com Sent: Fri, 25 June, 2010 10:35:10 AM Subject: Re: accessing core data sqlite from utility 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
