From: Todd Benson <caduceass@...>
Date: 2008-07-01T01:45:49+09:00
Subject: Re: Database stuff!

On Mon, Jun 30, 2008 at 11:27 AM, Justin To <tekmc@hotmail.com> wrote:
> Hi,
>
> I know this is a Ruby forum, but it has been the most helpful to me in
> my attempt at learning to program and what not.
>
> I want to use MySQL and SQL in conjunction with Ruby.
>
> Basically, I'm totally lost with the database stuff. I installed MySQL,
> but have no clue where to go from there.
> 1. Is the database already setup after installing, if not, how do I set
> it up? Also, from what I've read, SQL is a programming language used to
> manipulate a database. Where's a good beginner's tutorial for this?
> 2. Where do I write SQL? Is there any SQL-specific editor to do this?
>
> I've been working on parsing some .CSV file to capture some basic
> statistics about it. Now, I want to send these statistics into a
> database to store so I can compare multiple .CSV files later on.
>
> Any help is appreciated. Like I said, I'm totally new to databases and
> just need to kick start.
>
> Thanks!

I'm not really a fan of MySQL, but they certainly have some decent
documentation you can look at.  It seems pretty friendly...
http://dev.mysql.com/doc/refman/5.1/en/index.html

Some other sites are out there, too.  I like postgresql.org doc page
on the SQL manual the best, so far.  It's not MySQL, but should be
relatively standard SQL.

I'm sure you can find tutorial info on a quick google search.
Ultimately, you might have to buy a book (which I absolutely hate
doing since I'm overstocked already :).

Todd