FileMaker 14: A Database For DIY Apps

FileMaker 14 features new tools to make DIY mobile database apps possible for non-programmers.

Curtis Franklin Jr., Senior Editor at Dark Reading

June 12, 2015

4 Min Read
<p align="left">FileMaker 14 features a drag-and-drop development environment for database applications</p>

6 Characteristics Of Data-Driven Rock Stars

6 Characteristics Of Data-Driven Rock Stars

6 Characteristics Of Data-Driven Rock Stars (Click image for larger view and slideshow.)

In the enterprise software world we spend a lot of time talking about the big guns -- Oracle, IBM DB2, SAP HANA, and the like. Those are critical as the foundations for large enterprise applications, but there are thousands of applications that organizations need that require a database, but perhaps not quite as much database as the big guns provide.

Let's talk about the database on a slightly smaller scale.

Once upon a time there were scores of PC-based databases, but that world has gradually shrunk. Today, there are only a handful used by a significant number of companies: Intuit QuickBase, Microsoft Access, and FileMaker. FileMaker, a wholly-owned subsidiary of Apple, has just released FileMaker 14, and it's worth taking a look to see what's new in this world of smaller databases.

The first thing to note is that FileMaker isn't an Apple-only platform.

The database has been available on Windows, as well, for years, so it's not limited to a single ecosystem. The one part of the FileMaker family that is limited to a single operating environment is FileMaker Go, the mobile app for FileMaker applications. It's available only through the Apple App Store for iOS devices.

One of the key considerations of both FileMaker and Access is that users can begin defining simple flat-file databases without knowing most of the inner database secrets required of the big databases -- and absolutely none of the SQL or other programming languages most database managers use. FileMaker 14 takes it even farther by presenting a set of "sample solutions" that you can use as a template for many common database applications -- things like contact managers, inventory programs, and even content-management systems.

Once the data is defined, you can drop into the form designer and start selecting, dragging, dropping, and stretching all kinds of fields, boxes, shapes, buttons, and bars to create a screen that looks like the application you had in mind. Among the new features in FileMaker 14 are: the ability to add labels inside fields (to give users hints about what kind of data they should enter); new buttons and bars to make mobile apps look like, well, other mobile apps; and navigation buttons that help users move more easily between records.

Many of the new features of FileMaker 14 focus, in fact, on making it easier to create applications based on the database, with mobile apps a particular target. The new version adds features like enhanced signature capture using the mobile camera in iPhones and iPads. As with pretty much every other database and enterprise software system currently using more than one color for its display, FileMaker 14 has fully embraced a world in which most of its users will be handling touchscreens rather than keyboards.

There are a total of four products in the FileMaker 14 family: FileMaker Pro, FileMaker Pro Advanced, FileMaker Go, and FileMaker Server.

FileMaker Go is the iOS app, available free from the Apple App Store. FileMaker Pro is the "basic" version for developing solutions, while FileMaker Pro Advanced includes more features and tools for building applications -- features such as debugging tools, encryption, the ability to customize menus and functions, and the ability to develop "kiosk" apps that have no menus or buttons with which to wander away from the defined forms of the app.

[Need the power of an enterprise in-memory database? Read SAP HANA: Not The Only In-Memory Game In Town.]

FileMaker Server (which runs on either MacOS X or Windows Server) is the platform for hosting apps that will be accessed by multiple users. As such, the pricing for FileMaker Server is based on client-side licensing.

I'll readily admit that I miss some of the simple databases available in an earlier, simpler time. If you need to build custom database applications that don't require the massive horsepower of the enterprise battleships, or if you want a database tool to give workgroups and departments the ability to develop their own applications, FileMaker 14 has a great deal to recommend it.

I'll have a hands-on evaluation coming soon. What sort of app would you like to see built as part of that article?

About the Author(s)

Curtis Franklin Jr.

Senior Editor at Dark Reading

Curtis Franklin Jr. is Senior Editor at Dark Reading. In this role he focuses on product and technology coverage for the publication. In addition he works on audio and video programming for Dark Reading and contributes to activities at Interop ITX, Black Hat, INsecurity, and other conferences.

Previously he was editor of Light Reading's Security Now and executive editor, technology, at InformationWeek where he was also executive producer of InformationWeek's online radio and podcast episodes.

Curtis has been writing about technologies and products in computing and networking since the early 1980s. He has contributed to a number of technology-industry publications including Enterprise Efficiency, ChannelWeb, Network Computing, InfoWorld, PCWorld, Dark Reading, and on subjects ranging from mobile enterprise computing to enterprise security and wireless networking.

Curtis is the author of thousands of articles, the co-author of five books, and has been a frequent speaker at computer and networking industry conferences across North America and Europe. His most popular book, The Absolute Beginner's Guide to Podcasting, with co-author George Colombo, was published by Que Books. His most recent book, Cloud Computing: Technologies and Strategies of the Ubiquitous Data Center, with co-author Brian Chee, was released in April 2010. His next book, Securing the Cloud: Security Strategies for the Ubiquitous Data Center, with co-author Brian Chee, is scheduled for release in the Fall of 2018.

When he's not writing, Curtis is a painter, photographer, cook, and multi-instrumentalist musician. He is active in amateur radio (KG4GWA), scuba diving, stand-up paddleboarding, and is a certified Florida Master Naturalist.

Never Miss a Beat: Get a snapshot of the issues affecting the IT industry straight to your inbox.

You May Also Like

More Insights