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

 

Community Search:
MacTech Search:

Software Updates via MacUpdate

TextSoap 8.3.2 - 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
ForkLift 3.0 - Powerful file manager: FT...
ForkLift is a powerful file manager and ferociously fast FTP client clothed in a clean and versatile UI that offers the combination of absolute simplicity and raw power expected from a well-executed... Read more
Amazon Chime 4.0.5528 - Amazon-based com...
Amazon Chime is a communications service that transforms online meetings with a secure, easy-to-use application that you can trust. Amazon Chime works seamlessly across your devices so that you can... Read more
Sparkle 2.1.0 - $79.99
Sparkle will change your mind if you thought building websites wasn't for you. Sparkle is the intuitive site builder that lets you create sites for your online portfolio, team or band pages, or... Read more
Bookends 12.7.9 - Reference management a...
Bookends is a full-featured bibliography/reference and information-management system for students and professionals. Bookends uses the cloud to sync reference libraries on all the Macs you use.... Read more
Dash 4.0.0 - Instant search and offline...
Dash is an API documentation browser and code snippet manager. Dash helps you store snippets of code, as well as instantly search and browse documentation for almost any API you might use (for a full... Read more
TrailRunner 3.8.834 - Route planning for...
TrailRunner is the perfect companion for runners, bikers, hikers, and all people wandering under the sky. Plan routes on a geographical map. Import GPS or workout recordings and journalize your... Read more
Dash 4.0.0 - Instant search and offline...
Dash is an API documentation browser and code snippet manager. Dash helps you store snippets of code, as well as instantly search and browse documentation for almost any API you might use (for a full... Read more
Bookends 12.7.9 - Reference management a...
Bookends is a full-featured bibliography/reference and information-management system for students and professionals. Bookends uses the cloud to sync reference libraries on all the Macs you use.... Read more
TrailRunner 3.8.834 - Route planning for...
TrailRunner is the perfect companion for runners, bikers, hikers, and all people wandering under the sky. Plan routes on a geographical map. Import GPS or workout recordings and journalize your... Read more

RPG Djinn Caster (Games)
RPG Djinn Caster 1.0.0 Device: iOS Universal Category: Games Price: $4.99, Version: 1.0.0 (iTunes) Description: SPECIAL PRICE 38% OFF(USD 7.99 -> USD 4.99)!!!A Fantasy Action RPG of far foreign lands! Summon the Djinns and rise to... | Read more »
Alto's Odyssey gets its first trail...
There's finally video evidence of Alto's Odyssey, the follow up to the 2015 App Store hit, Alto's Adventure. It looks just as soothing and atmospheric as Alto's last outing, but this time players will be journeying to the desert. Whereas Alto's... | Read more »
Last week on Pocket Gamer
What’s going on in the wider world of portable gaming? Each week we ask that question of our sister website Pocket Gamer. The PG team covers iOS gaming, just like 148Apps, but it also strays into the world of Android games and handheld consoles... | Read more »
Pokémon GO Generation 2 evolution guide
At long last, Niantic Labs finally unleashed the Generation 2 Pokémon into the wild. Pokémon GO trainers are scrambling to grab up this new set of 80 Pokémon. There are some special new tricks required to catch all of these new beasties, though.... | Read more »
The best new games we played this week
It feels as though the New Year got off to a creaking start as far as mobile games go, but that's changed over the past few weeks. The last few days alone have seen the debut of a number of wonderful games, so we thought we'd take the time to... | Read more »
Recruit more scallywags and discover new...
Get ready to show off your sea legs all over again in Oceans & Empires’ new grand update, which aims to make the act of rising to the role of seven seas ruler even more fresh and appealing, thanks to a richness of new content on both iOS and... | Read more »
Mage the Ascension: Refuge (Games)
Mage the Ascension: Refuge 1.0 Device: iOS Universal Category: Games Price: $4.99, Version: 1.0 (iTunes) Description: The groundbreaking roleplaying game Mage: The Ascension manifests in our turbulent present with Refuge, an... | Read more »
Vampire: Prelude (Games)
Vampire: Prelude 1.0 Device: iOS Universal Category: Games Price: $4.99, Version: 1.0 (iTunes) Description: The classic roleplaying game Vampire: The Masquerade returns to digital games with a Prelude of things to come. Experience a... | Read more »
Digby Forever Guide: How to dig to the d...
Digby Forever is a sparkling homage to arcade classics, and while you may be tiring of the number of arcade games being thrown at you, this endless digger finds many ways to stand out from the rest of the pack. The game manages to be challenging... | Read more »
The best sales on the App Store this wee...
It's been quite the week in mobile games, but if the latest releases(there were some pretty darn good ones, in case you missed out) aren't really doing the trick, perhaps some of these discounted games will. Many of these premium games had their... | Read more »

Price Scanner via MacPrices.net

Apple Certified Refurbished iMacs available f...
Apple has 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 available: - 21″ 3.... Read more
Apple offering Certified Refurbished Series 1...
Apple is now offering Certified Refurbished Series 1 and Series 2 Apple Watches for 14-16% off MSRP, starting at $229. An Apple one-year warranty is included with each watch. Shipping is free: Series... Read more
1.4GHz Mac mini on sale for $449, save $50
B&H Photo has the 1.4GHz Mac mini on sale for $50 off MSRP including free shipping plus NY sales tax only: - 1.4GHz Mac mini: $449 $50 off MSRP Read more
12-inch Retina MacBooks on sale for $200-$250...
Newegg has the 12″ 1.2GHz Space Gray Retina MacBook (sku MLH82LL/A) on sale for $1349.99 including free shipping. Their price is $250 off MSRP, and it’s the lowest price available for this model.... Read more
13-inch 2.0GHz Space Gray MacBook Pro on sale...
Adorama has the non-Touch Bar 13″ 2.0GHz Space Gray MacBook Pro in stock today for $100 off MSRP. Shipping is free, and Adorama charges NY & NJ sales tax only: - 13″ 2.0GHz MacBook Pro Space Gray... Read more
13-inch Touch Bar MacBook Pros on sale for $1...
B&H Photo has select 2016 Apple 13″ Touch Bar MacBook Pros in stock today and up to $100 off MSRP. Shipping is free, and B&H charges NY sales tax only: - 13″ 2.9GHz/512GB Touch Bar MacBook... Read more
KSI-1802R SX Disinfect-able Keyboard With Wav...
KSI has unveiled a new, innovative medical keyboard, the KSI-1802R SX, at HIMSS 2017, running February 19-22 in Orlando, Florida. KSI-1802R SX is the only keyboard that combines dual factor... Read more
15-inch Touch Bar MacBook Pros on sale for up...
Amazon has 15″ Touch Bar MacBook Pros in stock today and on sale for up to $150 off MSRP including free shipping: - 15″ 2.7GHz Touch Bar MacBook Pro Space Gray: $2720.38 $79 off MSRP - 15″ 2.7GHz... Read more
Apple’s Education discount saves up to $300 o...
Purchase a new Mac or iPad using Apple’s Education Store and take up to $300 off MSRP. All teachers, students, and staff of any educational institution qualify for the discount. Shipping is free: -... Read more
13-inch 1.6GHz/256GB MacBook Air on sale for...
Newegg has the 13″ 1.6GHz/256GB MacBook Air (MMGG2LL/A) on sale for $1029.99 including free shipping. Their price is $170 off MSRP, and it’s the lowest price available for this model. Choose Newegg... 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
Manager *Apple* Systems Administration - Pu...
Req ID 3315BR Position Title Manager, Apple Systems Administration Job Description The Manager of Apple Systems Administration oversees the administration and Read more
*Apple* Technician - nfrastructure (United S...
Let’s Work Together Apple Technician This position is based in Portland, ME Life at nfrastructure At nfrastructure, we understand that our success results from our Read more
*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
Manager *Apple* Systems Administration - Pu...
Req ID 3315BR Position Title Manager, Apple Systems Administration Job Description The Manager of Apple Systems Administration oversees the administration and Read more
All contents are Copyright 1984-2011 by Xplain Corporation. All rights reserved. Theme designed by Icreon.