Re: importing sqlite data into a core data "database"

2008-07-13 Thread John Velman
On Sat, Jul 12, 2008 at 08:25:39PM -0700, John Velman wrote: > Thanks, Chris, > > Using the SQLite 3 api as you suggest sounds good, but there are a couple --[snip] Thanks to all who responded. Things are much clearer now. Just a word about third party software. I didn't mean to denegrate

Re: importing sqlite data into a core data "database"

2008-07-12 Thread Jens Alfke
On 12 Jul '08, at 8:25 PM, John Velman wrote: I'd be happy to be pointed to the right documentation! I've read a few hundred pages in the past week, but haven't come across anything directly related to this. Introduction to the sqlite3 API: http://www.sqlite.org/cintro.html Full API refe

Re: importing sqlite data into a core data "database"

2008-07-12 Thread Chris Hanson
On Jul 12, 2008, at 8:33 PM, Stefan Arentz wrote: If that's OK so far, how about linking? Is Linking to the SQLite library transparent from XCode? Looks like the CoreData framework is directly linked against sqlite. That doesn't matter. If you want to use the SQLite 3 API from your app

Re: importing sqlite data into a core data "database"

2008-07-12 Thread Stefan Arentz
On Jul 12, 2008, at 11:25 PM, John Velman wrote: Thanks, Chris, Using the SQLite 3 api as you suggest sounds good, but there are a couple of things that must be obvious to the initiated, but not to me (yet). As I understand, the SQLite 3 api is a C api. Can I do C function calls directl

Re: importing sqlite data into a core data "database"

2008-07-12 Thread John Velman
See below: On Sun, Jul 13, 2008 at 12:09:13PM +1000, Steve Steinitz wrote: > Hi John, > > On 12/7/08, [EMAIL PROTECTED] wrote: > >> 1) a) generate my application in XCode, use the sqlite storage option, put >> in some dummy data, then use sqlite3 to explore the resulting schema, b) >> transform my

Re: importing sqlite data into a core data "database"

2008-07-12 Thread John Velman
Thanks, Chris, Using the SQLite 3 api as you suggest sounds good, but there are a couple of things that must be obvious to the initiated, but not to me (yet). As I understand, the SQLite 3 api is a C api. Can I do C function calls directly from Objective C? Seems plausible, since Obj C is an ex

importing sqlite data into a core data "database"

2008-07-12 Thread Steve Steinitz
Hi John, On 12/7/08, [EMAIL PROTECTED] wrote: 1) a) generate my application in XCode, use the sqlite storage option, put in some dummy data, then use sqlite3 to explore the resulting schema, b) transform my data into the new schema using sqlite3 and sql. Replace the sqlite file created by my a

Re: importing sqlite data into a core data "database"

2008-07-12 Thread Chris Hanson
On Jul 12, 2008, at 4:54 PM, John Velman wrote: So, being new to Cocoa, XCode, objective-c, How do I get my data into my new Cocoa / core data "database"? I can think of two approaches off hand: 2) writing an import routine for my application, using NSTask (?) and sqlite3. This would lik

importing sqlite data into a core data "database"

2008-07-12 Thread John Velman
This seems to be revisiting an old question, but I haven't been able to find an answer. I have an existing set of data in sqlite. To be honest, it isn't set up in the schema I'd most like, yet, but in sqlite I know how to transform it, and put it into the desired schema. I like the features core