• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Learning SQLite by watching Core Data?
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Learning SQLite by watching Core Data?


  • Subject: Re: Learning SQLite by watching Core Data?
  • From: Jens Alfke <email@hidden>
  • Date: Mon, 23 Jun 2008 14:27:07 -0700


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


  • Follow-Ups:
    • Re: Learning SQLite by watching Core Data?
      • From: David Carlisle <email@hidden>
References: 
 >Learning SQLite by watching Core Data? (From: David Carlisle <email@hidden>)

  • Prev by Date: NSDateFormatter -- accepting different formats at runtime
  • Next by Date: Re: NSDateFormatter -- accepting different formats at runtime
  • Previous by thread: Re: Learning SQLite by watching Core Data?
  • Next by thread: Re: Learning SQLite by watching Core Data?
  • Index(es):
    • Date
    • Thread