Forums > MaxMSP

Max and FileMaker Pro

January 17, 2007 | 11:32 am


January 17, 2007 | 12:13 pm

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.


January 17, 2007 | 6:37 pm


January 17, 2007 | 7:00 pm

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


January 18, 2007 | 11:25 am

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.


January 18, 2007 | 11:49 am

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


January 18, 2007 | 1:07 pm


January 18, 2007 | 6:30 pm


January 22, 2007 | 10:24 am


Viewing 9 posts - 1 through 9 (of 9 total)