Re: Cocoa Newbie & MySQL
Re: Cocoa Newbie & MySQL
- Subject: Re: Cocoa Newbie & MySQL
- From: Jens Alfke <email@hidden>
- Date: Wed, 28 Apr 2010 10:35:47 -0700
On Apr 27, 2010, at 6:04 PM, Joshua Tidsbury wrote:
> The application I am going to be writing ultimately needs to access MySQL as a datastore. I'd love to go with Core Data and SQLite, but based on some reading, SQLite wouldn't be ideal if multiple clients were to be accessing the same datastore.
SQLite works fine with multiple clients — it uses file locking to support transactions and ACID properties. I’ve used it that way myself. It just doesn’t scale as well as a full server-based system, because doing locking via the filesystem is slower than doing it in memory. But this is unlikely to affect you unless you’re doing really heavy-duty stuff. On the plus side, sqlite is already installed in the OS and is a zillion times easier to maintain than mysql (since the database is just a file, with no special access/permissions issues.)
—Jens_______________________________________________
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