Re: FN-FORUM Database Opinion Question

date posted 1st March 2001 14:55

On Thu, Mar 01, 2001 at 01:45:54PM -0000, Darren Spink wrote:
> I know I am probably not understanding this correctly, I have just
> downloaded the MySQL manual and I am a litle confused. It appears to be a
> SQL system (Hence the name) but I cannot see anything about creating the
> data tables, structures & inter-table links.

If you mean "I don't get a graphic wizard and lots of little checkboxes", then no, you
don't. MySQL isn't weighed down with heaps of front-end gubbins - although there are
numerous graphic front-ends, including web based ones to support it.

You talk to it in SQL. Usually from a command line, or application.

Structures and inter-table links are part of your client application, not
the database engine. It just creates tables and serves them to you
according to the SQL that you give it.

>
> If I am right with this.....is the actual choice of database just a regular
> choice on personal preference.
>

Some people like this, some don't. I used to use Access, and created a number
of relational databases with it, but never really felt I knew what was going on..
I used to draw the little lines from one table to another, and click on the tick
boxes. Sometimes it worked. Sometimes it didn't. When it didn't a had no clue what
was wrong.

With pure SQL, you are in control, and can define the relationships yourself
at the planning stage. Besides, you'll need to do it this way if your database
is accessed from a web app...