2-26-01

Guest review by Matthew Stoton

4D High-end Relational database

The main goal of any high-end database is to deploy information as fast and easily as possible. Until version 5, FileMaker has been the obvious choice for anyone; experienced or not. 4th Dimension, with version 6.7, is now ready to entice FileMaker users to make the switch . 4D now has RAD capabilities, WAP support, Mac OS Theme support, 24 new and 24 modified commands and several new Internet features. More than enough reasons to upgrade, but will it be enough to bring FileMaker users home?

All entangling web: If you have ever used FileMaker's not-so-instant web publishing then you will love 4D's simple, instant, web publishing features. It produces HTML 4 and supports many other web-based technologies such as JavaScript and XML. As for security, 4D supports both SSL 2 and 3; a big bonus for eCommerce starters. Still, most beginners will be stunned by the installation process of the web assistant. You must open your database using the 4D Insider, install the web assistant and wait. You may have to edit the installed code, although the exact purpose of this is not mentioned. Aside from this, web publishing is extremely easy and instant.

No Relationship?: What about those who only need a single user database? This is where most would crown FileMaker king... or not. 4D has some great tools for smalltime developers that simply can't be ignored. Sure, I'll be the first to admit that 4D, if put in the hands of an inexperienced user, can be overkill. For the novice, Filemaker's word-like simplicity is great, yet it lacks some of the options of a full-featured database, like 4th Dimension. 4D has power that can't be found in FileMaker, although this can be troublesome at times. Even if you don't require a relational database, 4D may still be the product for you. If you only need to do simple database tasks, 4D will boost your productivity like you've never seen before.

Bugs and so much more: Of course you'd hardly expect a feature packed program like this to be bug free. And after years of using a rather mediocre product, you might overlook more interface glitches than you care to admit.

In FileMaker 5 the interface looks exactly like AppleWorks 5, except for an unattractive Microsoft Word style button-bar. 4D has a similar button bar that looks more like AppleWorks, but with tool-tips instead of an info box. It opens to a simple "open/new" dialog box, allowing you to open a previous database or make a new one. After choosing "New Database", you must make the structure for it. This is sure to confuse users who used the "Define Fields" window in FileMaker. In the structure window, you define the table, fields and any relationships between them. This speeds up the field-making process tremendously. Next you are required to create a form ; 4D’s version of FileMaker’s "layout". Naturally, the process of making a form is quick and easy, it can be completed in as little as five minutes depending on the size of database. A much more daunting task is editing a created form. The program brings up two palettes: the tools palette and the property list. Both palettes take up tons of screen space and the tools palette has no tool-tips for it's generic-looking icons. The most annoying problem is that when you align two objects using the align feature, both objects move to a central point. Only going deeper into that menu, brings up a more detailed alignment dialog. The design area isn't all problems though. You can choose to display many different page guides to assist in keeping everything on the page. It also offers a grid, rulers, grouping, mass duplication and many other timesaving options.

Scientifically Fast: The main reason to choose 4D is it's speed - its ability to save time. The interface isn't nearly as nice as, say that of Bryce, but it isn't all that bad either. It doesn't really enable you to have a "liquid work flow", but it offers some really smooth easy-to-find features. Time is the 4th Dimension, so it's fitting that they named the program 4D.

The speed of the program is truly amazing. Not only in creating records or other automatic tasks, but also in form creation, data importing and structure development. All tasks that can slow you down when using other software. If for no other reason, consider the program because it has the edge on speed.

Learn a new language: Although it isn't absolutely necessary, it is advisable to learn the 4D programming language. By using it you enable greater flexibility within the program. Without this skill your database or application will be much less powerful. If you are the type that doesn't like to read manuals, you should at least browse through the 1600 pages. If you actually crack the manual and start reading you will pick up the language better. The 4D language, though simple, will knock FileMaker users to the ground. It is not one bit like the all-to-familiar ScriptMaker of FileMaker. Nor is the language anything like the incredibly simple HyperTalk. 4D's language is much like that of FoxPro. For novices this will be one more thing to learn. For seasoned professionals the power of the language will allow for significantly greater flexibility. Although some commands are missing, it is a rather mature programming language that empowers all users, novice or pro.

Final word: 4th Dimension is a great database for those who know databases. If you are a novice, then you will not be able to exploit as much of 4D's power as an experienced user would. You will still get incredible results. If you already own FileMaker then the decision to switch is an easy one. Even software developers will love it's expansive functionality using RAD.

Whether making a database, or options, time is always important. 4D gives users more speed and flexibility. If you are a seasoned professional, unhappy FileMaker user or a complete novice, you will find something useful in 4th Dimension.

Matthew Stoton, is a freelance writer, web designer and software developer. His site, Totally Macintosh, is at www.totallymac.8m.com. He also welcomes your comments or questions at rjsanddls@aol.com