Re: Biting off too much?

FROM : Ken Tozier
DATE : Tue Aug 08 12:43:00 2006

On Aug 8, 2006, at 1:27 AM, Brent Austin wrote:

> I am wanting to put together a specific cocoa app. I am a beginner 
> but I don't think I am biting off more than I can chew. What I 
> would like to do is create a database app with an interface 
> (frontend + backend) with the frontend being a form-style input 
> interface with decent security. I would like to make several of 
> these independant front/backends but also have them interfaced 
> through one main initial starting point.


I'm working on something that makes heavy use of a remote database 
and have found that the easiest thing to do is create Cocoa clients 
that use NSMutableURLRequest, NSHTTPURLResponse and  NSURLConnection 
to send queries to PHP scripts on the server. The PHP scripts take 
care of all the database interaction and eliminate the need to link 
to any database connectivity libraries in your app. This works great 
but might be a bit daunting if you have no experience with Objective-
C. If you want, I have a few Cocoa/PHP client/server classes I could 
send your way to get you started.

Alternately you could go the embedded framework route and use 
something like this "http://www.rtlabs.com/fwork/" which has some 
nifty InterfaceBuilder widgets that manage database communications. I 
experimented with this and it works pretty well although it's getting 
a bit long since the last upgrade and requires using old style 
passwords when connecting to MySQL.

Ken