Re: PostgreSQL and Objective-C
Re: PostgreSQL and Objective-C
- Subject: Re: PostgreSQL and Objective-C
- From: Andy Satori <email@hidden>
- Date: Sat, 16 Apr 2005 11:24:24 -0400
Let me preface this with a disclaimer. I'm the instigator and primary
developer behind the PostgreSQL for Mac project on SourceForge. I
really view the state of data access as weak, at best, on Mac OS X.
MSSQL isn't the best product on the market, but it the most accessible
to the bulk of the developers in the world, so it is well known,
documented and used.
PostgreSQL presents all of the power but lacks the tools and
documentation, nice, easy to install packages, and more importantly,
nice easy to use classes to get to your data. That's why I started the
PostgreSQL for Mac project (
http://sourceforge.net/projects/pgsqlformac/ ), so I suggest taking my
statements with a healthy dose of salt.
When it comes to accessing a PostgreSQL database there are several
options available to you:
(-) You could use PostgreSQL via ODBC if you are more comfortable with
that
interface, but ODBC and ObjectiveC can be a little bit ugly.
(-) You could user PostgreSQL via the JDBC driver layer and the Java
Bridge.
(-) You could purchase an unsupported copy of WebObjects 4.x and use
the now
unsupported Enterprise Object Frameworks.
(-) You could use one of the open source reimplementations of EOF.
(-) You could simply use the libpq 'C' API.
(-) You could use one of the various Objective C wrappers around libpq.
The only advice I'll give you is that your choice is going to need to
account for the needs of your project. With the BSD license that
PostgreSQL is under, I wanted my projects to retain that flexibility,
so that ruled out both of the EOF implementation ideas. I did some
testing with the JDBC implementation, and while it's excellent for EJB
and J2EE solutions, it really didn't make for easily maintained code
mixing languages like that. ODBC worked, but managing ODBC on Panther
is a little painful, and using it can be worse, but I do have a couple
of inhouse projects implemented that way simply for the flexibility of
bouncing between MSSQL and PostgreSQL as I migrate some of those
projects. That left me in one of the two final options. I elected to
use libpq and build my own Objective C Framework for the foundation of
the GUI tools. It's incomplete, but usable, but more importantly for
my needs, it is also BSD licensed.
This may not provide much direction, but it gives you several options,
and only you can determine which suites your needs best.
Andy
On Apr 15, 2005, at 2:54 PM, Shreffler wrote:
I am brand-spanking new to Objective-C and OS X, but have been a
developer for many years.
I'm looking for some information on how to connect to PostgreSQL from
Objective-C. Other references related to Objective-C and RDBMS
connectivity would be helpful and very much appreciated.
Best Regards,
Colin
________________________________________________________________
Sent via the WebMail system at warp9software.com
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Cocoa-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Cocoa-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden