Objective C and Databases

Question

Level 1

0 points

Objective C and Databases

Hi all

I come from a primarily Java background and am tackling a new Mac OS X carbon application.

One thing I'm struggling with is to find any good Open Source frameworks for connecting to a database?

Forgive me for referencing Java but in Java you would load a driver up (of your choice) and use that to perform your SQL queries using the inbuilt Java classes.

Is there such a capability in Obj C and are there any useful tutorials?

I have found a few frameworks such as Baseten but all seem relatively old ?

Thanks in advance,

James

G5, Mac OS X (10.5.5)

Posted on Oct 23, 2008 4:58 AM

Reply

Answer 1

etresoft

Level 9

56,662 points

Oct 23, 2008 5:32 AM in response to eggsy84

I can't really think of any database that doesn't have a C interface. Some of the more popular ones have pre-built Objective-C interfaces that will save you a couple of hours. Then there is the Cocoa interface to SQLite known as Xcode.

Reply

Answer 2

eggsy84 Author

Level 1

0 points

Oct 23, 2008 6:32 AM in response to etresoft

Hi there

Thank you for the reply.

Having looked at SQLLite our system is going to require access to a Database server (in the past we've used Postgresql) as we need to allow multiple users to access the DB.

I have found information on iODBC that can provide access to a variety of Database Servers (required DB server download) and it looks like this might be a way forward?

Reply

Answer 3

etresoft

Level 9

56,662 points

Oct 23, 2008 7:33 AM in response to eggsy84

eggsy84 wrote:
Having looked at SQLLite our system is going to require access to a Database server (in the past we've used Postgresql) as we need to allow multiple users to access the DB.

That was just one example out of umpteen. If you like PostgreSQL, use that. You can use the libpq library or an Objective-C wrapper.

I have found information on iODBC that can provide access to a variety of Database Servers (required DB server download) and it looks like this might be a way forward?

Perhaps. It is already installed on your Mac.

Reply

Answer 4

eggsy84 Author

Level 1

0 points

Oct 23, 2008 7:38 AM in response to etresoft

Hi there

Thanks again. And thank you for the info on using libpq. The link to the Objective C wrapper has some useful code within it that should help me develop our our connecting and statements!!

Thank you.

Reply

Answer 5

eggsy84 Author

Level 1

0 points

Oct 24, 2008 3:34 AM in response to eggsy84

Hi

I have successfully implemented the Database access code using the wrapper and got it to communicate with my PostgreSQL DB server. Thank you.

So for my next trick does anyone know if there is any form of object persistence (like Hibernate for Java) that can be used with Objective C / Cocoa OS X applications?

Reply

Answer 6

Dec 14, 2008 9:46 AM in response to eggsy84

The right tool to use to create object-relational (persistence) software on the Mac is CoreData for Objective-C (Cocoa) applications and WebObjects for Java applications. WebObjects' EnterpriseObjects is the best ORM system I know. Apache's Cayenne is modelled after it.

http://developer.apple.com/tools/webobjects/

Reply

Answer 7

Dec 16, 2008 6:19 AM in response to eggsy84

There's a native ObjC database: http://code.google.com/p/entropydb/

Reply