Tag: SQL

bBox 1.04 for FileMaker Now Available

by Simon Brown
Posted in bBox, FileMaker, FileMaker 2023, FileMaker 2024, FileMaker Cloud, FileMaker Data API, FileMaker Server, FM Products, Integration, JavaScript, Python, Ruby, Swift, Tools & Add-ons

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

by Fabio Bosisio
Posted in All, AWS, Claris Development, Data Analytics, FileMaker, FileMaker 19, FileMaker 2023, FileMaker Data API, FileMaker Server, Integration, Logging, Reporting, Software Design, Techniques, Tools & Add-ons

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

by Beezwax Team
Posted in AWS, Claris Connect, Claris Development, FileMaker, FileMaker 19, FileMaker 2023, FileMaker Data API, FileMaker Server, Integration, Techniques, Tools & Add-ons

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

by Beezwax Team
Posted in All, Claris Connect, Claris Development, Community, Events, FileMaker, FileMaker 19, FileMaker 2023, FileMaker Cloud, FileMaker Data API, FileMaker Go, FileMaker Server, Integration, News, Performance, Python, Security, Techniques, Tools & Add-ons, UX

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

by Christopher Edwards
Posted in Claris Development, FileMaker, FileMaker 18, FileMaker 19, FileMaker Server, Integration, Security

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

by Vincenzo Menanno
Posted in All, FileMaker, InspectorPro, Techniques, Tools & Add-ons

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

by Brian Schick
Posted in All, FileMaker, Techniques

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

by donovanchan
Posted in All, FileMaker, News

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