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/.

 
AAPL
$519.01
Apple Inc.
+1.05
MSFT
$40.40
Microsoft Corpora
+0.65
GOOG
$556.54
Google Inc.
+20.10

MacTech Search:
Community Search:

Software Updates via MacUpdate

PDFpenPro 6.2 - Advanced PDF toolkit for...
PDFpenPro allows users to edit PDF's easily. Add text, images and signatures. Fill out PDF forms. Merge or split PDF documents. Reorder and delete pages. Even correct text and edit graphics! Create... Read more
PDFpen 6.2 - Edit and annotate PDFs with...
PDFpen allows users to easily edit PDF's. Add text, images and signatures. Fill out PDF forms. Merge or split PDF documents. Reorder and delete pages. Even correct text and edit graphics! Features... Read more
Monolingual 1.5.9 - Remove unwanted OS X...
Monolingual is a program for removing unnecesary language resources from OS X, in order to reclaim several hundred megabytes of disk space. It requires a 64-bit capable Intel-based Mac and at least... Read more
Maya 2015 - Professional 3D modeling and...
Maya is an award-winning software and powerful, integrated 3D modeling, animation, visual effects, and rendering solution. Because Maya is based on an open architecture, all your work can be scripted... Read more
Starcraft II: Wings of Liberty 1.1.1.180...
Download the patch by launching the Starcraft II game and downloading it through the Battle.net connection within the app. Starcraft II: Wings of Liberty is a strategy game played in real-time. You... Read more
Sibelius 7.5.0 - Music notation solution...
Sibelius is the world's best-selling music notation software for Mac. It is as intuitive to use as a pen, yet so powerful that it does most things in less than the blink of an eye. The demo includes... Read more
Typinator 5.9 - Speedy and reliable text...
Typinator turbo-charges your typing productivity. Type a little. Typinator does the rest. We've all faced projects that require repetitive typing tasks. With Typinator, you can store commonly used... Read more
MYStuff Pro 2.0.16 - Create inventories...
MYStuff Pro is the most flexible way to create detail-rich inventories for your home or small business. Add items to MYStuff by dragging and dropping existing information, uploading new images, or... Read more
TurboTax 2013.r17.002 - Manage your 2013...
TurboTax guides you through your tax return step by step, does all the calculations, and checks your return for errors and overlooked deductions. It lets you file your return electronically to get... Read more
TrailRunner 3.8.769 - Route planning for...
Note: While the software is classified as freeware, it is actually donationware. Please consider making a donation to help support development. TrailRunner is the perfect companion for runners,... Read more

Latest Forum Discussions

See All

Hitman GO (Games)
Hitman GO 1.2 Device: iOS Universal Category: Games Price: $4.99, Version: 1.2 (iTunes) Description: Get your daily fix of Agent 47 with this elegant, strategy-based Hitman game! | Read more »
The Seventh Sign: Hodappy Bird Released...
The Seventh Sign: Hodappy Bird Released on the App Store Posted by Jeff Scott on April 16th, 2014 [ permalink ] Universal App - Designed for iPhone and iPad | Read more »
Rogue Heroes (Games)
Rogue Heroes 1.0 Device: iOS Universal Category: Games Price: $1.99, Version: 1.0 (iTunes) Description: Rogue Heroes is awesome fast-paced 2D action-platforming roguelike game with RPG elements. - explore the depth of procedurally... | Read more »
Fourcast Review
Fourcast Review By Jennifer Allen on April 16th, 2014 Our Rating: :: VIDEO POTENTIALiPhone App - Designed for the iPhone, compatible with the iPad Fourcast is a great idea for combining video clips, but it does lack a number of... | Read more »
Hearthstone: Heroes of Warcraft is Avail...
Hearthstone: Heroes of Warcraft is Available on the U.S. App Store Right Now – Gogogogo! Posted by Rob Rich on April 16th, 2014 [ permalink ] | Read more »
Grammar Pop HD Review
Grammar Pop HD Review By Jennifer Allen on April 16th, 2014 Our Rating: :: FUN LEARNINGiPad Only App - Designed for the iPad Learning the different parts of speech isn’t always fun, but Grammar Pop HD makes it much more... | Read more »
Groundskeeper2 Review
Groundskeeper2 Review By Nadia Oxford on April 16th, 2014 Our Rating: :: SLICE THOSE ALIEN SLIMEUniversal App - Designed for iPhone and iPad Putting aside some minor control issues, Groundskeeper2 is a fun and furious action/... | Read more »
Pinnacle Studio for iPhone (Photography...
Pinnacle Studio for iPhone 5.0 Device: iOS iPhone Category: Photography Price: $9.99, Version: 5.0 (iTunes) Description: | Read more »
Season 3 of Zombies, Run! Starts Right N...
Season 3 of Zombies, Run! | Read more »
Snupps Review
Snupps Review By Jennifer Allen on April 16th, 2014 Our Rating: :: USEFUL LISTINGUniversal App - Designed for iPhone and iPad Got a huge collection that you need to organize, or just want to share with others? Snupps has it covered... | Read more »

Price Scanner via MacPrices.net

Microsoft Blinks – Drops Microsoft Office 365...
Microsoft has dropped the annual subscription fee for Microsoft Office 365 Personal – which is needed in order to create and edit documents in Microsoft Office for iPad. However, Apple’s iOS and OS X... Read more
New AVG Vault Apps for iOS and Android Help K...
AVG Technologies N.V. an online security company for 177 million active users, has announced the launch of its latest mobile application, AVG Vault. The free app introduces an innovative user... Read more
Free Local Carrot iPhone App Helps Find Fresh...
I love fresh vegetables. I’m not a vegan, although I was for several years in the 1980s, but fresh vegetables and other whole foods are still my dietary mainstays as a matter of taste rather than... Read more
Apple refurbished iPad Airs available startin...
Apple is now offering Certified Refurbished iPad Airs for up to $140 off MSRP. Apple’s one-year warranty is included with each model, and shipping is free. The following Airs are available today: -... Read more
21-inch 2.7GHz iMac on sale for $1179, save $...
B&H Photo has the 21″ 2.7GHz iMac on sale for $1179 including free shipping plus NY sales tax only. Their price is $120 off MSRP. Add an iMac to your shopping cart, and B&H will offer an... Read more
Download our app, iTracx, for iOS and Android
MacPrices is proud to offer readers a free iOS app (iPhones, iPads, & iPod touch) and Android app (Google Play and Amazon App Store) called iTracx, which allows you to glance at today’s lowest... Read more
Education discounts shave up to $300 off the...
Purchase a new Mac at The Apple Store for Education and take up to $300 off MSRP. All teachers, students, and staff of any educational institution qualify for the discount. Shipping is free, and all... Read more
Save $50 on Mac mini Server
B&H Photo has the 2012 Mac mini Server on sale for $949 including free shipping plus NY sales tax only. Their price is $50 off MSRP. Read more
PhatWare’s “Ultimate Writing App For iOS” Ren...
PhatWare Corp. has announced it has renamed its new WritePro word processing app for iPhone and iPad: WritePad Pro. The decision to change the app’s name to leverages the strong brand awareness and... Read more
Full Resolution Photo Editor Tint Mint 1.0 Re...
California based independent developer, Jeffrey Sun, creator of the iOS app Modern Editor, has released Tint Mint, a new photography app for editing enthusiasts. The app costs a dollar, and it packs... Read more

Jobs Board

*Apple* Retail - Manager - Holyoke - Apple I...
Job Summary Keeping an Apple Store thriving requires a diverse set of leadership skills, and as a Manager, you’re a master of them all. In the store’s fast-paced, Read more
*Apple* Retail - Manager - Apple (United Sta...
Job SummaryKeeping an Apple Store thriving requires a diverse set of leadership skills, and as a Manager, you're a master of them all. In the store's fast-paced, dynamic Read more
*Apple* Solutions Consultant (ASC) - Apple (...
**Job Summary** The ASC is an Apple employee who serves as an Apple brand ambassador and influencer in a Reseller's store. The ASC's role is to grow Apple Read more
*Apple* Retail - Market Leader - Cincinnati...
…challenges of developing individuals, building teams, and affecting growth across Apple Stores. You demonstrate successful leadership ability - focusing on excellence Read more
*Apple* Retail - Manager - SoHo - Apple (Uni...
Job SummaryKeeping an Apple Store thriving requires a diverse set of leadership skills, and as a Manager, you're a master of them all. In the store's fast-paced, dynamic Read more
All contents are Copyright 1984-2011 by Xplain Corporation. All rights reserved. Theme designed by Icreon.