Re: Databasing and Cocoa
Re: Databasing and Cocoa
- Subject: Re: Databasing and Cocoa
- From: Bjoern Kriews <email@hidden>
- Date: Mon, 1 Mar 2004 22:48:53 +0100
On 29.02.2004, at 22:28, James Tichenor wrote:
Hi --
Good to hear people are working on the MySQL/Cocoa connection --
surprising it's not there already.
At one time I wrote my own Cocoa wrapper for mysql, which was fast but
limited in scope.
Then, for a rewrite of my software (specialized SQL Client) I started
using Serges SMySQL.
I am a satisfied user of SMySQL - about the only issue I find with it
is speed with large
datasets - which is why I plan to integrate my old code (I'm keeping
only an array of pointers
to MYSQL_ROWs, and produce objects on the fly while the user is
scrolling i.e. a TableView,
which suits my application, certainly not every other) into SMySQL.
While having built
an XCode project of SMySQL 2.2.1 with mysql 5.0.0 I have not yet told
Serge about it (until now)
because there are no improvements in functionality right now.
Still - as you appear unsure which way to turn I'd tune in with
somebody elses suggestions
of using webservices - you will achieve a very clean division of your
code.
Since perl is another language I'm in love with I'd skip the webobjects
part and simple
write an XML-RPC (or SOAP) service in perl where you have massive
options in database
connectivity and then use it through the WebServicesCore API or another
(recently announced here)
XML-RPC implementation.
I just implemented this for fun in my SQL Client to allow somebody to
access his database
at his web-provider who doesn't allow direct access but allows perl
CGIs.
Source (perl and objc) is available on request.
_______________________________________________
cocoa-dev mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/cocoa-dev
Do not post admin requests to the list. They will be ignored.