Caché Database System Integration With Squeak

Simon Kirk Simon.Kirk at pinesoft.co.uk
Mon Nov 28 10:34:06 UTC 2005


Hi Ron - yes! Funnily enough I've spent the last two months struggling 
with this very subject :)

How are you planning to integrate with Caché? My first priority was to 
try to integrate with their ODBC drivers - there's a thread about it on 
this list here 
<http://thread.gmane.org/gmane.comp.lang.smalltalk.squeak.general/52948>. 
Eventually I did get success, but as you can see from the thread, it's 
certainly a non-ideal solution.

Upon communication with their (admittedly pretty helpful) support staff 
it turns out the timer is internally set up to control a timeout value 
within their own unix driver software. Of course, the whole issue I 
found doesn't apply if you're working with windows as their ODBC driver 
is completely different, the integration works just fine - within the 
boundaries of FFI, of course.

We're now at the point of trying to decide what to do. The whole point 
of all this is to add Caché as a supported database for GLORP (and have 
it work on other OSes than Windows - preferably Linux in our case), but 
I'd be interested to know how you intend to use it. We're considering 
whether to try to hit the metal directly and write pure Squeak drivers 
for Caché, but we're not sure whether they'd give up the specs to us of 
how we need to communicate with their server. The PostgreSQL drivers for 
Squeak seem to encapsulate a nice generic framework from which base 
other pure Squeak database drivers, but whoever developed it never did 
the required abstraction: I wonder if anybody ever did it, started it, 
or even considered doing it?

Anyway, it's nice to know we're not the only people trying to break this 
ground now :)

Cheers,
Simon


Ron Teitelbaum wrote:

> Hello All,
>
>  
>
> Has anyone worked with the Caché Database system: 
> http://www.intersystems.com/ .  I'm interested in possible integration 
> with squeak.
>
>  
>
> Ron Teitelbaum
>
> President / Principal Software Engineer
>
> US Medical Record Specialists
>
> www.USMedRec.com <http://www.usmedrec.com/>
>
> Ron at USMedRec.com <mailto:Ron at USMedRec.com>
>
>
>
> Click here 
> <https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg==> 
> to report this email as spam.
>
>------------------------------------------------------------------------
>
>
>  
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.squeakfoundation.org/pipermail/squeak-dev/attachments/20051128/5c140907/attachment.htm


More information about the Squeak-dev mailing list