Cocoa and ODBC

Its being a long time I have not come here to write... and it has been a long journey since a nice tool come to the desktop to connect a relational database with Cocoa (inside OSX). Since the introduction of the Core Data framework, some years after the deprecation of Objective-C version of EOF, it became a bit of a nightmare to connect an app to a Relational Data Base (as may be Sybase or Oracle)... some attempts to rewrite EOF has been done, e.g. in Alex' Open EOF by Martin

The aim of this new attempt is to use the following mixture: The Odbc Framework is a Cocoa framework providing access to ODBC data sources. It works on top of the iODBC Framework which is a widely portable C-oriented framework that follows the ODBC specification (Open Database Connectivity). The Odbc Framework includes a Cocoa Core Data Persistent Store for Odbc, which will be used here. And finally, we will use as persistence the proposed database Mimer SQL  (: which has a free version for developers :)

Alex's EOModeler

The good news about AJRDatabase is that the compiled version at SourceForge simply runs on Leopard. For, simply copy the EOModeler application to your ~/Developer/Applications folder, the AJRFoundation, AJRInterface, EOAccess and EOControl frameworks to your ~/Library/Frameworks folder, and the Postgres eoadaptor to your ~/Library/Database Adaptors folder... if you have a running Postgres database, you will be able to connect and reverse engine it after double-clicking on Alex's tool.

Nice work!!!

Now I will need to find or develop a Sybase eoadaptor... I hope it is not another nightmare...

My PowerBook died

After fighting with the installation of GNUstep, and just before the national summit of combinatorics in Hermosillo, Sonora, my old Power Book suicide by dropping itself from my bed to the floor...
Since I had to give a talk during the summit, I'd run to the shop and bought a new Intel 2.4 MacBook. While reinstalling everything in it, I received a nice link in the EOF mail-list at omnigroup: GNUstepWeb.
A nice installer with compiled binaries for Tiger and Leopard can be found there at the time, and after an easy install procedure, an Xcode template for a web-app can be found by the new-project wizard... however I tried the link today but, either the server is down, or the page disappear, or something went wrong... so I decided to share the Leopard version in my public folder: MyGNUstepWeb.
The next step is to code a Sybase adaptor...

no GDL2 on macports

I was able to install all dependencies of GDL2, but GDL2 it self... macports was unable to load it from nowhere...
also, I'd try to run an app from gnustep (Grom to be precise) and it simply did not started...

...all this GNUstep thing was driving me crazy, so I went to my office at ENSA and start all over, but in my Tiger Server (10.4.11)... there the history was completely different: instead of using macports, I downloaded directly from GNUstep ftp server gnustep-make, gnustep-base and gnustep-dl2, apply a couple of patches provided by Adam Fedor (Mil Gracias ;^) and now GDL2 is installed...

NeXT Step: learn how to integrate it with Cocoa...

gcc42 done...

Finally, I got the desired:
---> Staging gcc42 into destroot
---> Installing gcc42 @4.2.4_1+darwin_7
---> Activating gcc42 @4.2.4_1+darwin_7
---> Cleaning gcc42
Fermat:/opt/local/var/macports sa$

In the meanwhile I found the following comment on the web:
>> ---> Building gcc42 with target all
>>
>> So all is going well until this line showed up and is taking absolute
>> age....what should I do? should I terminate it and try again?
>
> gcc42 takes about 6 hours to compile on a 1.5 GHz PowerBook G4, so
> on your 1 GHZ PowerBook G4 I would expect it to take about 9 hours.
> You should also have at least 3GB of free hard drive space.
So, in my 400 MHz PowerBook G3 I supposed it will take forever... but it took just a finite amount of time!

Today I will try to end the installation of GDL2...

GNUstep DL2

At the same time I am trying ARJDatabase in the office, I am trying to install GNUstep-DL2 into my PowerBook; however, several errors had occurred —I wonder why all these open projects are so difficult to make...

One needed step is to install gcc42 (I am using macports for that) but it hangs, for hours, while it displays

--->  Building gcc42

... so far, I'd just found the following comment which encourages me to wait until tomorrow before killing the cc1 process running behind the scene...
(a ticket of macports)

OpenSource EOF

So long without writing here... but this nightmare took me too much of my time...
In the meantime I had been learning and applying the so called DNA Computing; interesting , but not the aim of these lines.

I found an open implementation of Apple's Objective-C EOF in SourceForge.net... it includes source for an EOModeler, for some Adaptors, and for the frameworks EOAccess and EOControl. Even I am missing the EOInterface layer, that may be replaced with Cocoa Bindings... hopefully!