Personal Development for Smart People^TM Forums

Sky · 11-04-2006, 08:28 PM

I'm looking for an optimal option for using SQL on my iBook running OSX 10.3.9. I'm quite familiar with relational databases, but have really only used Filemaker Pro and a little Access. As Filemaker isn't SQL based, I only have a little experience with it. I want want to learn on the fly, though.

I don't have much experience running command-line programs, but I'm not against learning if I had the proper tutorial. Something with a nice GUI would work, too. Any suggestions, both about what to install and references to use? Access would be ideal if I owned a PC, as it's graphical but also allows for SQL code inputs.

Thanks in advance for the help.

tobyhede · 11-05-2006, 12:52 AM

Open Office 2 has a database tool called Base ... It's essentially an Access clone, but there should be a version for OS X.

Virtas · 11-05-2006, 01:53 AM

I recommend using NeoOffice for mac. Neo office is a special compilation of Open Office.

For rational databases I would also recommend installing MySQL on your mac:
MySQL AB :: MySQL 5.0 Reference Manual :: 2.3.10 Installing MySQL on Mac OS X

7thStranger · 11-05-2006, 04:09 AM

Look into the free combination of the MySQL database (MySQL AB :: The world's most popular open source database) and a front-end like CocoaMySQL (http://cocoamysql.sourceforge.net/).

moltar · 11-05-2006, 09:23 PM

SQLite is great for small things and learning. It's very powerful, yet light. I don't think they have a mac support, but they do offer source code. Maybe you can compile it from source.

But if you want "The Real Thing"(tm), then get MySQL for sure. I like phpMyAdmin as the front end interface, but it requires a web server as well.

Sky · 11-06-2006, 10:10 PM

Thanks for the suggestions. I'm trying the MySQL/Cocoa GUI route first. If I can't handle setting that up, I'll try Neo Office.

11-04-2006, 08:28 PM	#1 (permalink)
Sky Junior Member Join Date: Nov 2006 Posts: 7	Want to Learn/Use SQL on Mac I'm looking for an optimal option for using SQL on my iBook running OSX 10.3.9. I'm quite familiar with relational databases, but have really only used Filemaker Pro and a little Access. As Filemaker isn't SQL based, I only have a little experience with it. I want want to learn on the fly, though. I don't have much experience running command-line programs, but I'm not against learning if I had the proper tutorial. Something with a nice GUI would work, too. Any suggestions, both about what to install and references to use? Access would be ideal if I owned a PC, as it's graphical but also allows for SQL code inputs. Thanks in advance for the help.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

11-05-2006, 12:52 AM	#2 (permalink)
tobyhede Senior Member Join Date: Nov 2006 Location: Melbourne, Australia Posts: 182	Open Office 2 has a database tool called Base ... It's essentially an Access clone, but there should be a version for OS X.

11-05-2006, 01:53 AM	#3 (permalink)
Virtas Junior Member Join Date: Nov 2006 Location: London Posts: 2	I recommend using NeoOffice for mac. Neo office is a special compilation of Open Office. For rational databases I would also recommend installing MySQL on your mac: MySQL AB :: MySQL 5.0 Reference Manual :: 2.3.10 Installing MySQL on Mac OS X

11-05-2006, 04:09 AM	#4 (permalink)
7thStranger Junior Member Join Date: Nov 2006 Posts: 5	Look into the free combination of the MySQL database (MySQL AB :: The world's most popular open source database) and a front-end like CocoaMySQL (http://cocoamysql.sourceforge.net/).

11-05-2006, 09:23 PM	#5 (permalink)
moltar Senior Member Join Date: Nov 2006 Location: Canada Posts: 125	SQLite is great for small things and learning. It's very powerful, yet light. I don't think they have a mac support, but they do offer source code. Maybe you can compile it from source. But if you want "The Real Thing"(tm), then get MySQL for sure. I like phpMyAdmin as the front end interface, but it requires a web server as well.

11-06-2006, 10:10 PM	#6 (permalink)
Sky Junior Member Join Date: Nov 2006 Posts: 7	Thanks for the suggestions. I'm trying the MySQL/Cocoa GUI route first. If I can't handle setting that up, I'll try Neo Office.

Personal Development for Smart PeopleTM Forums

Personal Development for Smart People^TM Forums