Re: accessing core data sqlite from utility
Re: accessing core data sqlite from utility
- Subject: Re: accessing core data sqlite from utility
- From: Chris Idou <email@hidden>
- Date: Thu, 24 Jun 2010 17:57:16 -0700 (PDT)
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 <email@hidden>
To: Chris Idou <email@hidden>
Cc: email@hidden
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 (email@hidden)
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:
This email sent to email@hidden