Re: Learning SQLite by watching Core Data?

FROM : Jens Alfke
DATE : Mon Jun 23 23:27:07 2008

On 23 Jun '08, at 11:06 AM, David Carlisle wrote:

>  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.


This isn't something I'd advise unless you're extremely curious, or 
have a strong need to do a database-based app that goes beyond what 
CoreData can do. The basics of SQL aren't hard, but the learning curve 
gets steeper if you want to do enough for a real app; and integrating 
raw database APIs into object-oriented apps can be very difficult 
because they're two very different approaches to managing data. (Trust 
me, I did exactly this in my last project, and it was a ton of work.)

If you do want to learn sqlite, I highly recommend Michael Owens's 
"The Definitive Guide To SQLite" from Apress <http://www.amazon.com/Definitive-Guide-SQLite/dp/1590596730
>. It has a good introduction to SQL and to the sqlite API.

In addition to QuickLite, another good set of Cocoa sqlite wrappers is 
Gus Mueller's FMDB <http://gusmueller.com/blog/archives/2008/06/new_home_for_fmdb.html
>.

—Jens_______________________________________________

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>