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

Sketch 47.1 - Design app for UX/UI for i...
Sketch is an innovative and fresh look at vector drawing. Its intentionally minimalist design is based upon a drawing space of unlimited size and layers, free of palettes, panels, menus, windows, and... Read more
Cocktail 11.0.1 - General maintenance an...
Cocktail is a general purpose utility for macOS that lets you clean, repair and optimize your Mac. It is a powerful digital toolset that helps hundreds of thousands of Mac users around the world get... Read more
Path Finder 7.6.1 - Powerful, award-winn...
Path Finder makes you a master of file management. Take full control over your file system. Save your time: compare and synchronize folders, view hidden files, use Dual Pane and full keyboard... Read more
Slack 2.8.2 - Collaborative communicatio...
Slack is a collaborative communication app that simplifies real-time messaging, archiving, and search for modern working teams. Version 2.8.2: A small release containing nothing but another Electron... Read more
Smultron 10.0.2 - Easy-to-use, powerful...
Smultron 10 is an elegant and powerful text editor that is easy to use. You can use Smultron 10 to create or edit any text document. Everything from a web page, a note or a script to any single piece... Read more
Capto 1.2.5 - $29.99
Capto (was Voila) is an easy-to-use app that takes capturing, recording, video and image editing to the next level. With an intelligent file manager and quick sharing options, Capto is perfect for... Read more
ScreenFlow 7.1.1 - Create screen recordi...
ScreenFlow is powerful, easy-to-use screencasting software for the Mac. With ScreenFlow you can record the contents of your entire monitor while also capturing your video camera, microphone and your... Read more
Xcode 9.0.1 - Integrated development env...
Xcode includes everything developers need to create great applications for Mac, iPhone, iPad, and Apple Watch. Xcode provides developers a unified workflow for user interface design, coding, testing... Read more
TotalFinder 1.10.2 - Adds tabs, hotkeys,...
TotalFinder is a universally acclaimed navigational companion for your Mac. Enhance your Mac's Finder with features so smart and convenient, you won't believe you ever lived without them. Features... Read more
Adobe Flash Player 27.0.0.170 - Plug-in...
Adobe Flash Player is a cross-platform, browser-based application runtime that provides uncompromised viewing of expressive applications, content, and videos across browsers and operating systems.... Read more

Dune! guide - how to toe the line and ge...
Publisher Voodoo is at it again with an all new high score chaser -- Dune! In this fast-paced arcade game, you have to propel yourself along sand dunes, gaining enough momentum to jump above the line to score points, while making sure you have... | Read more »
The best deals on the App Store this wee...
Happy Tuesday, dear readers. Your favorite part of the week as officially arrived. It's time to take a look at the best deals in games. Things are admittedly a bit sparse, but there are a few diamonds in the rough to see you through if you're... | Read more »
Be the last person standing in Legacy of...
Yoozoo Games’ popular action MMO Legacy of Discord is getting a huge new update to celebrate its first anniversary. Perhaps the biggest change is the addition of an exciting survival mode titled Last Guardian. This new survival mode will pit you... | Read more »
Home Street guide - how to make friends...
From the creators of Food Street comes Home Street, a new simulation game that tasks you with building a social network and designing a beautiful home. It's a bit like The Sims, but you won't have to worry about the daily chores involved (feeding,... | Read more »
Color Ballz guide - how to bounce to the...
Color Ballz is an addictive new arcade title from Ketchapp Studios. It takes old school mechanics from games like Brickles and puts a fun twist on it. Your job? To catch balls with a paddle and send them back into a chute to be carried back to... | Read more »
Q&A: A-33 Studio explains why Combat...
When it comes to mobile FPS, it’s often tricky to get the fundamentals right on a platform lacking a physical controller, large display and hefty RAM. With Combat Squad: Project Wednesday, A-33 Studio bravely took on the challenge of making a... | Read more »
Taichi Panda 3: Dragon Hunter guide - ti...
Taichi Panda 3: Dragon Hunter launched this week to players all over the world. It's a beautiful mobile MMORPG that blends elements of Eastern and Western fantasy. It reminds us of a mix between World of Warcraft and Jade Empire. MMO's can have a... | Read more »
The best new games we played this week -...
Phew. It has been a week, but now it's time to relax, put your feet up, and enjoy some brand new mobile games. It was a bit of slow week, but there's still plenty of new titles to add to your collection. Here are four of our favorites. [Read... | Read more »
Yoink - Improved Drag and Drop (Product...
Yoink - Improved Drag and Drop 1.0 Device: iOS Universal Category: Productivity Price: $2.99, Version: 1.0 (iTunes) Description: Yoink for iPad and iPhone lets you easily and quickly store items you drag, copy or share, for later use... | Read more »
Cottage Garden (Games)
Cottage Garden 1.11 Device: iOS Universal Category: Games Price: $4.99, Version: 1.11 (iTunes) Description: | Read more »

Price Scanner via MacPrices.net

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
12″ 1.2GHz Space Gray MacBook on sale for $11...
Amazon has the 2017 12″ 1.2GHz Space Gray Retina MacBook on sale for $100 off MSRP. Shipping is free: 12″ 1.2GHz Space Gray MacBook: $1199.99 $100 off MSRP Read more
Bare Bones Software Releases macOS High Sierr...
Bare Bones Software has announced the release and immediate availability of BBEdit 12.0, a significant upgrade to its professional strength text and code editor. BBEdit 12 introduces a new foundation... Read more
Yale Announces Availability of Apple HomeKit-...
Yale Locks & Hardware has announced that Apple HomeKit support for its Assure Lock family is available this month. The new Yale iM1 Network Module, which provides support for the Apple Home app... Read more

Jobs Board

Fraud Analyst, *Apple* Advertising Platform...
Job Summary Apple Ad Platforms has an opportunity to redefine advertising on mobile devices. Apple reaches hundreds of millions of iPhone, iPod touch, and iPad Read more
*Apple* Information Security - Security Data...
Job Summary This role is responsible for helping to strengthen Apple 's information security posture through the identification and curation of security event data. Read more
Lead *Apple* Solution Consultant - Apple In...
…develop a team of diverse partner employees focusing on excellence to deliver the Apple story. Even when you're not present, you will maintain a consistent influence Read more
watchOS Frameworks Engineering Manager, *App...
Job Summary Join the team that is shaping the future of software development for Apple Watch! Apple is looking for an exceptional software engineering leader to Read more
*Apple* Retail - Multiple Positions - Apple,...
Job Description:SalesSpecialist - Retail Customer Service and SalesTransform Apple Store visitors into loyal Apple customers. When customers enter the store, Read more
All contents are Copyright 1984-2011 by Xplain Corporation. All rights reserved. Theme designed by Icreon.