Better, Faster Random Text for FileMaker

We often need large amounts of random text to simulate real-world data loads while building a FileMaker solution. I was looking to create a large chunks of unique data for testing — we’re talking at least millions of characters. Here, I’ll compare the performance of a few methods I tried.

Continue reading “Better, Faster Random Text for FileMaker”

bBox 1.06 for FileMaker enhances support for macOS text windows and Python

We are pleased to announce the release of bBox version 1.06 for Claris® FileMaker®, which adds support for macOS text windows and many update enhancements, including to bBox’s support for integrating Python code with your FileMaker apps.

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 DuckDB. Also included is a demo file that has over 220 examples of how you can put bBox functions to work for you.

If you’re interested in Python integration with FileMaker, also check out bzPython-FM, which uses bBox.

Continue reading “bBox 1.06 for FileMaker enhances support for macOS text windows and Python”

Quick FileMaker Server Stats.log Summaries

When making changes to a FileMaker file or a FileMaker Server’s configuration, it is often useful to know if the changes have helped, or made things worse, or perhaps had no effect at all. FileMaker’s Stats.log generates some data needed to summarize this, with some help from monitoring and analysis tools, or in this case, a Python script.

Continue reading “Quick FileMaker Server Stats.log Summaries”

bBox 1.05 for FileMaker Now Available

We are pleased to announce the release of bBox version 1.05, which adds support for schema change notifications, a new Ubuntu ARM binary, and DuckDB integration.

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.

If you’re interested in Python integration with FileMaker, also check out bzPython-FM, which uses bBox.

Continue reading “bBox 1.05 for FileMaker Now Available”

Python with FileMaker®: Get Started with Analytics, Automation and AI + ML

Christos Savva from Beezwax presents at Bay Area FileMaker Developer Meetup.

Join us for an informative and interactive meetup that explores the benefits of integrating Python with FileMaker. Learn how Python can enhance your Claris FileMaker solutions by enabling data and visual analytics, IT automation, and AI + Machine Learning integration.

We’ll cover “Getting Started” with Python (using FileMaker 2024 on macOS for the demo) and briefly review various integration methods, such as web viewers, plugins and serverless options. We’ll demo an example FileMaker solution, bzPython-FM.

Continue reading “Python with FileMaker®: Get Started with Analytics, Automation and AI + ML”

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”

Common Refactors: Part 1 – Conditionals

In this series, I’ll talk about common refactors I suggest when doing code review in my day to day. I’ll start with conditionals, including severals example refactors. The goal is to help produce code that’s easier to read and understand, and thus, easier to maintain and produces fewer bugs.

These examples will be in TypeScript but the refactors are common patterns and can apply to most languages out there, such as Python, Ruby, Swift, PHP, Java, Go, JavaScript, etc.

Continue reading “Common Refactors: Part 1 – Conditionals”

dotFMP 2024 – Chatbot, AI with FileMaker, Technical Debt

Fabio Bosisio and Vince Menanno from Beezwax present at dotfmp Berlin, 2024.

If it’s June, we must be in Berlin for dotFMP …gathering with the developer community, and celebrating the launch of Claris FileMaker 2024, especially AI with FileMaker functionality.

As conference presenters, Fabio Bosisio and Vince Menanno from Beezwax will lead two sessions:

  • Chatbot in FileMaker 2024 {From Amazon Lex to the new GenAI}
  • ‘Til Technical Debt Do Us Part
Continue reading “dotFMP 2024 – Chatbot, AI with FileMaker, Technical Debt”

Rock Solid Business Logic: The Action Pattern

The Action Pattern is a rock solid solution for organizing business logic in an application. It works quite well for medium to large-ish projects. I like the Action Pattern because it introduces few concepts, unlike some more elaborate and complex designs. It’s flexible, scalable and helps me feel more confident in handling complex business logic in my work as a developer. Even though generative AI now plays a bigger role in programming, it does not replace actual software design, and the Action Pattern can be a great tool to have in your toolbox!

Continue reading “Rock Solid Business Logic: The Action Pattern”

bzPython-FM performs Python for your FileMaker apps

bzPython-FM easily performs Python code within FileMaker, using the bBox plugin.

There are literally thousands of Python packages out there, for AI and Machine Learning, data analysis, data science and IT automation — now at your fingertips from within FileMaker.

Continue reading “bzPython-FM performs Python for your FileMaker apps”

Leveraging pandas with Python to Analyze FileMaker Data Sets

The pandas library for Python has become a go-to tool for many data scientists and analysts. In this blog post, we’ll examine one strategy for leveraging the highly powerful tools within pandas to enhance data analysis capabilities using the Claris FileMaker platform. We’ll do this by calling the bBox plugin and its built-in Python functions.

Continue reading “Leveraging pandas with Python to Analyze FileMaker Data Sets”

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”

Tableau Conference 2023 – Highlights

Greetings from Tableau Conference 2023 (TC23) in Las Vegas, and beyond. Beezwax’s Data Analytics & Tableau Developer team is attending, both in-person and virtual.

TC23 is designed to reveal and inspire, with new product information, plus Tableau (and Salesforce) company roadmaps. More importantly, there’s plenty of insight from TC23 sessions including technical topics, case studies, thought leadership, cool demos, community inspiration, and hands-on learning.

Continue reading “Tableau Conference 2023 – Highlights”

Modern Full-Stack Web Frameworks: When to use What and Why

When it comes to choosing web development technologies, we now have more options than ever. And while that’s a good thing, it also poses a problem. Answering the question, “What is the ideal technology for this new project?” is not as easy as it used to be. In this post, I briefly highlight the most popular full-stack web frameworks, and why you might want to choose each of them.

Continue reading “Modern Full-Stack Web Frameworks: When to use What and Why”

Beezwax Sponsors EngageU: The Biggest Claris® FileMaker® Developer Conference

Christos Savva and Vince Menanno Present Rapid Serverless Integrations and FileMaker Native Script Transactions

This week, Nov 13-15, we’re in Malmö, at EngageU. It’s the biggest Claris / FileMaker Developer community event worldwide in 2022. In fact, EngageU promises to be the largest in-person Claris Community event in Europe, ever!

Continue reading “Beezwax Sponsors EngageU: The Biggest Claris® FileMaker® Developer Conference”

bBox v0.99 Integrates Claris FileMaker with JavaScript, Python 3 and Supports M1 Apple Silicon

We are pleased to release bBox version 0.99 for Claris® FileMaker® on macOS and Linux with new NodeJS and Python 3 integration, and M1 Apple silicon support for GraphicsMagick image processing and JQ JSON parsing functions.

About bBox Plug-in For FileMaker

bBox is a free utility plug-in to extend Claris FileMaker solutions to easily use macOS and Linux code libraries and functions from Python, JavaScript, PHP, Ruby, AppleScript, C/C++, Bash/sh, XPath, and SQLite. Also included is a demo file with more than 210 examples of how you can put bBox functions to work for you.

bBox is available on macOS and Linux, and runs with either FileMaker Pro or FileMaker Server. Here’s what FileMaker Magazine had to say about bBox version 0.99:

Continue reading “bBox v0.99 Integrates Claris FileMaker with JavaScript, Python 3 and Supports M1 Apple Silicon”

Tableau Conference 2022 – Day 3

We finished three days of Tableau Conference 2022 (TC22) in sunny Las Vegas! The in-person and virtual attendees from Beezwax’s Data Analytics & Tableau development teams shared a few more highlights of TC22 sessions, with information, insights and a few key takeaways.
Continue reading “Tableau Conference 2022 – Day 3”

Tableau Conference 2022 – Day 2

Hello again from the end of Day 2 at Tableau Conference 2022 (TC22) in sunny Las Vegas! The in-person and virtual attendees from Beezwax’s Data Analytics & Tableau development teams shared more highlights of TC22 sessions, with information, insights and a few key takeaways.
Continue reading “Tableau Conference 2022 – Day 2”

Tableau Conference 2022 – Highlights

Hello from Tableau Conference 2022 (TC22) in sunny Las Vegas! Attending in-person from Beezwax were Rob, Sarah, Vince and Jay from our Tableau/Analytics team, with several more Beez joining virtually.
Continue reading “Tableau Conference 2022 – Highlights”

OOP Fundamentals: Quick and Dirty Guide to Testing

There are entire books written on testing. And it surely feels more an art than a science. My approach is similar to Kent Beck’s:

I get paid for code that works, not for tests, so my philosophy is to test as little as possible to reach a given level of confidence (I suspect this level of confidence is high compared to industry standards, but that could just be hubris). If I don’t typically make a kind of mistake (like setting the wrong variables in a constructor), I don’t test for it. I do tend to make sense of test errors, so I’m extra careful when I have logic with complicated conditionals. When coding on a team, I modify my strategy to carefully test code that we, collectively, tend to get wrong.

https://stackoverflow.com/a/153565/1015566

He goes on to add that different people will have different strategies and, at the end of the day, you just have to do what works best for you and your team. Extremely practical, and the approach I personally follow.

This won’t be a detailed post on every possible topic on tests and testing in Object-oriented Programming (OOP). There are many books about that already. Instead, this article will cover the basics of testing, so you understand how and why we test, and you can adapt it to your own needs.

Continue reading “OOP Fundamentals: Quick and Dirty Guide to Testing”
1 2