Re: Questions about Core Data and SQLite
Re: Questions about Core Data and SQLite
- Subject: Re: Questions about Core Data and SQLite
- From: Jens Alfke <email@hidden>
- Date: Mon, 14 Jul 2008 08:12:39 -0700
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 —
First, sqlite isn't a db server like MySQL. It's an in-process library
that directly manipulates the database file. It's possible to write a
server around sqlite, that will respond to SQL queries over a socket
(and I think it's been done) but the API to use such a server wouldn't
look like the sqlite API, so you wouldn't be able to get CoreData to
use it.
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, and invalidate its caches.
—Jens
Attachment:
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________
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