Embedding PHP with Smart Pill

It’s always an interesting challenge to take a system you are familiar with and try to use it in an entirely new way or context. That’s what I’ve been getting with PHP of late. As more and more of my web development work moves to Rails, I’ve had the chance to work on PHP embedded within Filemaker Pro as I’ve tested and explored Scodigo‘s new Smart Pill plugin.

For those of us used to programming in full-fledged languages, writing scripts and functions in filemaker can be quite a challenge. Writing and debugging all that recursive code is a time-consuming process, and communicating with external processes isn’t really worth the work without plugins. Smart Pill changes all that, by opening up the entire PHP (5.1.4, including many extensions) engine for use within Filemaker.

I can’t imagine the plugin is going to tempt many web developers over to Filemaker, but for those who are integrating with existing filemaker systems or who need an office database system but want to be able to make use of web services or any of the other functionality PHP allows this could be a huge improvement.

You can see a screencast of the plugin in action, including a number of examples I worked on, over at the Filemaker Magazine site.

Tags: , , ,

3 comments

  1. I came across this post in my attempt to find some tutorials on using smartpill to access web services.

    I’m a web developer who is completely new to both filemaker and smartpill, but need to integrate a rails site with a filemaker database and figured this was the best solution.

    So anyway, I realize this is an old post, but any ideas where I could look for more tutorial-like information on smartpill for someone totally new to filemaker…?

  2. Justin – SmartPill may be a good way to build an interface to help you bridge between a rails app and filemaker database, though there are definitely other options such as the filemaker ruby api – http://rubyforge.org/projects/rfm/

    It’s really going to depend on the nature of the integration you’re going to undertake. I’d recommend posting a question in the Scodigo forums at:

    http://www.scodigo.com/forums/general-discusion

    and checking out the SmartPill example files at:

    http://www.scodigo.com/downloads/smartpill/misc/SmartPill_Example_Files.zip

  3. I’d never seen the filemaker ruby api but will definitely check it out. Thanks!