TweetFollow Us on Twitter

Jun 00 Online

Volume Number: 16 (2000)
Issue Number: 6
Column Tag: MacTech Online

Relational Databases for Mac OS X Server

by Jeff Clites <online@mactech.com>

Earlier this year we covered WebObjects, but we didn't go into detail about the database solutions available to use with it. This month we are going to cover relational databases which run under Mac OS X Server. I should mention up front, though, that it's perfectly possible, and quite common, to run your application server and database on different machines, under different platforms. There can be convenience and speed advantages to running everything on one machine, but as your website scales up to higher capacities, you're certain to reach a point where you need to run multiple copies of your application server, on multiple machines, and modern databases are designed with the expectation that they will be accessed simultaneously from multiple locations. Of course, backing a WebObjects application is only one use for a database, and you may have other reasons for wanting a solution that you can run locally.

Database Adaptors

I should also explain a little bit about the way that WebObjects interfaces with databases. They communicate through an EOAdaptor, which usually takes the form of a shared library. The adaptor and the rest of the Enterprise Objects Framework (EOF) take care of most of the details of this communication, so that the developer doesn't have to worry about differences between the databases or between the dialects of SQL that they support. (It's even possible to develop adaptors to interface to non-relational databases, and Apple supplies an example Flat File Adaptor which lets you access formatted text files as though they were database tables.) Apple supplies EOAdaptors for Oracle, Sybase, Informix, and ODBC, although not for all platforms on which WebObjects runs. There are third-party adaptors available for many others—all of the databases we'll cover below have adaptors available. Note that there is currently no ODBC EOAdaptor available for Mac OS X Server, because the ODBC libraries aren't available for the platform, and neither are drivers for any of the databases you may wish to access by ODBC. (ODBC, or Open Database Connectivity, is a technology invented by Microsoft, and attempts to allow you to access different databases via a common API, with support for different databases being supplied by ODBC drivers. Its goal is analogous to that of the EOF, although it is functionally quite different.) Third parties have announced that they plan to bring ODBC support to Mac OS X, but it hasn't arrived yet.

SQL-based Databases

You have three main choices if you do want an SQL-based database which runs on Mac OS X Server itself: FrontBase, OpenBase, and MySQL. Each has its advantages and disadvantages, and the best choice will depend on your situation.

OpenBase has had a long history on the OpenStep platform, and was written specifically to run there. It comes with graphical administration tools, and has a few features, such as the ability to notify applications when data changes and integration with REALbasic, which are not commonly found in other databases. Mac OS X Server ships with OpenBase Lite, a free version which allows you to work with the included sample databases, but this version lacks administration tools and isn't really appropriate for development work. There is also a fully functional, time-limited demonstration version which you can download from the OpenBase website. This gives you ample opportunity to try out OpenBase for yourself, but for actual development or deployment you need to obtain a commercial license. Also note that OpenBase is available for Windows NT and Solaris, in addition to Mac OS X Server, so it is a good match for heterogeneous environments in which multiple operating systems are used, or migration from one to another is likely.

FrontBase, produced by Frontline Software of Denmark, is a cross-platform database written in C. It runs on a variety of platforms, including Mac OS X Server, Windows NT, Solaris, and Linux. Like OpenBase, it includes graphical administration tools, allowing you to create and manage databases easily. (Of course, you can also do this using SQL directly.) One key attraction of FrontBase is its flexible licensing terms. There are a number of different levels, based on different degrees of support and different features, such as bulk import tools and the ability to lock tables in memory. The lowest level is free, and is fully functional but lacks security features. This basic version is more than adequate for development work, and can even be used for deployment if you keep it safely behind a firewall.

The third choice is the open source database MySQL. (It's open source, but there is a fee for some types of commercial usage.) MySQL is very popular in the Linux community, and Anjo Krank has created a set of patches which allows it to run under Mac OS X Server. Actually, recent versions of MySQL will compile and run without patching, although you need a pthreads compatibility library which he provides. (He has also developed an EOAdaptor for MySQL, and a Perl DBI driver for FrontBase.) MySQL's claim to fame, other than being open source, is that it is extremely fast. The reason for its speed is, in part, that it lacks certain key database features, such as transactionality and rollback. These are major capabilities to do without, and in fact technically disqualify it from being a relational database, but if you can live with its limitations then it can be an excellent choice for many applications. Due to its heritage, you'll have to survive without built-in graphical management tools, but in the database arena it is often convenient to manage your database directly via SQL, because it allows you to easily save and reuse scripts for common tasks.

Oracle

As I mentioned before, you can certainly run your database on another platform, even if you are developing for Mac OS X Server. One setup you may want to consider is running Oracle8i under Linux. (This would unfortunately mean running it on an Intel box—Oracle runs neither on Mac OS X Server, nor on LinuxPPC. Given that Larry Ellison sits on Apple's board of directors, there is some hope that this situation may improve in the future. A Darwin version could do amazing things for the platform.) Neither Oracle nor Linux is trivial to administer, but I've heard it argued pretty convincingly that you should use Oracle from the beginning, even if you thing it's more database than you need. The argument goes that if you are running a database-backed website, you will eventually need Oracle, and your life will be easier if you don't have to deal with migrating to, and learning to administer, a new database just when your business is taking off and you're exceeding your capacity. (It's also true that both Linux and Oracle experience looks good on a resume these days.) Oracle is by far the most widely used database on the planet, and it has an excellent reputation for performance and reliability, although it's almost impossible to get hard numbers to quantify this. Personal experience has led me to believe that commercial databases all perform similarly when it comes to raw retrieval speed, although Oracle's unique approach to concurrency control and locking should give it an advantage when many processes are writing to the database at the same time. (In a nutshell, readers and writers rarely interfere with one another.) Oracle also has a very well thought out approach to backup management, and if your database fails you can often recover all the way up to the very last transaction committed. While making your decision, you should be aware that Oracle is extremely expensive, and although its licensing scheme is difficult to decipher, it does appear to be free for development use. If you plan on running a business which will depend on your database, you should give Oracle serious consideration. For extremely high-capacity deployments you will probably want to run Oracle on Solaris, and migrating from Linux to Solaris will be much easier than migrating from a different database architecture. (Oracle has been very good about making its database operate almost identically on all supported platforms.)

Once you've committed to a database, check out the MacTech Online web pages at <www.mactech.com/online/>.

 
AAPL
$100.75
Apple Inc.
+0.64
MSFT
$46.36
Microsoft Corpora
-0.08
GOOG
$577.36
Google Inc.
+1.00

MacTech Search:
Community Search:

Software Updates via MacUpdate

QuickBooks 2015 16.0.0.1352 R1 - Financi...
QuickBooks 2015 helps you manage your business easily and efficiently. Organize your finances all in one place, track money going in and out of your business, and spot areas where you can save.... Read more
Mac DVDRipper Pro 5.0.1 - Copy, backup,...
Mac DVDRipper Pro is the DVD backup solution that lets you protect your DVDs from scratches, save your batteries by reading your movies from your hard disk, manage your collection with just a few... Read more
Apple OS X bash Update 1.0 - Fix for sec...
The OS X bash Update fixes a security flaw in the bash UNIX shell on OS X 10.9.5 (also on OS X 10.8 and 10.7 [see Related Links below]). OS X 10.9.5 or later Downloads for OS X 10.8 and OS X 10.7 in... Read more
SyncTwoFolders 2.0.5 - Syncs two user-sp...
SyncTwoFolders simply synchronizes two folders. It supports synchronization across mounted network drives and it is a possibility to run a simulation showing in a log what will be done. Please visit... Read more
FinderPop 2.5.7 - Classic Mac utility, n...
FinderPop is a Universal preference pane that extends OS X's contextual menus using a FinderPop Items folder much as the Apple Menu Items folder used to do for the Apple menu. It has other features... Read more
VueScan 9.4.45 - Scanner software with a...
VueScan is a scanning program that works with most high-quality flatbed and film scanners to produce scans that have excellent color fidelity and color balance. VueScan is easy to use, and has... Read more
LibreOffice 4.3.2.2 - Free Open Source o...
LibreOffice is an office suite (word processor, spreadsheet, presentations, drawing tool) compatible with other major office suites. The Document Foundation is coordinating development and... Read more
calibre 2.4 - Complete e-library managem...
Calibre is a complete e-book library manager. Organize your collection, convert your books to multiple formats, and sync with all of your devices. Let Calibre be your multi-tasking digital... Read more
Default Folder X 4.6.9b1 - Enhances Open...
Default Folder X attaches a toolbar to the right side of the Open and Save dialogs in any OS X-native application. The toolbar gives you fast access to various folders and commands. You just click... Read more
Beamer 2.0.4 - Stream any movie file fro...
Beamer streams to your Apple TV.... Plays any movie file - Just like the popular desktop movie players, Beamer accepts all common formats, codecs and resolutions. AVI, MKV, MOV, MP4, WMV, FLV. To... Read more

Latest Forum Discussions

See All

WW2: Sandbox. Strategy & Tactics (G...
WW2: Sandbox. Strategy & Tactics 1.0.0 Device: iOS Universal Category: Games Price: $9.99, Version: 1.0.0 (iTunes) Description: Sandbox is the unlimited sequel to our Strategy & Tactics: World War II. We've abandoned... | Read more »
apeFilter (Music)
apeFilter 1.0 Device: iOS Universal Category: Music Price: $6.99, Version: 1.0 (iTunes) Description: | Read more »
Shred It! Review
Shred It! Review By Jennifer Allen on September 30th, 2014 Our Rating: :: GORGEOUS BUT BASICUniversal App - Designed for iPhone and iPad It might look lovely, but Shred It! is a pretty shallow endless runner/snowboarding game.   | Read more »
It Came From Canada: Angry Birds: Transf...
Anyone afraid that throwing Transformers into the Angry Birds mix would result in a Michael Bay-level of childhood pillaging can rest easy. While Rovio’s famous fowls may be a 21st century staple, Angry Birds: Transformers wears its affection for... | Read more »
Galaxy Trucker Review
Galaxy Trucker Review By Rob Thomas on September 30th, 2014 Our Rating: :: IN FOR THE LONG HAULiPad Only App - Designed for the iPad We got a great big convoy, rockin’ through the night… the endless night of outer space, that is.... | Read more »
Moon and Sun – children’s book Review
Moon and Sun – children’s book Review By Amy Solomon on September 30th, 2014 Our Rating: Moon and Sun is a fable-like children’s book with lush illustrations.   Developer: Marcio Monteiro Price: $3.99 Version: 1.0 App Reviewed on... | Read more »
Kairosoft Finally Brings The Pyraplex to...
Kairosoft Finally Brings The Pyraplex to iOS Posted by Jessica Fisher on September 30th, 2014 [ permalink ] Universal App - Designed for iPhone and iPad | Read more »
Yeti’s Parole Officer Review
Yeti’s Parole Officer Review By Jennifer Allen on September 30th, 2014 Our Rating: Universal App - Designed for iPhone and iPad Yeti’s Parole Officer proves that looks aren’t everything in this entertaining, if plain, piece of... | Read more »
Record Keeper and World Wide Words – Two...
Record Keeper and World Wide Words – Two New Final Fantasy Games Arrive on iOS in Japan Posted by Ellis Spice on September 30th, 2014 [ permalink ] | Read more »
iPollute Review
iPollute Review By Nadia Oxford on September 30th, 2014 Our Rating: :: iPOLLUTE, uPOLLUTEUniversal App - Designed for iPhone and iPad iPollute is a delightful-looking pollution simulator, though it’s a bit light on “game” content... | Read more »

Price Scanner via MacPrices.net

Apple Boycotts German Magazine Computer Bild...
Apple has revoked its PR accreditation of Germany’s Computer Bild, Europe’s best-selling PC magazine, in reaction to Bild’s posting of a “#Bentgate” YouTube video. Axel Telzerow, editor in chief of... Read more
iPhone 6 & iPhone 6 Plus Available in Chi...
Apple has announced that iPhone 6 and iPhone 6 Plus will be available in China beginning Friday, October 17 from the Apple Online Store (http://www.apple.com), Apple’s retail stores, and an expansive... Read more
MacBook Airs on sale for $100 off MSRP, start...
Best Buy has the new 2014 MacBook Airs on sale for $100 off MSRP on their online store. Choose free home shipping or free local store pickup (if available). Prices valid for online orders only, in-... Read more
Apple Releases OS X Mavericks bash Update 1.0...
Apple has released a patch update for OS X Mavericks users to address the recently-detected “Shellshock” security bug in BSD UNIX’s bash shell. Apple says only a few Mac users who had manually... Read more
Pivotal Payments Ready for Apple Pay – FlexPo...
Pivotal Payments, a provider of merchant services and global payment processing solutions, has announced its proprietary FlexPoint platform will support credit and debit transactions through Apple’s... Read more
iStabilizer Announces Tabarm — First Friction...
iStabilizer, a specialist in universal lightweight compact tripods, steady cams, dollies, mounts, and remotes for smartphones, tablets, and cameras, announced today the iStabilizer tabArm, the first... Read more
IStabilizer Flex Smartphone Tripod Wins Usa T...
iStabilizer, a specialist in universal lightweight compact tripods, steady cams, and other products for smartphones, tablets, and cameras, has announced today that its iStabilizer Flex smartphone... Read more
13-inch 2.8GHz Retina MacBook Pro on sale for...
B&H Photo has the new 2014 13″ 2.8GHz Retina MacBook Pro on sale for $1699.99 including free shipping plus NY sales tax only. They’ll also include free copies of Parallels Desktop and LoJack for... Read more
15-inch Retina MacBook Pros on sale for up to...
B&H Photo has the new 2014 15″ Retina MacBook Pros on sale for up to $150 off MSRP. Shipping is free, and B&H charges NY sales tax only. They’ll also include free copies of Parallels Desktop... Read more
Get Down to Business On Your iPad With Free N...
Utah based Poem LLC has introduced Nexticy 1.0, a full-featured, affordable (Free) forms application for iPad. Nexticy makes it ‘way easy’ to create, store, retrieve and analyze paper-like forms of... Read more

Jobs Board

*Apple* Retail - Multiple Positions (US) - A...
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
*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
Senior Event Manager, *Apple* Retail Market...
…This senior level position is responsible for leading and imagining the Apple Retail Team's global event strategy. Delivering an overarching brand story; in-store, 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
Project Manager / Business Analyst, WW *Appl...
…a senior project manager / business analyst to work within our Worldwide Apple Fulfillment Operations and the Business Process Re-engineering team. This role will work Read more
All contents are Copyright 1984-2011 by Xplain Corporation. All rights reserved. Theme designed by Icreon.