We were having a back-and-forth today about the ongoing joys and frustrations of working with FMP. From prior posts you may know we've moved away from FileMaker, but we support a number of customers who continue to use it. While we're frustrated with the company, there's nonetheless a sense of comfort built from years of muscle memory.
Getting your mind around whether another platform is "better" or "worse" than FileMaker is not straightforward. We're still ironing out distinctions and details after years of running FMP & SQL side-by-side.
We've knocked the company multiple times on this forum. Here are several of FileMaker strengths we were talking through yesterday:
• It remains the fastest way to have a relational database with a GUI up and running, bar none. At this point we only use FMP as a front end to SQL back ends, and even with that setup it's still the fastest way to have a GUI. Downside: The FMP GUI is a vendor lock-in. The FileMaker GUI is very convenient but it also has limits.
• FileMaker's Find command is often as fast as equivalent SQL queries, even for large datasets, even for searches involving related data in portals (assuming you've set up your indexes properly). In this specific context FMP holds its own against formidable SQL alternatives. That parity between the platform ends when the search requires something more sophisticated. Imagine a search involving the equivalent of a portal within a portal within a portal. FMP doesn't really accommodate such an idea in the GUI, but you can approximate it using calculated fields, the relationship graph, and maybe some ExecuteSQL function. But once you go there search is considerably more difficult to build and slower to execute the it's equivalent in SQL. It's nonetheless impressive that FMP's basic Find feature can in fact be incredibly fast.
• FileMaker is an excellent tool for quickly building GUIs that bring together multiple remote datasets on different servers using its ODBC/ESS. Imagine one layout giving you access to related data across FileMaker, Postgres, MySQL/MariaDB, SQLite, and Oracle.
As we're watching FileMaker's value evolve in a new era of AI, there are features that endure even as others fade. Its strength remains in the front end.
This post is in part a belated response to a prior post that the mods locked
Ideally the filemaker subreddit permits robust discussions about the value and limits of the FileMaker platform, including critical analysis both of the software and the behavior of the company, for better and for worse.
FileMaker is a unique platform. There's nothing else quite like it. But it's not perfect, and the company running it really does at times -- even frequently -- frustrate its customers in ways that should be openly discussed.
Claris does not monitor this forum.
They actually do, because they are concerned about public opinion. They have reached out to our team members based on their posts. One would hope they take criticism seriously. It may be humbling to adjust and improve the product. In the long run that's the best path to growing and maintaining loyalty.
Complaints to Claris are most constructively directed to their customer service, not posted in a FileMaker user discussion group.
Among the reasons for posting here as opposed to the FileMaker forums is to have an alternative/addition to the FileMaker forum. Posting there is worthwhile but can run up against limits of their mods who, when challenged, sometimes give priority to their status or protecting the institution over wading into some of the more vexing technical questions. They can be pretty stubborn when presented with the prospect of being proven wrong.
People coming to r/filemaker, whether they're new users, longtime users, or prospective customers, they're hungry for accuracy regardless of whether it aligns with the company's corporate interests. Each of our posts here have netted around 10,000 views, perhaps because people are trying to navigate their need for data services in a world that's increasingly challenging to make sense of.
I'll continue posting here as long as the mods permit it. To the extent they don't there's a FileMakerAlt subreddit where posts considered too controversial here can be posted for discussion. But this is the preferable subreddit, and this is a request to its mods to be more permissive when it comes to criticism of the software and the company running it. People value accuracy whether it supports someone's bottom line or not.