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)