Re: OT: MySQL book recommendation for a newbie?

From: Tom (asdf_at_lkj.asdf)
Date: 01/10/04 

Date: Sat, 10 Jan 2004 01:37:28 GMT

Someone wrote:
> Can anyone recommend a good, newbie book on MySQL? Something that'll get me
> started. I know nothing about databases and I'd like to start somewhere.
> Preferably a book that'll show me atleast the basics what it's all about,
> how to use it and how to interface with it for a project that I need to do,
> which would be best with a DB rather than a spread***.

This is PostgreSQL, which has transaction support and other very useful
features, and it's a BSD. There are advantages and disadvantages with
MySQL and PostgreSQL, so you have to choose which is best for you -
usually speed over reliability respectively. Here's a free online book
you can start on with database SQL basics, but it doesn't teach you how
to model data.
  http://www.postgresql.org/docs/aw_pgsql_book/node3.html

PostgreSQL documentation per release:
  http://www.postgresql.org/docs/

> I'd like to be able to set up a DB with various information, tables, etc.
> and interface with it via a web interface or even a *nix based GUI app
> and/or Windows (please, no flames).

PostgreSQL interfaces:
  http://www.postgresql.org/docs/current/static/client-interfaces.html

You can use the GUI PgAccess and other tools for administration. I
haven't much experience with them.