Vampire Names
Yves
Ramon
Jonathan
Samuel
William
Sigfried
Mikhail
Phillip
Natasha
Lily
Elizabeth
Sondra
Naomi
Maria
Werewolf Names
Lucas
Carlos
Roger
Jack
Jason
Henry
Trevor
Martin
Katherine
Lucy
Maura
Angela
Sadie
Belinda
Dec 5, 2011
Aug 7, 2011
FileMaker Database Naming Conventions
A concise, consistent and unambiguous naming convention is important for any database development project, or indeed any software development project. Filemaker is no different, but there are a few specific aspects to Filemaker development that require special consideration.
Don't state what something is in its name. If you have a table of names, don't call it "tblNames" or "NamesTable" or something, just call it "Names". Since it's a table, it will only show up in places where tables are relevant, and extra
A concise, consistent and unambiguous naming convention is important for any database development project, or indeed any software development project. Filemaker is no different, but there are a few specific aspects to Filemaker development that require special consideration.
- Be specific. Avoid ambiguous or generic names at all costs. A total stranger should be able to read the names of your tables, fields, scripts, and layouts, and get a rough idea what they are for. Generic names should only be used for things that are truly generic, such as templates or loop counters, things that get reused in many different ways.
- Keep names short. This is especially important for naming tables and table occurrences in the relationship graph, and for names of layouts, because if your names are too long, the whole name may not be visible in the FM user interface, which can cause confusion and errors.
- If rules 1 and 2 conflict, go with rule 1.
- Avoid spaces. Filemaker will cheerfully allow you to use spaces in all sorts of places. At first, this may seem great, because it allows you to give things names that are very legible to humans. But there are many disadvantages to using spaces, especially when it comes to working with third-party platforms.
- Use Camel Case. Camel case is when you combine multiple words into a single name, and capitalize the first letter of each word. Like this: IAmGoingToTheStore. Even without spaces, it's easy to tell where words begin and end because of the case change.
- Use common or obvious abbreviations. Example: A field that holds the annual percentage rate can be called APR, but you wouldn't want to use PC to mean Postal Code, because it's not a widely known abbreviation.
- Use shorthand conventions to identify special pieces. Primary key field should always begin with the letters pk. Foreign keys should begin with fk.
- Use the underscore character at the start of field names that are calculated or otherwise derived from other data.
Don't state what something is in its name. If you have a table of names, don't call it "tblNames" or "NamesTable" or something, just call it "Names". Since it's a table, it will only show up in places where tables are relevant, and extra
Aug 6, 2011
A Handy Text Editing Tip
Here's a little tip that make editing code a bit easier. It's not guaranteed to work with all software, but it does work in a LOT of places.
Instead of pointing, clicking, and then dragging the mouse pointer to select a word of text, just point the mouse anywhere in the word, and double click it. On most popular platforms, doing this will instantly select the entire word. No need to pinpoint the exact spot where the word begins or ends, just double-click anywhere in it and you've got it selected.
Ok, you selected your word, now what? You want to replace it with another word? Just start typing. No need to delete first, because if you start typing when the word is selected, the entire selection will be replaced with whatever you type. If you want to replace the word with something in your clipboard, just hit PASTE after selecting the word. The paste operation will overwrite the selected text. No need to delete first, then paste.
What if you want to select the entire line? Try triple-clicking. In many cases, this will select an entire line, or even an entire paragraph.
This technique works when editing text in a word processor, editing cells in a spreadsheet, in a browser text box, and most other places where you can edit text. It even works when you're renaming a file in Windows Explorer or the Mac OS Finder.
Instead of pointing, clicking, and then dragging the mouse pointer to select a word of text, just point the mouse anywhere in the word, and double click it. On most popular platforms, doing this will instantly select the entire word. No need to pinpoint the exact spot where the word begins or ends, just double-click anywhere in it and you've got it selected.
Ok, you selected your word, now what? You want to replace it with another word? Just start typing. No need to delete first, because if you start typing when the word is selected, the entire selection will be replaced with whatever you type. If you want to replace the word with something in your clipboard, just hit PASTE after selecting the word. The paste operation will overwrite the selected text. No need to delete first, then paste.
What if you want to select the entire line? Try triple-clicking. In many cases, this will select an entire line, or even an entire paragraph.
This technique works when editing text in a word processor, editing cells in a spreadsheet, in a browser text box, and most other places where you can edit text. It even works when you're renaming a file in Windows Explorer or the Mac OS Finder.
Subscribe to:
Posts (Atom)