Re: db acess
Re: db acess
- Subject: Re: db acess
- From: Andy Satori <email@hidden>
- Date: Sun, 28 Nov 2004 13:51:18 -0500
Andreas,
I hate to be the bearer of bad tidings, but right now, this is a huge
hole in the Cocoa/Objective C world. I've been fairly vocal about
this. Enterprise Objects is an old NeXT technology, one that Apple
inexplicable dropped for the Mac OS X, except in the WebObjects Java
world. I own a copy of WebObjects, and while it's a nice technology,
it's not really the answer for the converted Windows developers.
Apple does support ODBC on the Mac, so the foundation for an ADO
equivalent does exist.
In my case I got fairly lucky, the code I was porting was C++ tied to
ODBC API calls rather than ADO, so for the short term, I have simply
left the C++ classes alone (outside of fixing some Windows platform
specific implementation details in the code), and am consuming them
from Objective C via .mm files.
In the long term, I have it on my project list at work to build an ODBC
consumer framework in Cocoa using the ODBC library directly. This
project is a little ways off on the time line though. Before I get to
that, I'm having to implement a direct to PostgreSQL library.
There are some issues with the ODBC API in Cocoa, one of those is some
conflicting defines, BOOL being the first and foremost. These can be
worked around.
The remaining weakness is that the ODBC Driver Manager on OS X is the
arcane and very basic version that is part of the iODBC distribution,
however OpenLink and InterActual both provide improved interfaces with
their drivers.
If anyone is interested in establishing a project to build a
CocoaODBC.framework library, I'd be happy to provide whatever little
assistance I can around my existing busy schedule.
I would be remiss in not mentioning that the Mono Project does run on
OS X, and the System.Data / ADO.NET (1.0) namespaces are fully
functional on Mac OS X, and do provide an alternative that is young but
maturing well.
Andy Satori
On Nov 27, 2004, at 10:35 AM, Andreas Vandenberghe wrote:
Hello,
I'm experimenting in xcode at home (doing vb.net & oracle sql at work)
and i've got a question: what is the preferred database access method
for client server development ? in visual studio we've had ado for
connected access, and now ado.net, which is more for disconnected
datasets, but what do you do in xcode to connect to an Oracle or mysql
db ? I read about Webobjects but it's for web dev and not part of
Xcode.
Hasn't Apple it's own data access method ?
Thanks,
Andreas
_______________________________________________
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
Attachment:
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________
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
| References: | |
| | >db acess (From: Andreas Vandenberghe <email@hidden>) |