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

GraphicConverter 10.5.1 - $39.95
GraphicConverter is an all-purpose image-editing program that can import 200 different graphic-based formats, edit the image, and export it to any of 80 available file formats. The high-end editing... Read more
Delicious Library 3.7 - Import, browse a...
Delicious Library allows you to import, browse, and share all your books, movies, music, and video games with Delicious Library. Run your very own library from your home or office using our... Read more
Adobe Animate CC 2017 18.0.0.107 - Anima...
Animate CC 2018 is available as part of Adobe Creative Cloud for as little as $19.99/month (or $9.99/month if you're a previous Flash Professional customer). Animate CC 2018 (was Flash CC) lets you... Read more
Adobe After Effects CC 2018 15.0 - Creat...
After Effects CC 2018 is available as part of Adobe Creative Cloud for as little as $19.99/month (or $9.99/month if you're a previous After Effects customer). The new, more connected After Effects CC... Read more
Adobe Premiere Pro CC 2018 12.0.0 - Digi...
Premiere Pro CC 2018 is available as part of Adobe Creative Cloud for as little as $19.99/month (or $9.99/month if you're a previous Premiere Pro customer). Adobe Premiere Pro CC 2018 lets you edit... Read more
Alarm Clock Pro 10.3 - $19.95
Alarm Clock Pro isn't just an ordinary alarm clock. Use it to wake you up in the morning, send and compose e-mails, remind you of appointments, randomize the iTunes selection, control an internet... Read more
Adobe Lightroom 20170919-1412-ccb76bd] -...
Adobe Lightroom is available as part of Adobe Creative Cloud for as little as $9.99/month bundled with Photoshop CC as part of the photography package. Lightroom 6 is also available for purchase as a... Read more
Adobe Illustrator CC 2018 22.0.0 - Profe...
Illustrator CC 2018 is available as part of Adobe Creative Cloud for as little as $19.99/month (or $9.99/month if you're a previous Illustrator customer). Adobe Illustrator CC 2018 is the industry... Read more
Hopper Disassembler 4.3.0- - Binary disa...
Hopper Disassembler is a binary disassembler, decompiler, and debugger for 32- and 64-bit executables. It will let you disassemble any binary you want, and provide you all the information about its... Read more
Adobe InDesign CC 2018 13.0.0.125 - Prof...
InDesign CC 2018 is available as part of Adobe Creative Cloud for as little as $19.99/month (or $9.99/month if you're a previous InDesign customer). Adobe InDesign CC 2018 is part of Creative Cloud.... Read more

ICEY (Games)
ICEY 1.0 Device: iOS Universal Category: Games Price: $2.99, Version: 1.0 (iTunes) Description: ICEY is a 2D side-scrolling action game. As you follow the narrator's omnipresent voice, you will see through ICEY's eyes and learn the... | Read more »
The best new games we played this week -...
We've made it, folks. Another weekend is upon us. It's time to sit back and relax with the best new releases of the week. Puzzles, strategy RPGs, and arcade games abound this week. There's a lot of quality stuff to unpack this week, so let's hop... | Read more »
Wheels of Aurelia (Games)
Wheels of Aurelia 1.0.1 Device: iOS Universal Category: Games Price: $3.99, Version: 1.0.1 (iTunes) Description: | Read more »
Halcyon 6: Starbase Commander guide - ti...
Halcyon 6 is a well-loved indie RPG with stellar tactical combat and some pretty good writing, too. It's now landed on the App Store, so mobile fans, if you're itching for a good intergalactic adventure, here's your game. Being a strategy RPG, the... | Read more »
Game of Thrones: Conquest guide - how to...
Fans of base building games might be excited to know that yet another entry in the genre has materialized - Game of Thrones: Conquest. Yes, you can now join the many kingdoms of the famed book series, or create your own, as you try to conquer... | Read more »
Halcyon 6: Starbase Commander (Games)
Halcyon 6: Starbase Commander 1.4.2.0 Device: iOS Universal Category: Games Price: $6.99, Version: 1.4.2.0 (iTunes) Description: An epic space strategy RPG with base building, deep tactical combat, crew management, alien diplomacy,... | Read more »
Legacy of Discord celebrates its 1 year...
It’s been a thrilling first year for fans of Legacy of Discord, the stunning PvP dungeon-crawling ARPG from YOOZOO Games, and now it’s time to celebrate the game’s first anniversary. The developers are amping up the festivities with some exciting... | Read more »
3 reasons to play Thunder Armada - the n...
The bygone days of the Battleship board game might have past, but naval combat simulators still find an audience on mobile. Thunder Armada is Chinese developer Chyogames latest entry into the genre, drawing inspiration from the explosive exchanges... | Read more »
Experience a full 3D fantasy MMORPG, as...
Those hoping to sink their teeth into a meaty hack and slash RPG that encourages you to fight with others might want to check out EZFun’s new Eternity Guardians. Available to download for iOS and Android, Eternity Guardians is an MMORPG that lets... | Read more »
Warhammer Quest 2 (Games)
Warhammer Quest 2 1.0 Device: iOS Universal Category: Games Price: $4.99, Version: 1.0 (iTunes) Description: Dungeon adventures in the Warhammer World are back! | Read more »

Price Scanner via MacPrices.net

9″ iPads on sale for $30 off, starting at $29...
MacMall has 9″ iPads on sale for $30 off including free shipping: – 9″ 32GB iPad: $299 – 9″ 128GB iPad: $399 Read more
Apple restocks full line of refurbished 13″ M...
Apple has restocked a full line of Apple Certified Refurbished 2017 13″ MacBook Pros for $200-$300 off MSRP. A standard Apple one-year warranty is included with each MacBook, and shipping is free.... Read more
13″ 3.1GHz/256GB MacBook Pro on sale for $167...
Amazon has the 2017 13″ 3.1GHz/256GB Space Gray MacBook Pro on sale today for $121 off MSRP including free shipping: – 13″ 3.1GHz/256GB Space Gray MacBook Pro (MPXV2LL/A): $1678 $121 off MSRP Keep an... Read more
13″ MacBook Pros on sale for up to $120 off M...
B&H Photo has 2017 13″ MacBook Pros in stock today and on sale for up to $120 off MSRP, each including free shipping plus NY & NJ sales tax only: – 13-inch 2.3GHz/128GB Space Gray MacBook... Read more
15″ MacBook Pros on sale for up to $200 off M...
B&H Photo has 15″ MacBook Pros on sale for up to $200 off MSRP. Shipping is free, and B&H charges sales tax in NY & NJ only: – 15″ 2.8GHz MacBook Pro Space Gray (MPTR2LL/A): $2249, $150... Read more
Roundup of Apple Certified Refurbished iMacs,...
Apple has a full line of Certified Refurbished 2017 21″ and 27″ iMacs available starting at $1019 and ranging up to $350 off original MSRP. Apple’s one-year warranty is standard, and shipping is free... Read more
Sale! 27″ 3.8GHz 5K iMac for $2098, save $201...
Amazon has the 27″ 3.8GHz 5K iMac (MNED2LL/A) on sale today for $2098 including free shipping. Their price is $201 off MSRP, and it’s the lowest price available for this model (Apple’s $1949... Read more
Sale! 10″ Apple WiFi iPad Pros for up to $100...
B&H Photo has 10.5″ WiFi iPad Pros in stock today and on sale for $50-$100 off MSRP. Each iPad includes free shipping, and B&H charges sales tax in NY & NJ only: – 10.5″ 64GB iPad Pro: $... Read more
Apple iMacs on sale for up to $130 off MSRP w...
B&H Photo has 21-inch and 27-inch iMacs in stock and on sale for up to $130 off MSRP including free shipping. B&H charges sales tax in NY & NJ only: – 27″ 3.8GHz iMac (MNED2LL/A): $2179 $... Read more
2017 3.5GHz 6-Core Mac Pro on sale for $2799,...
B&H Photo has the 2017 3.5GHz 6-Core Mac Pro (MD878LL/A) on sale today for $2799 including free shipping plus NY & NJ sales tax only . Their price is $200 off MSRP. 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
Commerce Engineer, *Apple* Media Products -...
Commerce Engineer, Apple Media Products (New York City) Job Number: 113028813New York City, New York, United StatesPosted: Sep. 20, 2017Weekly Hours: 40.00 Job Read more
US- *Apple* Store Leader Program - Apple (Un...
US- Apple Store Leader Program Job Number: VariousUnited StatesPosted: Oct. 19, 2017Retail Store Job Summary Learn and grow as you explore the art of leadership at Read more
Product Manager - *Apple* Pay on the *Appl...
Job Summary Apple is looking for a talented product manager to drive the expansion of Apple Pay on the Apple Online Store. This position includes a unique Read more
*Apple* Retail - Multiple Positions - Farmin...
Sales Specialist - Retail Customer Service and Sales Transform Apple Store visitors into loyal Apple customers. When customers enter the store, you're also the Read more
All contents are Copyright 1984-2011 by Xplain Corporation. All rights reserved. Theme designed by Icreon.