Starting SQL Dev on Mac?

Question

As I've never created an SQL database outside of University, I'd really like to get a bit of experience. At this moment in time I use a Mac and I've googled round but can't find any decent links.

At the moment I have the mySQL Query Browser / Administrator, which I use for work when I bring my laptop in.

However what additional software do I need in order to create a database on my Mac? Can anyone provide any links for software they recommend?

I have mySQL installed at the command line at the moment, however I haven't a clue as to what I'm supposed to do and I'd like some help getting my feet on the ground. Thanks for any help.

Answer 1

You probably don't need to install anything else if you're happy to use Python. Python 2.5 and later include SQLite, so as long as you have Leopard or Snow Leopard you can use that.

You could try this link to start off. It includes a listing to create a minimal SQLite shell.

Alternativel, why not try http://www.sqlcourse.com/ ? That includes a web-based interpreter.

Answer 2

I would say the best way to learn is with the CLI client.

But that sqlcourse website looks like it has a decent didactive concept, so why not stick with that for a start?

Answer 3

Check MAMP, Mac, Apache, MySQL and PHP. It comes loaded with a database and a ready to go application server.

After setting up MySQL, you will need an editor to make a database and tables. I know Navicat for Windows/Mac is on of the best for MySQL but its commercial. You will need to look for other GUI.

I also tried PostgreSQL database, it does have a GUI and its free.

Answer 4

A really nice MySQL management application is Sequel Pro. Works way better than the official MySQL software and phpMyAdmin in my opinion. You should take a look at it!