help setting up very simple database

Discussion in 'Mac Programming' started by aaron4osu, Apr 16, 2011.

  1. aaron4osu macrumors newbie

    Sep 1, 2009
    I'm trying to learn SQL and want to set up a very simple database on my computer to run SQL statements(create tables, run queries, etc..). I've downloaded querious, razorSQL, but can figure out how to set them up. Hostname, port, etc...

    Isn't there a simple environment to do something like this. I've tried several tutorials on setting up mysql from the terminal but never got that to work either.
  2. chown33 macrumors 604

    Aug 9, 2009
    Sailing beyond the sunset
    Be specific.

    Exactly which tutorials? Post the URLs.

    Exactly where did you encounter a problem in the tutorial? Post the specific command that didn't work.

    I did a simple google search for razorSQL. Found this page:

    I have to say, I'm skeptical of razorSQL's quality. There are two blatant errors on this fairly simple page:
    1. The command is misspelled as: sqilte3
    2. Control-Z in Mac OS X Terminal is not EOF, control-D is.
    Control-Z means something completely different.
  3. Mac_Max macrumors 6502

    Mar 8, 2004
    The way I taught myself SQL was by creating simple C++ apps that manipulated data and using this site as a reference.
  4. Hansr macrumors 6502a

    Apr 1, 2007
    Do you have a server to connect to? These are clients. I recommend going with MAMP and MysqlWorkbench as they are the most beginner friendly ones I can think of.
  5. wlh99 macrumors 6502

    Feb 7, 2008
    This seems to be the fastest way to get going:

    sqlite3 is installed on OS/X, so you can skip the downloading and setup. Once you understand SQL commands and can make sqlite3 work you can move to a larger client/server SQL if you need to.

Share This Page