Re: Learning SQLite by watching Core Data?

FROM : Ilan Volow
DATE : Mon Jun 23 20:40:00 2008

The best way to learn SQLite is to learn SQLite and ignore Core Data 
completely. While Core Data technically uses SQLite, it does 
undocumented voodoo with SQLite, which is subject to change with any 
Apple whim at any particular moment (except on thursdays). For all 
intents and purposes, Core Data + SQLite should basically be 
considered a proprietary format.

If you want to learn SQLite, get a book or two on it, or go to their 
website. If you want a Cocoa framework that does a bit of what Core 
Data does, check out QuickLite http://www.webbotech.com/

You might also want to pick up a copy of Martin Fowler's Patterns Of 
Enterprise Application Architecture if you'd like to understand more 
about how to store and retrieve objects using relational databases http://tinyurl.com/4rvlaj

-- Ilan



On Jun 23, 2008, at 2:06 PM, David Carlisle wrote:

> I just finished my first simple Core Data Document Based 
> Application.  Four entities with multiple relationships.  Now I want 
> to recreate the same thing using just SQLite.  I don't know SQLite, 
> and I know very little Unix.  I had read it was possible to study 
> SQLite using Core Data, but I am making no progress.  The closest I 
> could get to opening my core data sqlite document with sqlite3 was 
> to try mycoredatadoc > sqlite3 in the Terminal, but permission was 
> denied.
>
> Any suggestions?
> _______________________________________________
>
> Cocoa-dev mailing list (<email_removed>)
>
> 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/<email_removed>
>
> This email sent to <email_removed>