Re: Learning SQLite by watching Core Data?

FROM : David Carlisle
DATE : Mon Jun 23 23:35:20 2008

I am studying an application design by implementing it with Core Data, 
then studying how I would move it to a platform where only sqlite is 
available.

I appreciate the book recommendations.  I found where the Definitive 
Guide to SQLite is available as an ebook, so I might go that route. 
Otherwise it is listed for 2-5 weeks.

I'm happy with my approach.  I modified ISavant's suggested Unix 
statement, realizing I needed a .sqlite suffix after my document name 
to make it work, so that answered that question.

Ilan noted that Core Data does "undocumented voodoo" with sqlite, 
which is good to be aware of.

I think poking around with sqlite3 and browsing the sqlite header file 
suggests questions for when I buy the book.

DC

On Jun 23, 2008, at 2:14 PM, Ben Trumbull wrote:

> David,
>
> I highly recommend these two books:
>
> <http://www.amazon.com/SQL-Practical-Developers-Kaufmann-Management/dp/0122205316/ref=sr_1_8?ie=UTF8&s=books&qid=1206749658&sr=1-8

> >
>
> <http://www.amazon.com/Definitive-Guide-SQLite/dp/1590596730/ref=pd_bbs_sr_1?ie=UTF8&s=books&qid=1206749999&sr=1-1

> >
>

>> Now I want to recreate the same thing using just SQLite.  I don't 
>> know SQLite, and I know very little Unix.

>
> Why do you want to use SQLite directly ?  I don't think it's 
> currently a good fit for your self described skill level.  If you're 
> simply interested in learning, pick up those books, and maybe one or 
> two on UNIX, and hack at it.
> --
>
> -Ben