Monthly Maintenance – Care and Feeding of Linux Servers

Maintaining the health and security of your Linux servers is more crucial than ever. With any server, you should be using real-time monitoring solutions, and performing backups every day (or more often, depending on data use). And, while you can rely on the OS to automatically install updates–especially on Windows and Mac–with Linux you benefit from a more “managed” approach to regular maintenance.

Continue reading “Monthly Maintenance – Care and Feeding of Linux Servers”

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”

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”

Finer Faster FileMaker Precision: Measuring How Long It Takes

I often like to measure performance, because I am curious if some small change can lead to subtle, or maybe not so subtle, improvements. For the longest time my Swiss Army knife for measuring Claris® FileMaker® performance has been:

Get ( CurrentTimeUTCMilliseconds )

Continue reading “Finer Faster FileMaker Precision: Measuring How Long It Takes”

Logging PSoS Activity: Episode III – Return of the JSON

In looking back at our initial approach to logging FileMaker PSoS (Perform Script on Server) activity, I reflect back on a number of times where this has been extremely helpful. If you have come to rely on the benefits of PSoS then you also know some of its challenges — one of the biggest is debugging and monitoring how long sessions take.

Since FileMaker 16 introduced JSON, in new systems we’ve switched over to using JSON as the main way of exchanging data for parameters. Because we also use PSoS in new systems, we updated our method for PSoS Logging and this blog entry talks about the changes we made there and also restates the usefulness of this log.
Continue reading “Logging PSoS Activity: Episode III – Return of the JSON”

Debug Apache on a FileMaker Server

Since FileMaker Server version 13, FMS has used its own Apache configuration files on macOS instead of just adding includes to the OS configuration files. Because of this, the technique I mentioned here no longer works for newer systems. This new arrangement has reduced issues for FileMaker Server’s web connectivity.

Continue reading “Debug Apache on a FileMaker Server”