Scodigo, Inc.

Thanks to CAFDA for having me back to talk about our experience with ESS.

Here’s the description for my presentation and I've also attached the slides below.

“This presentation will explore two real-world examples that use the new ESS capabilities available in FileMaker 9. For those less familiar with ESS, we’ll start with a brief intro covering how to get started, some best practice suggestions and a list of useful resources.

The first example we’ll explore involves syncing and transferring data with a set of SQL tables. In this example, ESS interaction is carefully controlled and users do not work directly with the SQL tables. Instead, data is synced into and transferred from internal FileMaker tables. The ESS capabilities have allowed us to greatly simplify the development effort required to support these processes as well as improving reliability and performance.

The second example will explore a simple “front-end” application used to manage a small set of SQL tables. We’ll talk about when it’s appropriate to build this type of tool and cover some of the dos and don’ts that effect viability and performance.

As we work through these examples, we’ll take a look at how to run a server trace so that we can see the SQL that FileMaker is executing. This can provide helpful insight into how your development approach will affect server load and the performance of your application.

Time permitting; we’ll take a look at how our SmartPill PHP plug-in can be used to compliment ESS by providing direct query access to your SQL database.”