Personal Development for Smart People Forums

Personal Development for Smart PeopleTM Forums


Go Back   Personal Development for Smart People Forums > Personal Development > Technology & Technical Skills
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Technology & Technical Skills Computer skills, hardware, software, internet topics, gadgets, programming


Welcome to the Personal Development for Smart People Forums, the place for lively, intelligent discussion of all personal growth issues -- physical, mental, financial, social, emotional, spiritual, and more.

You're currently viewing as a guest, which gives you limited read-only access. By joining our free community, you'll be able to post your own messages, access many members-only features, see the new messages posted since your last visit, and of course remove this header message. Registration is fast, simple, and free, so please join today.

If you arrived here from a search engine, you may want to explore the main site first, which includes hundreds of deep and insightful articles on a variety of personal development topics.

Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old 11-04-2006, 08:28 PM
Sky Sky is offline
Junior Member
 
Join Date: Nov 2006
Posts: 7
Sky is on a distinguished road
Default 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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 11-05-2006, 12:52 AM
Moderator
 
Join Date: Nov 2006
Location: Melbourne, Australia
Posts: 171
tobyhede is on a distinguished road
Default

Open Office 2 has a database tool called Base ... It's essentially an Access clone, but there should be a version for OS X.
__________________
toby hede
---------------
Toby Hede’s Blog on Ruby, Rails, User Experience and Stuff
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 11-05-2006, 01:53 AM
Junior Member
 
Join Date: Nov 2006
Location: London
Posts: 2
Virtas is on a distinguished road
Send a message via MSN to Virtas
Default

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 11-05-2006, 04:09 AM
Junior Member
 
Join Date: Nov 2006
Posts: 5
7thStranger is on a distinguished road
Default

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/).
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5 (permalink)  
Old 11-05-2006, 09:23 PM
Senior Member
 
Join Date: Nov 2006
Location: Canada
Posts: 124
moltar is on a distinguished road
Default

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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #6 (permalink)  
Old 11-06-2006, 10:10 PM
Sky Sky is offline
Junior Member
 
Join Date: Nov 2006
Posts: 7
Sky is on a distinguished road
Default

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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


All times are GMT. The time now is 12:50 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Copyright © 2008 by Pavlina LLC