Max and FileMaker Pro

Jan 17, 2007 at 11:32am

Max and FileMaker Pro

#29751
Jan 17, 2007 at 12:13pm

On 17 Jan 2007, at 11:32, Falk Grieffenhagen wrote:

> I found that Nick Rothwell made some java classes dealing with sql.
>
> Is it possible to use hat classes with FileMaker Pro.

If you have JDBC drivers for FileMaker Pro, it shouldn’t be too
difficult. I’ve now written wrapper classes for HSQL DB, Derby and
MySQL; they essentially differ only in the JDBC class they load and
the connection URL.

– N.

#93502
Jan 17, 2007 at 6:37pm

#93503
Jan 17, 2007 at 7:00pm

Nick Rothwell wrote:
> If you have JDBC drivers for FileMaker Pro, it shouldn’t be too
> difficult. I’ve now written wrapper classes for HSQL DB, Derby and
> MySQL; they essentially differ only in the JDBC class they load and the
> connection URL.

That sounds very interesting. It would mean you could use the same patch
and choose to which database to talk to, that would make databased
patches much more portable. As OSes, Databases are a matter of taste and
nobody wants to argue about taste…

Stefan


Stefan Tiedje————x——-
–_____———–|————–
–(_|_ —-|—–|—–()——-
– _|_)—-|—–()————–
———-()——–www.ccmix.com

#93504
Jan 18, 2007 at 11:25am

On 17 Jan 2007, at 19:00, Stefan Tiedje wrote:

> It would mean you could use the same patch and choose to which
> database to talk to, that would make databased patches much more
> portable.

In principle – that’s what JDBC is supposed to be about – but in
practice, the various dialects of SQL vary too much for that to work
very well without a dedicated dialect layer (which is what Hibernate
uses).

I mean:

“DROP TABLE Foo IF EXISTS” (HSQL DB)
“DROP TABLE IF EXISTS Foo” (MySQL)

And even if one can get by without issuing DDL, essential things like
getting last auto-increment index values work in slightly different
ways in different databases.

– N.

#93505
Jan 18, 2007 at 11:49am

Tempo Reale in Florence have developed a SQL => Max approach which they use to control events and spatialisation for the performance of Luciano Berio’s pieces in concert.
They presented their system during the Max/MSP/Jitter week in Stuttgart 2005 and 2006
Have a look at :
http://www.centrotemporeale.it/download/pubblicazioni/SQL_live_electronics.pdf
I have a preliminary version, but I’m not sure if there is a official release yet.
Fell free to contact them:
info@centrotemporeale.it

_best
Andreas

#93506
Jan 18, 2007 at 1:07pm

#93507
Jan 18, 2007 at 6:30pm

#93508
Jan 22, 2007 at 10:24am

#93509

You must be logged in to reply to this topic.