TweetFollow Us on Twitter

May 91 Letters
Volume Number:7
Issue Number:5
Column Tag:Letters

HyperCard Letters

By Kirk Chase, Editor

Databases views

Paul Whittington

Vice-President

Griffin Software, Inc.

1790 Vermont Dr., Elk Grove, Illinois 60007

708/ 893-7238

I was astonished to learn from Mr. Joseph Terry, Jr. that the first “real” database has just arrived in the Mac world. I think Oracle Corporation also must be surprised to hear that they do not have a “real” database.

Mr. Terry writes, “Remember that those old guys and gals really DID know something.” As one of those old guys with over 15 years of experience in data processing (that shows you how old I am - I still refer to it as data processing), I have had experience with databases from mainframes to micros.

In both his letter in the January, 1991 issue of MacTutor and his article in the February, 1991 issue, Mr. Terry expresses his opinion that a network database model is the best type of database for “serious” database systems. I think that a more enlightened opinion is that each database model has its strengths and weaknesses, and that a database’s appropriateness is dependent on the application employing it.

In a hierarchical database, data is linked from parent to child with the constraint that each child can have only one parent. The limitation is that you can only arbitrarily traverse the database from top to bottom. This works well when all of your data has a one to many relationship and has very few levels in the hierarchy. For example, an order system might have an order header with name and address information. Each order header can then point down to a line item for that order. This causes no problems because the line item is meaningless without the order header.

Hierarchical databases have been around since the late sixties. Network databases became popular after the Data Base Task Group of the Conference on Data Systems Languages (CODASYL-DBTG) issued a report defining a data management system that supports a complete network structure (April 1971). Since Mr. Terry did a thorough job explaining the network database structure, I won’t repeat that here. The big advantage that a network database has over a hierarchical one is that a child record can have more than one parent record and that you can go up and down between children and parents to your heart’s content. The disadvantage is that it is real easy to get lost in the database if you are not careful.

The relational database model is based on research done by E.F. Codd. The model is based on the mathematical foundation of relational algebra, which gets into relations, domains, degrees, and tuples. A more easily understood description defines a relation as a table with columns representing fields and rows representing records. Many of today’s popular databases are built on the relational foundation. The strength of a relational database is in its ability to extract and combine data in many flexible ways. Its disadvantage has always been the processing overhead that it imposes.

The best use of a relational database is in situations where you cannot anticipate the end-user’s needs. A database with sales information is a great example of the need for a relational database. Marketing people love to aggregate data by weird demographic information.

Furthermore, no database product conforms exclusively to any one model. Even Mr. Terry refers to his product as a network database with relational extensions. Every database product on the market has “extensions” to take advantage of features from another model.

I think that when we talk about “serious” databases, we are talking multi-user, client-server stuff. Mr. Terry should look at the Database Access Manager for System 7. This is going to have a huge influence on how applications access databases. It also defines how a database server must look to its clients and, more specifically, how Macintosh databases must look to applications.

(And now a word from our sponsor.)

For the past two years Griffin Software has had two database engines for the Macintosh that use HyperCard as a front end. HyperHIT is based on the hierarchical database model with a few whiz-bang extensions thrown in. HyperHIT-R is based on the relational database model. Both are available now through our publisher, SoftStream International, Inc. Currently in beta is the multi-user version which supports both HyperHIT and HyperHIT-R files. The expected release date for HyperHIT-N is the month of April.

Both HyperHIT and HyperHIT-R were designed with HyperCard in mind. They don’t have fixed length fields. They store data, except for sounds and pictures, as ASCII text, just as HyperCard does. HyperHIT-R allows for dynamic modifications of the database structure, without using separate utility programs (importData and exportData are two of the XCMDs). HyperHIT-R also allows for those bizarre queries that those marketing people think up. (Can you tell which users give me the most sleepless nights?) Such as, “all of the people in Illinois, Indiana and Iowa who have purchased the book DRUG USE IN THE WORKPLACE but have not purchased the book BODY FLUIDS”.

We would appreciate the opportunity to present an article showing our products’ strengths, as you have afforded to Mr. Terry.

[You are perfectly welcomed and urged to submit an article on your product. In today’s world, even small products must be strong to compete. Many people have turned to different aids to help them get more “bang for the buck”. Products like yours, Mr. Terry’s, MacApp, etc. are all out there for developers to use. Only desperate developers, though, purchase products they know little about, they do so in hopes the products will aid their effort. It is therefore imperative to have products reviewed and advertised.-ed]

Listing Correction

Kirk Chase

MacTutor

The header file “CRemoveLFApp.h” was inadvertently left out of Wade Maxfield’s article, “Designing With Objects” in the January 1991 MacTutor. Below is the listing.

/* 1 */

/*****
 * CRemoveLFApp.h
 *
 * Application class for a typical application.
 *
 *****/

#define _H_CRemoveLFApp   /* Include this file only once */
#include <CApplication.h>

struct CRemoveLFApp : CApplication 
 {
 /* No instance variables */

 void IRemoveLFApp(void);
 void SetUpFileParameters(void);
 void DoCommand(long theCommand);
 void Exit(void);
 void CreateDocument(void);
 void OpenDocument(SFReply *macSFReply);
 void Run(void); /* override of built in method */
};

Strip Style FKEY

Thomas Nielsen

Vacaville, CA

Lately, I’ve found myself repeatedly frustrated by the simple operation of copying and pasting text in HyperCard 2.0. The problem occurs when I go to paste the text. It seems that HyperCard (many other applications) now copy the style of the text as well as the text itself. This is great until you have to go to the different menus to set the font, size, and style. Here is the code for a short little FKEY that strips away the style from the scrap, leaving only text.

/* 2 */

Handle NewClearSysHandle(long size){
 asm{
 move.l size,d0
 NewHandleCLEAR+SYS
 move.l a0,d0
 }
 }
 
void main(void){
 long scrapsize, offset;
 Handle h;
 
 scrapsize=0L;
 h=0L;
 if (!(h=NewClearSysHandle(0)))
 goto returnpoint;
 scrapsize=GetScrap(h,’TEXT’,&offset);
 if (scrapsize>0){ 
 SetHandleSize(h,scrapsize+(scrapsize &1)); /*make Handle even size*/
 ZeroScrap();
 PutScrap(scrapsize,’TEXT’,*h);
 SystemEdit(3); /*  Tricky part */
 }
returnpoint:
 if (h)
 DisposHandle(h);
 }

See the call to SystemEdit(3)? Well it took me FOREVER to figure that one out. The system won’t recognize that the scrap has changed until you do it. I hope I’m not the only programmer out there that’s had problems with this one!

For Think C project

 Project type->Code Resource
 Type:  FKEY (all capitols)
 ID:  7 (this is also the number key that invokes FKEY)
 Attrs:  20 (purgable)
 File Type:  rsrc (ResEdit)
 Creator:  RSED (ResEdit)
 Name:  Strip Style FKEY

[The full project and listing are included in this month’s source disk.-ed]

Multi-user AppleTalk For HyperCard

Kirk Chase

MacTutor

Epsi Computer Systems, Inc. has announced epsiTalk. This is a development tool for adding AppleTalk support for HyperCard 2.0. Using epsiTalk, you can incorporate distributive processing and file serving among network stations. This makes it ideal for work groups, conferencing, and multi-user applications. There are two versions, epsiTalk and epsiTalk-EZ selling for $175 and $395 respectively.

EpsiTalk has the ability of creating quick, distributive processing by allowing you to control other epsiTalk entities on other, idle Macintoshes. It comes equipped with tools for handling file transfers and access. EpsiTalk also supports aborting and clearing transmissions midstream.

For more information, contact Robert Eppich or Randy Young at

Epsi Computer Systems, Inc.

209-1255 56th Street

Delta, British Columbia V4L 2B9

Canada

(604) 943-8664

 

Community Search:
MacTech Search:

Software Updates via MacUpdate

Airmail 3.3.2 - Powerful, minimal email...
Airmail is an mail client with fast performance and intuitive interaction. Support for iCloud, MS Exchange, Gmail, Google Apps, IMAP, POP3, Yahoo!, AOL, Outlook.com, Live.com. Airmail was designed... Read more
Numi 3.15.1 - Menu-bar calculator suppor...
Numi is a calculator that magically combines calculations with text, and allows you to freely share your computations. Numi combines text editor and calculator Support plain English. For example, '5... Read more
Airmail 3.3.2 - Powerful, minimal email...
Airmail is an mail client with fast performance and intuitive interaction. Support for iCloud, MS Exchange, Gmail, Google Apps, IMAP, POP3, Yahoo!, AOL, Outlook.com, Live.com. Airmail was designed... Read more
Numi 3.15.1 - Menu-bar calculator suppor...
Numi is a calculator that magically combines calculations with text, and allows you to freely share your computations. Numi combines text editor and calculator Support plain English. For example, '5... Read more
TextSoap 8.4.1 - Automate tedious text d...
TextSoap can automatically remove unwanted characters, fix up messed up carriage returns, and do pretty much anything else that we can think of to text. Save time and effort. Be more productive. Stop... Read more
TextSoap 8.4.1 - Automate tedious text d...
TextSoap can automatically remove unwanted characters, fix up messed up carriage returns, and do pretty much anything else that we can think of to text. Save time and effort. Be more productive. Stop... Read more
Backblaze 4.3.0.44 - Online backup servi...
Backblaze is an online backup service designed from the ground-up for the Mac. With unlimited storage available for $5 per month, as well as a free 15-day trial, peace of mind is within reach with... Read more
Numi 3.15 - Menu-bar calculator supports...
Numi is a calculator that magically combines calculations with text, and allows you to freely share your computations. Numi combines text editor and calculator Support plain English. For example, '5... Read more
EtreCheck 3.3.3 - For troubleshooting yo...
EtreCheck is an app that displays the important details of your system configuration and allow you to copy that information to the Clipboard. It is meant to be used with Apple Support Communities to... Read more
BusyContacts 1.1.8 - Fast, efficient con...
BusyContacts is a contact manager for OS X that makes creating, finding, and managing contacts faster and more efficient. It brings to contact management the same power, flexibility, and sharing... Read more

Latest Forum Discussions

See All

The best new games we played this week
We were quite busy this week. A bunch of big mobile games launched over the past few days, alongside a few teeny surprises. There're lots of quality games to load your phone with. We've gone and picked out five of our favorites for the week. [... | Read more »
Magikarp Jump beginner's guide
Magikarp Jump is a mystifying little game. Part Tamagotchi, part idle clicker, there's not a whole lot of video game there, per se, but for some reason we can't help coming back to it again and again. Your goal is to train up a little Magikarp to... | Read more »
Goat Simulator PAYDAY (Games)
Goat Simulator PAYDAY 1.0 Device: iOS Universal Category: Games Price: $4.99, Version: 1.0 (iTunes) Description: ** IMPORTANT - SUPPORTED DEVICES **iPhone 4S, iPad 2, iPod Touch 5 or better Goat Simulator: Payday is the most... | Read more »
GRID Autosport delayed until autumn
Sorry mobile racing fans -- GRID Autosport has been delayed a few months. The game is now expected to launch this fall on iOS. Feral Interactive announced that they wanted more time to work on the game's UI and overall performance before launching... | Read more »
Zombie Gunship Survival Beginner's...
The much anticipated Zombie Gunship Survival is here. In this latest entry in the Zombie Gunship franchise, you're tasked with supporting ground troops and protecting your base from the zombie horde. There's a lot of rich base building fun, and... | Read more »
Mordheim: Warband Skirmish (Games)
Mordheim: Warband Skirmish 1.2.2 Device: iOS Universal Category: Games Price: $3.99, Version: 1.2.2 (iTunes) Description: Explore the ruins of the City of Mordheim, clash with other scavenging warbands and collect Wyrdstone -... | Read more »
Mordheim: Warband Skirmish brings tablet...
Legendary Games has just launched Mordheim: Warband Skirmish, a new turn-based action game for iOS and Android. | Read more »
Magikarp Jump splashes onto Android worl...
If you're tired ofPokémon GObut still want something to satisfy your mobilePokémon fix,Magikarp Jumpmay just do the trick. It's out now on Android devices the world over. While it looks like a simple arcade jumper, there's quite a bit more to it... | Read more »
Purrfectly charming open-world RPG Cat Q...
Cat Quest, an expansive open-world RPG from former Koei-Tecmo developers, got a new gameplay trailer today. The video showcases the combat and exploration features of this feline-themed RPG. Cat puns abound as you travel across a large map in a... | Read more »
Jaipur: A Card Game of Duels (Games)
Jaipur: A Card Game of Duels 1.0 Device: iOS Universal Category: Games Price: $1.99, Version: 1.0 (iTunes) Description: ** WARNING: iPad 2, iPad Mini 1 & iPhone 4S are NOT compatible. ** *** Special Launch Price for a limited... | Read more »

Price Scanner via MacPrices.net

Memorial Day savings: 13-inch Touch Bar MacBo...
B&H Photo has the 2016 Apple 13″ Touch Bar MacBook Pros in stock today and on sale for up to $150 off MSRP. Shipping is free, and B&H charges NY & NJ sales tax only: - 13″ 2.9GHz/512GB... Read more
Apple refurbished 13-inch MacBook Airs availa...
Apple has Certified Refurbished 2016 13″ MacBook Airs available starting at $849. An Apple one-year warranty is included with each MacBook, and shipping is free: - 13″ 1.6GHz/8GB/128GB MacBook Air: $... Read more
Apple restocks refurbished 11-inch MacBook Ai...
Apple has Certified Refurbished 11″ MacBook Airs (the latest models recently discontinued by Apple), available for up to $170 off original MSRP. An Apple one-year warranty is included with each... Read more
12-inch 1.2GHz Retina MacBooks on sale for up...
B&H has 12″ 1.2GHz Retina MacBooks on sale for up to $150 off MSRP. Shipping is free, and B&H charges NY & NJ sales tax only: - 12″ 1.2GHz Space Gray Retina MacBook: $1449.99 $150 off... Read more
15-inch 2.7GHz Silver Touch Bar MacBook Pro o...
MacMall has the 15-inch 2.7GHz Silver Touch Bar MacBook Pro (MLW82LL/A) on sale for $2569 as part of their Memorial Day sale. Shipping is free. Their price is $230 off MSRP. Read more
Free Tread Wisely Mobile App Endorsed By Fath...
Just in time for the summer driving season, Cooper Tire & Rubber Company has announced the launch of a new Tread Wisely mobile app. Designed to promote tire and vehicle safety among teens and... Read more
Commercial Notebooks And Detachable Tablets W...
Worldwide shipments of personal computing devices (PCDs), comprised of traditional PCs (a combination of desktop, notebook, and workstations) and tablets (slates and detachables), are forecast to... Read more
Best value this Memorial Day weekend: Touch B...
Apple has Certified Refurbished 2016 15″ and 13″ MacBook Pros available for $230 to $420 off original MSRP. An Apple one-year warranty is included with each model, and shipping is free: - 15″ 2.6GHz... Read more
13-inch MacBook Airs on sale for up to $130 o...
Overstock.com has 13″ MacBook Airs on sale for up to $130 off MSRP including free shipping: - 13″ 1.6GHz/128GB MacBook Air (sku MMGF2LL/A): $869.99 $130 off MSRP - 13″ 1.6GHz/256GB MacBook Air (sku... Read more
2.8GHz Mac mini available for $973 with free...
Adorama has the 2.8GHz Mac mini available for $973, $16 off MSRP, including a free copy of Apple’s 3-Year AppleCare Protection Plan. Shipping is free, and Adorama charges sales tax in NY & NJ... Read more

Jobs Board

*Apple* Retail - Multiple Positions - Apple,...
Job Description: Sales Specialist - Retail Customer Service and Sales Transform Apple Store visitors into loyal Apple customers. When customers enter the store, Read more
*Apple* Media Products - Commerce Engineerin...
Apple Media Products - Commerce Engineering Manager Job Number: 57037480 Santa Clara Valley, California, United States Posted: Apr. 18, 2017 Weekly Hours: 40.00 Job Read more
*Apple* Media Products - Commerce Engineerin...
Apple Media Products - Commerce Engineering Manager Job Number: 57037480 Santa Clara Valley, California, United States Posted: Apr. 18, 2017 Weekly Hours: 40.00 Job Read more
Best Buy *Apple* Computing Master - Best Bu...
**509643BR** **Job Title:** Best Buy Apple Computing Master **Location Number:** 001482- Apple Valley-Store **Job Description:** **What does a Best Buy Apple Read more
*Apple* Media Products - Commerce Engineerin...
Apple Media Products - Commerce Engineering Manager Job Number: 57037480 Santa Clara Valley, California, United States Posted: Apr. 18, 2017 Weekly Hours: 40.00 Job Read more
All contents are Copyright 1984-2011 by Xplain Corporation. All rights reserved. Theme designed by Icreon.