• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Database Development
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Database Development


  • Subject: Re: Database Development
  • From: Andrew Carter <email@hidden>
  • Date: Sun, 23 Apr 2006 20:25:35 -0700

MySQL is well supported on OS X and is easily the best RDBMS choice. It has a full C-API that wouldn't be hard to wrap in Cocoa if that is what you wanted to do. SQLite is an excellent choice if you are doing an embedded database app. My current project builds on SQLite.

Andrew


On Apr 21, 2006, at 3:08 PM, Ondra Cada wrote:

Josh,

On 21.4.2006, at 22:36, Josh Osborne wrote:

Does Apple recommend any particular database for creating SQL based apps? Is there a Mac SQL server? Does XCode have any conventions or frameworks for interacting with SQL servers?

Yes and no. There is some SQLite support (see Core Data), and SQLite is part of Mac OS X (from 10.4 up). On the other hand, it is somewhat questionable whether SQLite can be considered a full- fledged SQL server.


If you need serious SQL power, FrontBase is probably the best course; OpenBase is said to be pretty good too, but I would very definitely select FrontBase myself. If you can bear with Java, there is an excellent hi-level generic SQL API named EOF (Enterprise Objects Framework, see WebObjects for details).

Alas, there is no decent Objective C API for generic SQL at the moment, since EOF is Java-only (although it was designed in and for Objective C, the support was removed by Apple and hardly ever will return :((( ) and Core Data is SQLite-only (that may change in future, but don't hold your breath).
---
Ondra Čada
OCSoftware: email@hidden http://www.ocs.cz
private email@hidden http://www.ocs.cz/oc



_______________________________________________
Do not post admin requests to the list. They will be ignored.
Xcode-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40inquirix.com


This email sent to email@hidden

_______________________________________________ Do not post admin requests to the list. They will be ignored. Xcode-users mailing list (email@hidden) Help/Unsubscribe/Update your Subscription: This email sent to email@hidden
  • Follow-Ups:
    • Re: Database Development
      • From: Ondra Cada <email@hidden>
    • Re: Database Development
      • From: Hayden Stainsby <email@hidden>
    • Re: Database Development
      • From: Ben <email@hidden>
References: 
 >Fwd: Database Development (From: Josh Osborne <email@hidden>)
 >Re: Database Development (From: Ondra Cada <email@hidden>)

  • Prev by Date: Re: Database Development
  • Next by Date: Re: Database Development
  • Previous by thread: Re: Database Development
  • Next by thread: Re: Database Development
  • Index(es):
    • Date
    • Thread