Re: Learning SQLite by watching Core Data?

Hi David, We're also developing an SQLite3-based database application. Unfortunately we can't use Core Data because we're building a cross platform product. But we wanted to use Xcode's data modeler tool to design a fairly complex database model. To help us implement our application, we'r

Re: Learning SQLite by watching Core Data?

On Jun 23, 2008, at 6:13 PM, David Carlisle wrote: I'm just studying the issues so far. The sqlite version doesn't have to work just like the Core Data version, except on the surface. I'm only beginning to get a grasp of how deep the implementation differences would need to be. Assuming

Re: Learning SQLite by watching Core Data?

On 23 Jun '08, at 3:13 PM, David Carlisle wrote: As far as the filename extension, if I don't use the .sqlite extension, then sqlite3 creates an empty textfile with the same name as the database: That's what the sqlite3 tool does if you give it a filename that doesn't yet exist. This imp

Re: Learning SQLite by watching Core Data?

On Jun 23, 2008, at 2:52 PM, David Carlisle wrote: Your comments noted below are not encouraging. Sometimes the truth is discouraging :) ___ Cocoa-dev mailing list (Cocoa-dev@lists.apple.com) Please do not post admin requests or moderator comments

Re: Learning SQLite by watching Core Data?

I'm just studying the issues so far. The sqlite version doesn't have to work just like the Core Data version, except on the surface. I'm only beginning to get a grasp of how deep the implementation differences would need to be. As far as the filename extension, if I don't use the .sqlite

Re: Learning SQLite by watching Core Data?

Your comments noted below are not encouraging. I'll likely get the Definitive Guide, and perhaps study one of the Cocoa sqlite wrappers. On Jun 23, 2008, at 3:27 PM, Jens Alfke wrote: integrating raw database APIs into object-oriented apps can be very difficult because they're two very dif

Re: Learning SQLite by watching Core Data?

On 23 Jun '08, at 2:35 PM, David Carlisle wrote: 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. Whew. If you want to implement an app the same way on a no-CoreData platform, you're tal

Re: Learning SQLite by watching Core Data?

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.

Re: Learning SQLite by watching Core Data?

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 somet

Re: Learning SQLite by watching Core Data?

While Core Data technically uses SQLite, it does undocumented voodoo with SQLite, Core Data only use public SQLite API. For all intents and purposes, Core Data + SQLite should basically be considered a proprietary format. It's the same SQLite file format as on any other platform. The layout

re: Learning SQLite by watching Core Data?

David, I highly recommend these two books: Now

Re: Learning SQLite by watching Core Data?

> "Learn about Core Data structures using SQLite" != "Learn about SQLite > by examining Core Data structures". More succinct == better. :-) -- I.S. ___ Cocoa-dev mailing list (Cocoa-dev@lists.apple.com) Please do not post admin requests or moderator

Re: Learning SQLite by watching Core Data?

> In a 2005 entry on the Big Nerd Ranch Weblog titled "Life with SQLite", it > says: > > "If you are curious about how Core Data structures the file, sqlite3 is a > great way to explore it." That doesn't quite mean Core Data files are a good way to learn SQLite as you seemed to originally imply.

Re: Learning SQLite by watching Core Data?

On Mon, Jun 23, 2008 at 7:06 PM, David Carlisle <[EMAIL PROTECTED]> wrote: > I had read it was possible to study SQLite using Core Data On Mon, Jun 23, 2008 at 8:19 PM, David Carlisle <[EMAIL PROTECTED]> wrote: > In a 2005 entry on the Big Nerd Ranch Weblog titled "Life with SQLite", it > says:

Re: Learning SQLite by watching Core Data?

In a 2005 entry on the Big Nerd Ranch Weblog titled "Life with SQLite", it says: "If you are curious about how Core Data structures the file, sqlite3 is a great way to explore it." So I'm starting with just being curious about what Core Data did with my sqlite file, and I'm trying to work

Re: Learning SQLite by watching Core Data?

> Now I want to recreate the same thing using just SQLite. Pick up a good introductory book on relational (SQL) databases. What's good for one is *mostly* good for the others in terms of general design. > I don't know SQLite, and I know very little Unix. If you know SQL and you know enough "

Re: Learning SQLite by watching Core Data?

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, Cor