Filemaker Pro was considered a clever tool for making small in house database applications. The application was brought to my attention while talking to a guy about his database problems. I found that MySQL could be used as a backend for the application by using either Filemaker's ESS technology or by using a ODBC driver to connect to MySQL.
I had ran across some code that provided me with the means to use python as a wrapper so that we can put a trigger in the Filemaker database which would serve as a web service to update the MySQL backend. http://www.lfd.uci.edu/~gohlke/code/fmkr.py.html
Filemaker's XML approach to publishing XML data relies on specifying database queries in URLs or HTML forms using a proprietary language called CDML (Claris Dynamic Markup Language). The XML data is returned in the form of CSS or XSl style sheets. The data can be transformed into HTML and manipulated on a client's browser for display to a user or can be transformed into a format suitable for use by another XML aware application or server. The browser does all the tricky formatting and manipulation of data. For smaller data sets it can be more effiicient to move all the data to the client as XML, then use java or javascript to perform all the manipulations on the client side.
Applescript or Perl can be used also, as ameans to assist Filemaker becoming more efficiently export data.
No comments:
Post a Comment