Prep Your Schema For AI: GetTableDDL and Field Annotations in FileMaker 26

With FileMaker 26, how do you set up your database so an AI model can understand it? Two features make this easier: GetTableDDL, which describes your schema in a language AI already speaks, and field annotations, which explain what each field actually means. This reframes how to invest in aging but essential FileMaker solutions. The system you already depend on does not need to be rebuilt to work with AI. It needs to be made legible.

A Fork In The Road

Many teams adopting AI move quickly and pay for it later, connecting assistants to data that the model does not truly understand. Inspecting the schema may produce answers that sound confident and are quietly wrong. A schema an AI can understand produces answers you can act on more confidently. What follows is how GetTableDDL and field annotations work together, including the behavior that will surprise you the first time you hit it (the “Fork in the Road” below), and the FileMaker naming quirks that quietly waste tokens if you are not paying attention.

Continue reading “Prep Your Schema For AI: GetTableDDL and Field Annotations in FileMaker 26” →

bBox 1.04 for FileMaker Now Available

We are pleased to announce the release bBox version 1.04, including improvements to text parsing, XPath and SQLite support, and utility functions for FileMaker Admin API, Data API and OData API.

bBox is a free utility plug-in to extend FileMaker solutions to easily use code libraries. Supporting both macOS & Ubuntu Linux, it has functions to help you work with Python, JavaScript, PHP, Ruby, AppleScript, Bash/Zsh/sh, XPath, and SQLite. Also included is a demo file that has over 220 examples of how you can put bBox functions to work for you.

Continue reading “bBox 1.04 for FileMaker Now Available” →

Handling Historical Data with FileMaker and AWS Athena, S3 & Serverless

In this blog post, we will explore a solution for optimising a FileMaker app that handles large amounts of data. We will address the challenges of data storage, file corruption, and performance degradation when dealing with historical data.

By leveraging cloud storage and serverless computing, we can offload and query this data efficiently, ensuring better performance and scalability.

Continue reading “Handling Historical Data with FileMaker and AWS Athena, S3 & Serverless” →

FM-DiSC: Handling Historical Data with FileMaker, AWS Athena, S3, Serverless

Fabio Bosisio from Beezwax demonstrates handling historical data in a Claris® FileMaker® solution, utilizing a combination of AWS services including AWS Serverless, AWS S3, and Amazon Athena’s Interactive SQL. Use cases include archiving, data mining, and reporting.

Continue reading “FM-DiSC: Handling Historical Data with FileMaker, AWS Athena, S3, Serverless” →

dotfmp: Python + Claris® FileMaker® | Historical Data & AWS Athena/SQS/S3 | UX & DX for Great Solutions

Christos Savva, Fabio Bosisio and Vince Menanno from Beezwax present at dotfmp Berlin, 2023.

This week we’re in Berlin… one of the stops on the Road to Claris Engage 2024 …gathering with the developer community, and highlighting innovation for the Claris FileMaker platform development. As conference speakers at dotfmp Berlin (June 1-3), Christos Savva, Fabio Bosisio and Vince Menanno from Beezwax present three sessions:

  • Enhancing FileMaker with Python
  • What do you do with all this historical data in your app? [AWS Athena Interactive SQL / Serverless / S3 with FileMaker]
  • Elements for Building Great Solutions [FileMaker UX & DX]
Continue reading “dotfmp: Python + Claris® FileMaker® | Historical Data & AWS Athena/SQS/S3 | UX & DX for Great Solutions” →

Connect FileMaker Server to Oracle Server and Oracle Cloud Using ODBC and TCPS

A longtime enterprise client recently asked us to integrate a FileMaker Server with an Oracle server. No problem, right? This task requires some development to optimize the database schema and script the data sync, but using FileMaker and an ODBC driver to connect to Oracle is straightforward.

Continue reading “Connect FileMaker Server to Oracle Server and Oracle Cloud Using ODBC and TCPS” →

Re-Thinking is the new Rebuilding

Sometimes you just need to start over and to take a fresh look at how you are doing things. Many of you know that I usually like to start things anew, but its also understandable that this is impractical at times.

With the release of FileMaker 12, I was inspired to dive deep into how InspectorPro 4 (IP4) was architected and change my way of thinking. It isn’t about REBUILDING per se, but rather this is about RE-THINKING your solutions as you move to FM 12.
Continue reading “Re-Thinking is the new Rebuilding” →

FileMaker 12 SQL: Crafting Structural Beauty

It’s hard to believe it’s been only a few months since SQL was introduced as part of FileMaker 12.

Continue reading “FileMaker 12 SQL: Crafting Structural Beauty” →

FileMaker 12: Exciting New Possibilities

FileMaker, Inc. introduced the next generation of their database platform today with the release of FileMaker 12. This is a major upgrade to every part of the FileMaker product line. There are new versions of FileMaker Pro, FileMaker Pro Advanced, FileMaker Server, FileMaker Server Advanced, and FileMaker Go – which is now free for iPhone and iPad.

Continue reading “FileMaker 12: Exciting New Possibilities” →