MySQL and PostgreSQL: Two Free Relational Databases for OS X Users
Low End Mac Reader Specials
Memory To Go Special: New 2008 iMac 2GB $42 / iMac Intel Core2 DUO & MacBook Pro 2GB $36 - 1GB $20. MacPro 8 Core Memory 8GB kit $286 / 4GB kit $143 / 2GB kit $93 -- Free shipping available. LIfetime warranty.
Download Typestyler, still the Ultimate Styling Tool for Internet, Print and Video Graphics. Works great in Classic with a Native OS X Version on the way. Free Tryout: www.typestyler.com
LA Computer Company: Specials on AppleCare, iMac's, Apple Batteries and Apple A/C Adapters. Also Great prices on Used Apple Computers. Call 1-800-941-7654 Click Here.
OWC: NewerTech NuPower Batteries for iBook and PowerBooks Designed+Built in USA to run longer, LAST LONGER TOO! Free Battery Recycling Return Label; Quality High-Capacity from $99.95
Mac users can finally play Party Poker for Mac. Not only that, they can also learn how to play PokerStars for Mac.
Laptop Hardware Provided by TechRestore - Overnight Mac & iPod Repairs.
Compare products like desktop computers, laptops, and LCD TVs side by side! All the information and reviews to make the best purchasing decision for a new cell phone GPS products or MP3 players. The Ciao network makes searching products easy for you.
- 2006.03.15
Most of us remember the days when Mac databases pretty much meant one thing: FileMaker Pro. Based on technology that Apple acquired from Nashoba Systems in the late 1980s when they purchased FileMaker, Apple's Claris software division released FileMaker Pro 1.0 in 1990.
FileMaker Pro's very Mac-like interface, striking a near perfect balance between ease-of-use and power, made it an instant standard.
Big SQL database servers were pretty much the realm of other platforms in that era. There were very few options for running a relational database on your Mac.
FileMaker gained relational capabilities with version 3.0 in 1995, but as many database purists have noted over the years, the ability to reference another database is not the same as having a truly relational, multi-table database.
As of version 8, FileMaker ships a truly relational database with the ability to create multiple tables in one database. But not everyone can shell out close to $300 for a copy - or will want to when there are free alternatives.
Free SQL Alternatives to FileMaker Pro
The move to the Unix-based OS X brought a lot of new database options to the Mac. Popular open source relational databases like MySQL and PostgreSQL can run happily in the background on your Mac. While FileMaker has a nice GUI and the open source databases are inherently command-line applications, there are some nice GUI clients that ease you into the world of SQL if you are new to it.
Would the average Mac user decide to eschew the comfortable GUI ease of FileMaker for a more challenging Unix-based program? This being Low End Mac, I think most of our readers appreciate free software like MySQL or PostgreSQL. FileMaker is far from cheap, much less free.
Learning MySQL or PostgreSQL might take a little more effort, but part of the fun of maximizing the usefulness of your low-end hardware is pushing yourself a little farther and learning something new.
MySQL or PostgeSQL?
I think the real question boils down to this: Should the average Mac user go for MySQL or PostgreSQL?
In the realm of computer holy wars, this can be a particular nasty one.
PostgreSQL fans seem to thrive on pointing out the features that MySQL lacks. While true transactional support, true foreign key constraints, and schemas are nice, we're generally talking about setting up a small, personal database server. The average home user will never need to know what these terms mean, much less utilize these features.
This is not meant to imply that MySQL isn't capable of carrying a heavy load, especially on the Web. Along with PHP, it's one half of the "dynamic duo" that powers many database-driven websites, including Yahoo!, Amazon, Wikipedia, and Slashdot. [And, to an increasing extent, Low End Mac. ed]
If it's good enough for those guys, it's good enough for the vast majority of database needs.
In PostgreSQL's favor, it does an amazing job of replicating the features of extremely high-end databases. If you've ever worked with Oracle or a similar high-end database, you'll feel right at home. You'll notice that there's hardly an enterprise-class feature that's missing.
That said, I'm a fan of both. Both MySQL 5 and PostgreSQL 8 run on my PowerBook. They both use few resources while running in the background, and they're both configured out of the box to only accept connections from the local machine, so there's minimal security risk in running them on my laptop.
There are normal OS X package installers available for both, so there are no worries about getting them up and running.
But Which One?
If I had to recommend one or the other for the Mac user who wants to dip his feet in to the world of relational databases, I'd go with MySQL for a couple of reasons.
First, MySQL is very popular - the world's most popular open source database, according to its makers. Googling for "mysql" or "php mysql" will bring you a ton of resources, whether you're just getting started or want to do advanced tasks.
You might even run across a fine series of articles that Dan Knight wrote about PHP and MySQL here on Low End Mac a few years ago as he was transitioning the site from static HTML pages to dynamically generated pages.
In short, that popularity means that it's very easy to find help for MySQL or just learn new tricks when you're so inclined.
Second, there are some really nice graphical front-ends out there for MySQL. Perhaps the most popular is the web-based PHPMyAdmin, and MySQL offers two nice tools (Administrator and Query Browser) that run equally well on Mac, Linux, and Windows.
But the slickest
MySQL front end you will find is Mac-only, the wonderful CocoaMySQL. Developed in XCode
as a fully native OS X app, CocoaMySQL provides an easy, intuitive
GUI for creating databases, tables, managing data, and running your own
custom queries.
It's also a great learning tool, thanks to its Console feature. Just click the Console button to open a drawer that shows the exact SQL commands sent to the server. By using this GUI tool, you can actually prep yourself for performing the same tasks at the command line.
PostgreSQL's greatest asset is its enterprise-class strength. It's basically an open-source replication of extremely high-end databases and will appeal to the geekiest of database administrators.
Postgre also integrates with PHP, and there a few nice GUI tools out there, although none match the polish of any of the MySQL tools. There's a Mac-only tool called PGnJ that is promising, but it doesn't live up to the standard that CocoaMySQL sets.
Some things in Postgre are just done easier from the command line, and that doesn't bode well for someone just getting started with SQL.
So while Postgre is a wonderful option for anyone who's so inclined, I have to give the edge to MySQL because of its widespread popularity and the nice graphical tools that help you learn as you go.
We live in good times for free, powerful database software on the
Mac. While FileMaker will probably always be easier for the database
newbie, those who appreciate a good bargain and don't mind learning a
few new tricks will certainly enjoy learning SQL on their Mac.
- Link: FileMaker
Pro
- Link: FileMaker, Wikipedia
- Link: MySQL
- Link: PostgreSQL
- Link: Using PHP and MySQL, Dan Knight, Online Tech Journal
- Link: PHPMyAdmin
- Link: CocoaMySQL
- Link: PGnJ
Recent Plays Well with Others articles
- End of G4 models points to unprecedented value for used G4 Macs, 06.02. The PowerPC G4 may no longer have a place in Apple's product line, but that's a far cry from saying G4-based Macs are obsolete. If anything, there value is going to increase.
- X11: Your window for using Unix apps on the Mac, 05.17. Mac OS X is a Unix variant. X11 is the tool that lets you access Unix applications using a graphical interface with mouse support.
- 6 extensions to make Firefox even better, 03.29. Improve Firefox with everything from web developer tools to nuking unwanted ads, from faster page loads to knowing the weather.
- Intel Mac mini confounds market with higher price, 03.23. After the raging success of the $499 Mac mini, why did Apple feel a need to move away from the entry-level market by making the Intel Mac mini more expensive?
- More in the Plays Well with Others index.
Links for the Day
- Mac of the Day: SuperMac S900, Aug. 1996 - This 6-slot tower supported dual CPUs and still has a following.
- List of the Day: Macintel List for discussion and support of Intel-based Macs.
- October 7 in LEM history: 98: Love that PowerBook G3 - 99: Troubleshooting 101 - Love at first sight - 02: Hot rodding a Power Mac for OS X - Beefing up Windows networking - 05: Choose FireWire 800 over USB 2.0 and FireWire 400 - Faster Mac minis shipping - Speedy 100 GB 7200 rpm notebook drives
Recent Content on Low End Mac
- New Apple Notebooks at Zero Minus One Week, Charles W. Moore, 'Book Value, 10.07. It's widely anticipated that Apple will overhaul the MacBook Pro and MacBook lines next Tuesday. What should we expect?
- How to Clone Mac OS X to a New Hard Drive, Simon Royal, Mac Spectrum, 10.07. Whether you want to put a bigger, faster drive in your Mac or clone OS X for use in another Mac, here's the simple process.
- Best 12" PowerBook G4 Deals, Low End Mac Deals, 10.07. Used 867 MHz Combo, no APX, $490; 1.33 GHz, $496; 1.5 GHz SuperDrive, $542.
- Best Mac mini Deals, Low End Mac Deals, 10.07. Used 1.25 GHz G4 Combo, $399; 1.42 SuperDrive, $559; 1.66 Core Duo, $499; new 1.83 Core 2 Combo, $570 after rebate; 2.0 SD, $770 a/r.
- Best Power Mac G3 and PCI Video Card Deals, Low End Mac Deals, 10.07. Used beige 300 MHz, $25; 333, $198; blue & white 300, $49; 350, $55; 400, $90; 450, $105; PCI video cards from $15.
- $19,800 Bentley Ego Laptop Remarkably Similar to 1999 Clamshell iBook, Charles W. Moore, Miscellaneous Ramblings, 10.06. Granted, Apple's iBook didn't have white gold trim, a padded leather exterior, or come in colors to match your Bentley automobile.
- The Cost of Moving to Small Business Server vs. Moving to Leopard Server., Andrew J Fishkin, Best Tools for the Job, 10.06. Upgrading the existing SBS 2003 Server would cost less, the the server will run up against hardware limitations long before a Mac Pro does.
- Use Your FileMaker Pro Databases on Your iPhone, Adam Rosen, Adam's Apple, 10.06. Although there's no version of FileMaker Pro for the iPhone, FMTouch will let you use your data and layouts on it.
- Best eMac Deals, Low End Mac Deals, 10.06. Used 700 MHz CD, $110; CD-RW, $130; Combo, $170; 800 CD, $170; 1 GHz Combo, $250; SuperDrive, $280; 1.25 Combo, $290; SD, $360; 1.42 Combo, $359.
- Best MacBook Air Deals, Low End Mac Deals, 10.06. Used 1.6 HD, $1,299; refurb, $1,499; new, $1,669 after rebate; 1.8, $1,919 a/r; 1.6 SSD, $2,294 a/r; used 1.8 SSD, $1,997; refurb, $2,299; new, $2,349 a/r.
- Best iPod shuffle Deals, Low End Mac Deals, 10.06. Refurb 3G/1 GB, $39; 2 GB, $59; new 1 GB (3G or 4G), $47; 2 GB (3G or 4G), $67. Prices include ground shipping.
- Mac Netbook Coming?, $179 64 GB SSD, Apple Owns 20% of US Notebook Market, and More, The 'Book Review, 10.03. Also head of Norton AntiVirus team uses a Mac, Toshiba demos new battery technology, 1 TB notebook drives due in 2010, bargain 'Books from $150 to $2,699, and more.
- Getting the Most from Your G3 Mac, Simon Royal, Mac Spectrum, 10.03. Most G3 Macs can be upgraded so they can run Mac OS X 10.4 'Tiger' quite nicely. Here's how.
- Apple Drops iPhone NDA, Defecting to Android, Auto Performance Apps for the iPhone, and More, iNews Review, 10.03. Also more research needed on cellphone cancer link, file sharing app for the iPhone, three new power accessories from Macally, several new iPhone apps, and more.
- Best Power Mac G4 and AGP Video Card Deals, Low End Mac Deals, 10.03. Used 450 MHz, $75; 500, $99; 733, $150; 800, $199; 1.25 GHz, C$349; 867 MHz dual, $225; 1 GHz, $349; 1.25, $499; 1.42, $600.
- OS X and Safari Shares Grow in September, Toxic Mac Pro?, Green Hard Drives, and More, Mac News Review, 10.03. Also Vista terrible as Mac market grows, CrossOver Mac Pro reviewed, SimpleTech Pro Drives, and a new toolkit for working on computers.
- Best iBook G3 Deals, Low End Mac Deals, 10.03. Used 300 MHz clamshell, $150; 366, $199; 500 CD, $149; 800, $190; 600 CD-RW, $240; 800 Combo, $300; 900, $399; 14" 600, $360; 900, $469.
- Best Mac OS X 10.0-10.3 Deals, Low End Mac Deals, 10.03. Mac OS X 10.0.3, $30; 10.1, $20; 10.2, $60; 10.3 CD, DVD, $100; CD, $119; 10.1 Server, unlimited users, $65; 10.3 Server, unlimited, $150.
- More links in our archive.
About LEM | Support | Usage | Privacy | Contacts
Have a question?
Ask an expert!
Navigation
Used Mac Dealers
Apple History
Best Used Macs
Video Cards
Email Lists
InfoMac's Low
End Mac Forum
Favorite Sites
MacSurfer
MacMinute
MacInTouch
MyAppleMenu
InfoMac
Macs Only!
The Mac Observer
Accelerate Your Mac
RetroMacCast
PB Central
MacWindows
The Vintage Mac
Museum
DealMac
DealsOnTheWeb
Mac2Sell
ramseeker
Mac Driver Museum
JAG's House
System
6 Heaven
System 7 Today
the pickle's Low-End
Mac FAQ
Abandonware
Petition
Mac vs. PC Info
Affiliates
The Apple
Store
Mac
Connection
MacMall
TechRestore
MacResQ
ExperCom
Crucial
Memory
batteries.com
Advertise
