[nmglug] MySQL - Howto

[Tim Emerick]

Wow.  You still teach classes?  I think I could use a RDBMS-101 class.  Wonder if CNM has a class I could take on how to use a RDBMS.

I am currently running Excel 2003 which supports about 60k+ rows.  I hear that Excel 2007 supports 1mil rows.  It's starting to make me wonder why I would need to use a DBMS backend if I can keep all my data in a spreadsheet. (Other than I HATE HATE HATE the Office 2007 ribbon).

Tim


----- Original Message ----
From: Andy Farnsworth <farnsaw at stonedoor.com>
To: NMGLUG.org mailing list <nmglug at nmglug.org>
Sent: Tuesday, February 26, 2008 11:08:44 AM
Subject: Re: [nmglug] MySQL - Howto

Tim,
  I figured you were Windows centric, at least for this project, as you were talking Excel.  No worries to me as I tend to work 3 or 4 different OSes at a time.  MacOSX is my laptop with Windows running in a VMWare session.  Then I usually connect to Linux / Solaris / AIX / (other commercial unix) for their backend systems.  You name it, I have probably worked on it.

Toad is a very nice front end into almost any database, it was originally Oracle only, but has been expanded to support multiple databases in the last few years.  The comercial version is very powerful and has many features that a DBA would want / need, but the free version is enough for most non-DBA uses.

I have taught a database class and have used excel spreadsheets to illustrate tables and their relationships.

Andy

Tim Emerick wrote: 
TOAD actually looked interesting to me.  I'm currently in a Microsoft-centric office.  It would seem that I could use TOAD as the front end on the XP machines in the office but run a linux app in the background managing the database.  I have never used a database before, Windows or Linux based which is where my dilemma lies.  My closest database experience is probably long lists of info in Excel.

Tim.

----- Original Message ----
From: J. Marsden DeLapp <jmdelapp at delapp.com>
To: NMGLUG.org mailing list <nmglug at nmglug.org>
Sent: Monday, February 25, 2008 7:51:34 PM
Subject: Re: [nmglug] MySQL - Howto

Andy Farnsworth wrote:
  
Also, look into the Toad for MySQL utiltity.  The free version should do 
everything you need for the next year or so, then you might investigate 
the full featured "for pay" version.

Toad for MySQL URL:
http://www.toadsoft.com/toadmysql/Overview.htm
    
Toad looks pretty worthless to me.

Minimum Software Requirements
    * Microsoft® Windows® 2000, 2003, XP Professional, or Vista (32-bit and x64)
    * Microsoft .NET Framework 2.0
    * Microsoft Internet Explorer 5.01 or later
    * Adobe® Acrobat® Reader 5.0 or later (for viewing the Getting Started Guide)
    * Client connectivity and configuration for each database (pre-requisite for connecting)

I am a GNU/Linux user!

Mars

  




-----Inline Attachment Follows-----

_______________________________________________
nmglug mailing list
nmglug at nmglug.org
https://nmglug.org/mailman/listinfo/nmglug
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nmglug.org/pipermail/nmglug-nmglug.org/attachments/20080227/cab20006/attachment.htm>