RDBMS suggestions for CoreData
-
Hi everyone,
I am writing a CoreData app that will be used in a multi user
environment. I am searching for RDBMS server products provide native
Cocoa/CoreData support.
Any suggestions?
My research reveals Postgres and MySQL support seems flaky.
--
"I never look back darling, it distracts from the now", Edna Mode (The
Incredibles) -
On May 21, 2008, at 7:20 PM, Devraj Mukherjee wrote:
> I am writing a CoreData app that will be used in a multi user
> environment.
Good luck with that; CoreData doesn't support multi-user environments.
Nick Zitzmann
<http://www.chronosnet.com/> -
On 21 May '08, at 6:20 PM, Devraj Mukherjee wrote:
> environment. I am searching for RDBMS server products provide native
> Cocoa/CoreData support.
> My research reveals Postgres and MySQL support seems flaky.
Huh? I thought CoreData only worked with sqlite (and XML files.)
I don't think there's any reason to use it with a database server,
since CoreData has no multi-user support. (It caches rows as objects,
and if another client modifies the database, you'll need to implement
some mechanism to find out which rows changed and tell CoreData to
flush the corresponding objects.)
—Jens -
(Whoops, accidentally replied only to Jens at first! Sorry about that.)
Core Data builds on some of the concepts of enterprise-class database
application frameworks, such as the Enterprise Objects Framework in
WebObjects. However, make no mistake, Core Data is not an
object-relational database access framework. Instead, it uses concepts
from the database world to take application data management to a new
level.
Save yourself a lot of pain and take the above to heart. Core Data
involves a lot of machinery for things that don't have much to do with
RDBMSs. If you want a relational database, use one.
On Wed, May 21, 2008 at 9:54 PM, Jens Alfke <jens...> wrote:
>
> On 21 May '08, at 6:20 PM, Devraj Mukherjee wrote:
>
>> environment. I am searching for RDBMS server products provide native
>> Cocoa/CoreData support.
>> My research reveals Postgres and MySQL support seems flaky.
>
> Huh? I thought CoreData only worked with sqlite (and XML files.)
>
> I don't think there's any reason to use it with a database server, since
> CoreData has no multi-user support. (It caches rows as objects, and if
> another client modifies the database, you'll need to implement some
> mechanism to find out which rows changed and tell CoreData to flush the
> corresponding objects.)
>
> —Jens
>
--
- David T. Wilson
<david.t.wilson...> -
I have used postgresql's 'notify/listen' functions. If
a row changes, it reports the change back to any app
that is 'listening' for changes.
Of course, I was only using the C libraries to talk to
the backend. It was actually quite easy to create a
multi users system.
Ted
Message: 12
Date: Thu, 22 May 2008 11:20:20 +1000
From: "Devraj Mukherjee" <devraj...>
Subject: RDBMS suggestions for CoreData
To: "cocoa-dev list" <cocoa-dev...>
Message-ID:
<2d57c6570805211820q3fe7d383ta0c8f183326f4a8f...>
Content-Type: text/plain; charset=ISO-8859-1
Hi everyone,
I am writing a CoreData app that will be used in a
multi user
environment. I am searching for RDBMS server products
provide native
Cocoa/CoreData support.
Any suggestions?
My research reveals Postgres and MySQL support seems
flaky.
--
"I never look back darling, it distracts from the
now", Edna Mode (The
Incredibles)
