Object-Influenced Design & FileMaker Pro
If you didn’t get a chance to see Corn Walker’s DevCon presentation this year, you’ve missed out on an important foray into a topic close to my heart, Object Oriented (influenced) design and FileMaker Pro. Corn really gets into the "how". I am simply going to introduce the main concepts below. Hopefully I can persuade him to extend this discussion with a treatise of his own after he has put with his treehouse-building adventures behind.
First, when I talk about object-orientation, I am speaking of a way to think about your database application from a design perspective. This isn’t primarily about how you write scripts or "program" in FileMaker Pro. Rather, object orientation is the starting point of good application design.
Functional Specifications Howto
Allen Smith of mojofat has written a wonderfully concise yet and useful tutorial on how to write a functional specification. It is a bit web-centric but I think it applies nicely to any application design process, particularly those that are information centric.
A Few Tidbits From The Under The Hood Sessions
As i promised in the earlier post "What I Learned At DEVCON" here are a few tidbits from the 2 Under the Hood sessions plus the Server Admin Under The Hood done by the SE’s and Server Team.
1. Do not continue to use recovered files.
2. The best CPU for FileMaker Server, especially if using Server Advanced, is a "medium powered" dual processor machine with 10K RPM SCSI drives. Use RAID where needed.
3. Be sure to turn off Disk Indexing and Shadow Copy and enable data throughput for network apps, not file services.
4. Nested or multiply referenced unstored calculations will result in many dependency re-evaluations and affect performance. Use Let function to prevent multiple re-evaluations.
5. FileMaker Servers should be rebooted at least once a week.
6. FileMaker Server is highly dependent on the underlying OS of the Server.
7. Do not activate automatic updates (Server patches, etc.) Automatic notification is OK, but do not install automatically as they require reboots that can cause problems for the files.
8. For the most part with modern CPU’s, set the server cache to the maximum amount and the flush interval to 1 minute. (Besides if the processor can’t handle 13 to 15MB flush per second to the drive, then you got other issues anyway.)
9. Segment the drives or use multiple drives for Server. OS on drive 1; data on drive 2; backups on drive 3.
10. Index is specific to the data type in FMP. And for all data types data are stored as compressed Unicode.
Steven H. Blackwell
What I Learned At DEVCON
What I Learned At DEVCON
The 11th FileMaker Developer Conference concluded the other day. It was held in Orlando, Florida, this year at a venue leagues improved from its last East Coast outing in 2001.
I learned quite a few things at this DEVCON, and I thought I’d share some of them, in no particular order of significance.
1. Developers voted with their feet and chose workshops rather than more formalized sessions except for the three “Under the Hood” ones. This is no surprise to those in the developer community. Several of the workshops were oversubscribed by factors of 150% to 200%, even while some formal sessions were 75% empty. Special kudos to Chris Moyer for doing an unanticipated v-rev of his workshop when he had to turn away over 100 folks from the first version.
2. The three “Under The Hood” sessions done by various of the engineers were excellent, and they imparted a good deal of useful information. And I will excerpt some of that in a separate entry.
3. Andy Gaunt of FMPUG fame is possibly the greatest showman since the late Phineas T. Barnum. His FileMaker Excellence Award is also extraordinarily well–deserved. See http://www.fmpug.com
4. The unfortunate theft of a laptop computer during the conference lead to detailed discussions of laptop and software security. Laptop computers are attractive items to steal. This is very bad for their owners. Such computers need multiple layers of protection for their contents and for their FileMaker Pro databases, including strong OS-level passwords and hardening and strong FileMaker Pro-level Accounts and passwords.
5. There appears to be an infinite variety of ways to serve chicken at conference meal functions, save only Southern fried. The latter style is, of course, the one much beloved from a childhood in the mountains of East Tennessee and the one most longed for today.
6. Several FileMaker, Inc. Engineers and Product Managers could give up their careers in the software industry and become highly successful emcees of television shows or comedians in nightclubs. Some of these guys are really funny, and they are really good performers.
7. Some conference organizers cannot correctly count the number of conferences held over time. On the other hand, an Exacto knife and a strip of clear tape can convert a 10 year badge to an 11 year badge, proving that the Village Elder can still improvise when needed.
8. I think I am a very honest fellow with the ability to safeguard all manner of (sometimes very highly) confidential information. That said, and even when other people agree with my glowing opinion of my own trustworthiness, I doubt that many developers would just walk up and give me their server administrative passwords, email passwords, PIN numbers, and similar information. I doubt they would even if they know that I can be trusted with this information. Given that, why then did some people broadcast that very same information in clear text over an unsecured wireless network and make it susceptible to interception by some war zoner who could have been sitting outside in the guest parking lot? If they weren’t using a VPN or some method of encryption, their Account Names and passwords could have been intercepted.
9. A lightening strike on a conference center is not conducive to the proper and effective functioning of switches and Internet connections. Nor apparently does it enhance the ability of technically trained personnel from the relevant ISP to repair them and restore Internet access functionality in a reliable fashion. In the information security profession we refer to a concept called “defense–in–depth” that provides overlapping and redundant defenses against various threats. Perhaps this concept ought travel over to the ISP community in Orlando as well.
10. Finally, there is supersonic. And there is also hypersonic. And then there is Andrew LeCates, Senior Director of System Engineers. Even if you can only catch every tenth word of a LeCates presentation, it’s still worth more than every word of 99 percent of other presentations. There will be a special pre-DEVCON Seminar in 2007 on Hyper Listening techniques. Andrew LeCates is beyond a treasure to the FileMaker Developer community; he is beyond a core asset. He is the true linchpin.
Steven H. Blackwell