TweetFollow Us on Twitter

Apr 98 MacTech Online

Volume Number: 14 (1998)
Issue Number: 4
Column Tag: MacTech Online

MacTech Online

by Jeff Clites, online@mactech.com

Whoever first said, "It's a small world," must not have been shopping for a database. There is a lot out there, probably because the idea of a database is one of the most fundamental and powerful concepts in computing. After all, what do computers do if not manipulate, store, and retrieve data? At its simplest, a database can be just a file system. On another level, it can be a mechanism for providing object persistence. And on a larger scale, it can be a repository of information to be accessed remotely from thousands of locations and multiple platforms. To help make sense of it all, we're going to take a quick tour of this vast landscape. Since several of the big tourist spots are reviewed elsewhere in this issue, we're going to visit a few of the more intimate, out of the way spots that might otherwise be missed.

Don't Forget to Write Home

As with all trips, it can be surprising how many things there are to see right at home -- and in this case, home is Apple. Developer World has an extensive list of products available for the Macintosh for client/server and database development. It's over a year old, but still provides a wealth of information about just what is out there, and it gives brief explanations of some of the terminology involved along the way. There is also the MacODBC SDK, which uses a shared library to provide a generalized API for interacting with databases.

While you're in the Apple domain, stop by the AppleScript site, where there is a tutorial on database publishing. They use FileMaker Pro and QuarkXPress to demonstrate how AppleScript can be used to bring the services of a database to another scriptable application. It's a good place to start convincing yourself that AppleScript really can be used by serious developers.

Here's one of the best kept secrets of the Mac OS: Apple has cautioned developers that the resource manager is not a database. But, then they "thought different" and provided the Dictionary Manager, which is. It's designed to provide a reusable format for dictionaries used by input methods for 2-byte script systems, but it can also be used for other lightweight database tasks. If you can handle its restrictions (keys at most 129 bytes, records at most 4096 bytes, and a total database of less than 16MB) or are just getting your feet wet with database programming, then it can provide a simple, free, and always available alternative to third-party packages. It's documented in Inside Macintosh: Text.

Client/Server and Database Development Tools for the Macintosh
http://devtools.apple.com/general/Guide2MacTools/csdatabase.html
Apple Software Development Kits
http://devworld.apple.com/ngs/lpp/adrpub/docs/dev/sdk.html
Database Publishing Lessons
http://applescript.apple.com/applescript_overview/dbase_lessons/DBASE_LESSON.00.HTML
The Dictionary Manager
http://gemma.apple.com/dev/techsupport/insidemac/Text/Text-483.html

Learn the Language

The database market comes with its own set of lingo and acronyms. If you're a little befuddled by terms such as SQL, ODBC, DBMS, and 4GL, then the Free On-line Dictionary of Computing can help.

But when you want to start getting down to serious business, it's time to learn the to talk directly to your database -- like a native. Fortunately, there is a standard language, which is used by many (but certainly not all) commercial databases. It's SQL, the Structured Query Language, and it's spoken by the big boys, Oracle, Sybase, and Informix, as well as by others. For the brave, there is an online tutorial and an FAQ, but the most useful resource may be the "Ask the SQL Pro" site, which can help answer your questions as you learn the language.

Free On-line Dictionary of Computing
http://wfn-shop.princeton.edu/cgi-bin/foldoc
SQL Tutorial
http://w3.one.net/~jhoffman/sqltut.htm
SQL FAQ
http://epoch.CS.Berkeley.EDU:8000/sequoia/dba/montage/FAQ/SQL_TOC.html
Ask the SQL Pro
http://www.inquiry.com/techtips/thesqlpro/

Planning Your Next Trip

There are two things certain to be in the future of any Mac programmer: Rhapsody, and Java. You can't hide from them forever. Fortunately, both come ready-made to interact with database servers. Rhapsody has the Enterprise Objects Framework, which allows your applications to interface with relational databases, and which most notably allows WebObjects applications to interact with a database in an object-oriented manner. Rhapsody is also slated to ship with a free version of the OpenBase SQL database engine.

For Java developers, life is good, because there is an SQL database interface which forms a standard part of Java, and which is included in the JDK 1.1. It's the JDBC API, and you can find out all about it on Sun's Java site.

Documentation for Internet/Enterprise Programmers
http://gemma.apple.com/techinfo/techdocs/enterprise/enterprise.html
WebObjects 3.5 Documentation
http://gemma.apple.com/techinfo/techdocs/enterprise/WebObjects/WebObjectsTOC.html
Creating a WebObjects Database Application
http://gemma.apple.com/techinfo/techdocs/enterprise/WebObjects/GettingStarted/Movies/MoviesTOC.html
OpenBase International, Ltd.
http://www.openbase.com/
The JDBC(tm) Database Access API
http://java.sun.com/products/jdbc/index.html

These and other links are available from the MacTech Online web pages at www.mactech.com/online/.

 

Community Search:
MacTech Search:

Software Updates via MacUpdate

Black Hole Joyrider (Games)
Black Hole Joyrider 1.0 Device: iOS Universal Category: Games Price: $2.99, Version: 1.0 (iTunes) Description: Guide your spacecraft through the gravity well of a powerful black hole using only your retro-thrusters and dwindling fuel... | Read more »
My Koi (Games)
My Koi 1.0 Device: iOS iPhone Category: Games Price: $1.99, Version: 1.0 (iTunes) Description: My Koi is a beautiful and relaxing fish pond app. Customise and name each fish. Feed them daily. Watch them grow. Collect new fish.... | Read more »
Never Gone (Games)
Never Gone 1.0.2 Device: iOS Universal Category: Games Price: $2.99, Version: 1.0.2 (iTunes) Description: ###IMPPORTANT### Never Gone's HD art resources require devices with more than 1GB RAM, so please note that iPhone 4/4s, iPad 2/... | Read more »
INKS. (Games)
INKS. 1.0 Device: iOS Universal Category: Games Price: $1.99, Version: 1.0 (iTunes) Description: From the makers of BAFTA-winning Lumino City comes INKS. INKS updates pinball for a new generation. It combines the joy of pinball with... | Read more »
How to maximise your profits in Bakery B...
Running a bakery can be an expensive venture. You’ll need to continuously upgrade your oven, your kitchen supplies, and even your ingredients to keep customers happy. Most of these renovations in Bakery Blitz cost a pretty penny, but we have a few... | Read more »
How to manage your time in Bakery Blitz
It can be tricky, especially when you risk burning your kitchen to the ground if you forget a cake in the oven, so make sure to use these time management tricks to keep your bakery running smoothly. Don’t collect the money right away [Read more] | Read more »
Model 15 (Music)
Model 15 1.0 Device: iOS iPhone Category: Music Price: $29.99, Version: 1.0 (iTunes) Description: The Moog Model 15 App is the first Moog modular synthesizer and synthesis educational tool created exclusively for iPad, iPhone and... | Read more »
How to deal with wind in Angry Birds Act...
Angry Birds Action! is a physics-based puzzler in which you're tasked with dragging and launching birds around an obstacle-littered field to achieve a set objective. It's simple enough at first, but when wind gets introduced things can get pretty... | Read more »
How to get three stars in every level of...
Angry Birds Action! is, essentially, a pinball-style take on the pull-and-fling action of the original games. When you first boot it up, you'll likely be wondering exactly what it is you have to do to get a good score. Well, never fear as 148Apps... | Read more »
The beginner's guide to Warbits
Warbits is a turn-based strategy that's clearly inspired by Nintendo's Advance Wars series. Since turn-based strategy games can be kind of tricky to dive into, see below for a few tips to help you in the beginning. Positioning is crucial [Read... | Read more »

Price Scanner via MacPrices.net

12-inch 128GB iPad Pros on sale for up to $10...
B&H Photo has 12″ 128GB WiFi iPad Pros on sale for up to $100 off MSRP, each including free shipping. B&H charges sales tax in NY only: - 12″ Space Gray 128GB WiFi iPad Pro: $899 $50 off MSRP... Read more
Global Tablet Sales Slump Continues, iPad’s F...
Another miserable showing for the global slate tablet category in calendar Q1/16, with global tablet shipments falling another 1ten percent to 46.5 million units during the according to Strategy... Read more
Revel Systems to Showcase iPad POS Platform w...
Revel Systems, specialists in iPad Point of Sale management solution for brick-and-mortar retail, food businesses and more, today announced that it will showcase its innovative iPad Point of Sale... Read more
13-inch 2.5GHz MacBook Pro on sale for $999,...
B&H Photo has the 13″ 2.5GHz MacBook Pro on sale for $999 including free shipping plus NY sales tax only. Their price is $100 off MSRP. Read more
Apple refurbished 2015 iMacs available for up...
Apple now has a full line of Certified Refurbished 2015 21″ & 27″ iMacs available for up to $350 off MSRP. Apple’s one-year warranty is standard, and shipping is free. The following models are... Read more
Indian Smartphone Market Grows Annually by 12...
India’s smartphone market grew by 12 percent year-over-year, with 24.4 million units shipping in Q1 2016. The top five vendors stayed the same, with Samsung in the lead, followed by Micromax, Intex... Read more
Get Notifications When Your Friend’s Phone Ba...
Calgary, Canada based Stonelight Pictures has announced the release of Battery Share 1.0.1, its new utility for iOS 9 supported devices. The company notes that people are spending more time on their... Read more
11-inch 1.6GHz/128GB MacBook Air on sale for...
Amazon has the current-generation 11″ 1.6GHz/128GB MacBook Air (sku MJVM2LL/A) on sale for $749.99 for a limited time. Their price is $150 off MSRP, and it’s the lowest price available for this model... Read more
Price drops on clearance 2015 13-inch MacBook...
B&H Photo has dropped prices on clearance 2015 13″ MacBook Airs by up to $250. Shipping is free, and B&H charges NY sales tax only: - 13″ 1.6GHz/4GB/128GB MacBook Air (MJVE2LL/A): $799, $200... Read more
Mac minis on sale for up to $100 off MSRP
B&H Photo has Mac minis on sale for up to $100 off MSRP including free shipping plus NY sales tax only: - 1.4GHz Mac mini: $449 $50 off MSRP - 2.6GHz Mac mini: $649 $50 off MSRP - 2.8GHz Mac mini... Read more

Jobs Board

*Apple* Retail - Multiple Positions (US) - A...
Job Description: Sales Specialist - Retail Customer Service and Sales Transform Apple Store visitors into loyal Apple customers. When customers enter the store, Read more
Restaurant Manager (Neighborhood Captain) - A...
…in every aspect of daily operation. WHY YOU'LL LIKE IT: You'll be the Big Apple . You'll solve problems. You'll get to show your ability to handle the stress and Read more
Automotive Sales Consultant - Apple Ford Linc...
…you. The best candidates are smart, technologically savvy and are customer focused. Apple Ford Lincoln Apple Valley is different, because: $30,000 annual salary Read more
Restaurant Manager (Neighborhood Captain) - A...
…in every aspect of daily operation. WHY YOU'LL LIKE IT: You'll be the Big Apple . You'll solve problems. You'll get to show your ability to handle the stress and Read more
Simply Mac *Apple* Specialist- Service Repa...
Simply Mac is the largest premier retailer of Apple products in the nation. In order to support our growing customer base, we are currently looking for a driven Read more
All contents are Copyright 1984-2011 by Xplain Corporation. All rights reserved. Theme designed by Icreon.