Re: Questions about Core Data and SQLite

2008-07-14 Thread Jeff Brown
Thanks guys for all this info. Also can anyone point me to a good book or website where I can learn about and how to incorporate Core Data into my existing Cocoa App. I've found mac documentation isn't the easiest to learn from. Cheers Jeff Start at the new Yahoo!7 for a better online e

Re: Questions about Core Data and SQLite

2008-07-14 Thread Chris Hanson
On Jul 14, 2008, at 9:08 PM, Jens Alfke wrote: On 14 Jul '08, at 6:05 PM, Steve Steinitz wrote: I use a little gigabit Thecus Network Drive which is just about as fast as using the internal disk. Humorously, my database currently fits in the Thecus' cache so it runs even faster. The scala

Re: Questions about Core Data and SQLite

2008-07-14 Thread Jens Alfke
On 14 Jul '08, at 6:05 PM, Steve Steinitz wrote: I use a little gigabit Thecus Network Drive which is just about as fast as using the internal disk. Humorously, my database currently fits in the Thecus' cache so it runs even faster. The scalability problem isn't the I/O speed, but the fact

Re: Questions about Core Data and SQLite

2008-07-14 Thread Colin Cornaby
You might want to look into Postgresql instead. It's much nicer than MySQL at doing desktop applications stuff, and you can even "subscribe" to rows and have the server notify you when changes occur. This makes it much easier to keep clients in sync. MySQL is not great for doing desktop app

Re: Questions about Core Data and SQLite

2008-07-14 Thread Steve Steinitz
Hi, On 14/7/08, [EMAIL PROTECTED] wrote: On Jul 14, 2008, at 8:12 AM, Chris Hanson wrote: However, managing simultaneous access by *different users* to a SQLite persistent store is slightly trickier -- they must all access the persistent store in ways that have compatible file locking.

Re: Questions about Core Data and SQLite

2008-07-14 Thread Chris Hanson
On Jul 14, 2008, at 8:12 AM, Jens Alfke wrote: Second, CoreData really isn't meant for having two clients (whether users or processes) accessing the database at once. I think it's possible to do this, but it requires extra work to get each client to detect when the other has changed the db,

Re: Questions about Core Data and SQLite

2008-07-14 Thread Jens Alfke
On 14 Jul '08, at 1:05 AM, Jeff Brown wrote: Is there any way I can incorporate Core Data into the app so that I can do away with using MySql? i.e. log into the app on one machine (using it's SQLite database) from the same app on a different machine? There are two problems with this — Fir

Re: Questions about Core Data and SQLite

2008-07-14 Thread Kyle Sluder
On Mon, Jul 14, 2008 at 4:05 AM, Jeff Brown <[EMAIL PROTECTED]> wrote: > Is there any way I can incorporate Core Data into the app so that I can do > away with using MySql? i.e. log into the app on one machine (using it's > SQLite database) from the same app on a different machine? No. Please r

Questions about Core Data and SQLite

2008-07-14 Thread Jeff Brown
Hi Guys I've got a cocoa app that is installed as a client on several machines and uses MySql as the database. Is there any way I can incorporate Core Data into the app so that I can do away with using MySql? i.e. log into the app on one machine (using it's SQLite database) from the same app o