Building Bespoke Business Applications: FileMaker and Alternatives
Are you looking for a quick and easy-to-use tool to build unique business applications? Let's explore the popular FileMaker alternative Five and see how these two custom application development platforms compare.
- Building Bespoke Business Applications: FileMaker and Alternatives
- Meet Five, a FileMaker Pro Alternative
- Five vs. FileMaker Pro: Exploring Key Differences
- Kicking the Tires on Five and FileMaker
What is FileMaker?
Claris FileMaker is a popular database application builder that helps developers rapidly develop custom business applications. First released in the 1980s, it is a cross-platform database application designed to allow users to manage data and organize it into screens, layouts, or forms. The company is owned by Apple but operates independently.
At the time of writing, FileMaker has published FileMaker Pro in its 19th iteration. This also answers another frequently asked question: "Does FileMaker Pro still exist?". Absolutely, it does. In fact, many small business owners, solo developers, and small app development agencies rely on FileMaker to build bespoke business software to streamline operations, automate data, or move away from spreadsheets.
What is FileMaker Pro Used For?
FileMaker is used to build applications that solve business needs.
Developers use FileMaker Pro to develop a wide variety of solutions: to import spreadsheets and convert them into an app in minutes, to create data visualizations, to deploy productivity applications that elegantly solve a business problem, or to build mission-critical data management applications.
A lot of small and medium-sized businesses (SMBs) rely on custom-built FileMaker applications for better management, control, and enhanced productivity. Typical use cases for FileMaker are, for example, custom-built applications to manage payroll, inventory, contacts, customer relations, or timekeeping.
The FileMaker product suite includes a variety of products:
- FileMaker Pro Advanced is the low-code IDE that runs on Mac and Windows,
- FileMaker Server is a separate software package to host and share a custom app built with FileMaker on an on-premise infrastructure. FileMaker Server works for Mac, Linux and Windows.
- FileMaker Cloud is a cloud-hosted and managed solution for hosting applications built with FileMaker on AWS, and
- FileMaker Go is a wrapper that makes custom apps built with FileMaker accessible from an iPhone or iPad.
Meet Five, a FileMaker Pro Alternative
Five and Claris FileMaker are two popular solutions for rapidly building small business applications that help solve business problems. Both solutions make it easy to build database systems that are highly customizable and easily customizable.
Their flexibility, strong data modeling features, and extensibility make both of these solutions true "Swiss army knives" in small business application development. Both platforms integrate data structure, business logic, and user interface creation tools into easy-to-use solutions.
Some common features of the two platforms are:
- Five and FileMaker are purpose-built platforms for building custom business applications. There are many no-code and low-code solutions, but not all suited for building business applications. For example, enterprise-grade platforms like OutSystems and Mendix are too expensive and sophisticated to be used for data-driven business applications. Other solutions, such as Retool or Bubble, are too complex (Retool) or are better suited for building consumer-facing applications (Bubble). Five and FileMaker, on the other hand, come with a comprehensive set of features for developing custom business applications.
- Strong data modeling capabilities that let developers design data models visually and in point-and-click. Gone are the days of writing lengthy SQL queries to create relational databases. Instead, Five and Filemaker both provide users with an intuitive, visual database builder that lets users create tables and fields without writing a single line of SQL and inspect their database schema, including its relationships, visually.
- Features for developers of varying skill levels: from novice developers to expert developers. Both Five and Filemaker are true low-code platforms, which enable tech-savvy business users to create simple applications, while also providing interfaces to more experienced developers to create more complex logic.
- Pricing that makes running custom apps an affordable option for small- and medium-sized businesses. Building custom applications is a great way for smaller businesses to differentiate. But what if running the application is too expensive? Five and Claris FileMaker both offer competitive pricing when it comes to running applications online.
Now that we understand the similarities, let's explore some of the key differences between Claris and FileMaker alternative Five.
Five vs. FileMaker Pro: Exploring Key Differences
1. The Underlying Database
One of the most important considerations in application development is the choice of the underlying application database.
Five builds applications on the world's most popular open-source database, MySQL. The MySQL database is tightly integrated into Five's development environment and developers can create new tables, add relationships, add new fields, or import or export data. Moreover, Five automatically creates Primary Keys and supports the Foreign Key constraint, which ensures data integrity even for complex data models. Last, when applications are pushed to the cloud, Five automatically creates a fully-provisioned web database for applications. It does so by setting up the database server automatically.
FileMaker, on the other hand, is a proprietary relational database application. It does not directly integrate with any standard, open-source databases but rather relies on its ability to connect to a number of SQL databases using what is called ODBC connections. To establish this connection, users must configure an ODBC driver that varies with each application's client driver. Alternatively, developers can use FileMaker's built-in database. FileMaker gives them the flexibility of choosing where to host the database.
Conclusion: In the area of database modeling, Five and FileMaker both offer an intuitive approach to creating a relational database that follows best practices.
However, even though Five and FileMaker both follow the standard relational database model to create applications, the time and effort required to get a fully provisioned database up and running are significantly less in Five than in FileMaker.
2. Querying Your Database
Many custom-built business applications heavily rely on queries to filter, report, manipulate or visualize data. Queries are written statements in SQL or Structured Query Language, one of the world's easiest programming languages, because of its natural language-like syntax.
Five lets developers build queries visually, or write standard SQL. This means that even complex queries can be written and executed in Five. As long as it's SQL, it's possible. This results from Five's tight integration of the MySQL database mentioned above.
FileMaker, on the other hand, does not directly integrate with relational databases, but rather just connects with them. This limits the support for SQL statements, as shown in the FileMaker SQL reference.
Conclusion: Five and FileMaker both support SQL, however, with minor variations. Both platforms let you write SELECT statements, the most common statement to query a database. In addition, Five's provides developers with full control and querying capabilities for its in-built MySQL database. FileMaker, on the other hand, supports most of the most common SQL commands with some limits.
3. User-Friendliness: How User-Friendly Is the Interface?
User interface (UI) design is usually highly subjective, but there are some important (objective) UI differences between the end-user applications that Five and FileMaker build.
First, Five builds responsive web applications. The user interface that Five provides to its users is optimized for all devices and automatically adjusts to the screen size that is available to it. FileMaker, on the other hand, builds desktop applications, which are not optimized for mobile without additional work.
Second, Five provides a classic admin panel web interface with the look and feel of a modern web app, similar to Gmail or other popular web applications. Applications built with Five are, once launched to the web, accessible under their own custom URL.
FileMaker, on the other hand, does not directly build for the web. It is primarily a database platform, that can expose data to the web via APIs or by purchasing an additional FileMaker Server or FileMaker Cloud subscription at extra cost. There are also external, third-party companies that can provide emulators to make FileMaker apps ready for the web, but FileMaker is still fundamentally a desktop app with a desktop look and feel (as a little side note, the reason that FileMaker alternatives are becoming increasingly popular is that FileMaker is a technology that emerged prior to the Web).
So, if you are looking for a solution that is comparable to FileMaker Pro, but is native to the web, then Five could be an alternative option for you.
4. Multi-User Applications: Giving Access to Your Application with Logins and Permissions
As custom applications grow, one of the biggest challenges typically becomes managing access, i.e. who has access to what data? And what can they do with it?
With relational databases, the typical approach to governing access to data is by assigning Create, Read, Update, and Delete (CRUD) permissions for different user roles. For example, in a Lead Generation App, account managers can only see the leads in their territory, but not everyone else's.
In Five, a multi-user app with different roles can be easily created in just a few clicks. CRUD permissions can be assigned entirely in point-and-click to create different user roles.
FileMaker is also a multi-user database, and developers can assign CRUD permissions to different user roles, but this typically requires a script, and users report multiple different workarounds in the Claris FileMaker community forums in order to govern access.
5. Pricing: How Much Does It Cost To Run An Application?
Five charges a fixed monthly fee per application. FileMaker charges a fixed monthly fee per user.
Five's pricing starts at just US$27.49 per month and application. Five's basic subscription lets developers build and test their applications locally, and to then push them to the cloud for web access.
FileMaker's subscription fees are US$21 for the Essentials plan or US$43 for the Standard plan per month and user.
Conclusion: Unless you only have one single user, Five is a more affordable FileMaker alternative.
Kicking the Tires on Five and FileMaker
In this article, we have explored how Claris FileMaker Pro alternative Five compares. But what if you are still unsure which solution is right for you? Let's explore what free options we have to evaluate each solution better.
Is FileMaker Pro Free?
Both Five and FileMaker offer free downloads to explore their platforms at no cost. FileMaker's free trial is limited to 45 days and requires Apple's Bonjour to run on Windows.
Five, on the other hand, offers a full-featured free download that lets developers develop and test their applications locally without any time or feature limits. Five is available as a download for Microsoft and Mac.
Last, are there any other FileMaker alternatives? There are, of course. MS Access, a popular database solution by Microsoft, is often considered as a FileMaker alternative. There are also other online database builders.
Both FileMaker and Five also provide free sample apps for common business processes, such as inventory management, customer relationship management, or project management. These sample apps make it easier and quicker to get started with their solutions.
Whatever platform you choose: FileMaker or FileMaker alternative Five - happy coding!
Top comments (0)