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: 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”