I have been trying to encourage the people at Magister Ludi who do YourSQL to consider adding applescript support. It’s a Java app. They say nah, that’s too hard, we’re going to add Excel support if we can figure it out. So I wonder if I can get pointers to some information that would help them do this. It is an open source app so you could just dive in an solve the problem if you know how. I don’t.
But along the way somebody said well, why doesn’t Sal just get EOModeler released as a scriptbable independent product since it can talk to anything. Now THAT seems like an interesting idea. So Apple can say, “By the way, here’s OSX with our great developer tools. And by the way here’s OSX, we can talk to ANY database right out of the box.”
Here is a comment from Morten Larsen of the YourSQL project:
“Thanks! It would be really useful if somebody who knows/understands the issues of setting up the dictionaries and map them to the Java code could take a look at it.
Even just a small, working Cocoa-Java demo app would be of great help. If such a thing exists already, a pointer would be much appreciated!
By reading Apple’s documentation, we have noticed that we should ideally map into the document model. Trouble here is (not only for applescript but for the whole Cocoa document framework) that a database does not fit nicely into the document paradigm.
I would therefore suggest some precisely defined functions that can be called from AppleScript and which return some simple data structures, without necessarily being able to script all possible functions of the app.”