FileMaker 14: A Database For DIY Apps - InformationWeek

InformationWeek is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

Software // Information Management
09:05 AM

FileMaker 14: A Database For DIY Apps

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

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.

FileMaker 14 features a drag-and-drop development environment for database applications

(Image: Curtis Franklin, Jr., for InformationWeek)

FileMaker 14 features a drag-and-drop development environment for database applications

(Image: Curtis Franklin, Jr., for InformationWeek)

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?

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 ... View Full Bio
We welcome your comments on this topic on our social media channels, or [contact us directly] with questions about the site.
Comment  | 
Print  | 
More Insights
InformationWeek Is Getting an Upgrade!

Find out more about our plans to improve the look, functionality, and performance of the InformationWeek site in the coming months.

10 Things Your Artificial Intelligence Initiative Needs to Succeed
Lisa Morgan, Freelance Writer,  4/20/2021
Tech Spending Climbs as Digital Business Initiatives Grow
Jessica Davis, Senior Editor, Enterprise Apps,  4/22/2021
Optimizing the CIO and CFO Relationship
Mary E. Shacklett, Technology commentator and President of Transworld Data,  4/13/2021
White Papers
Register for InformationWeek Newsletters
Current Issue
Planning Your Digital Transformation Roadmap
Download this report to learn about the latest technologies and best practices or ensuring a successful transition from outdated business transformation tactics.
Flash Poll