Re: OT -- MySQL/general database info

On Fri, 2 May 2003, Tigran wrote:

> Sorry about the off topic post.
> If posts like this are strictly against the rules please let me know.
>

Eh.. we like tangents. :)

> I'm looking for a good book on database creation.
> I'd like to make my own database in MySQL but I'm not sure how to go about it.
> How data should be organized and such.
> I'm looking for a book that's more about databases then MySQL itself.
> What book do you recommend?
>

Your local college bookstore should have plenty of DB theory/design books
that would probably be worth a read if you wanted to know many of the
fundamentals.  I'm partial to O'Reilly's _mSQL & MySQL_ which takes a
looks at some basic db design stuff, and then applies those principals to
building databses with both MySQl and mSQL (which is nice for a
point-counterpoint kind of thought process, making you see what's MySQL
specific, etc..)  It also covers some very light php, perl, and other
tools to create frontends.  There are tons others, slashdot has reviewd a
few LAMP/datadriven web app books as well.  Try books.slashdot.org

> More specifically I need to create a database of devices that are stored in
> an XY grid. The database must keep the XY location and lots of other
> information that goes with each device.
>

Err.. that sounds like a spreadsheet.  Db's aren't spreadsheets.  You can
populate a spreadsheet with a db, and can probably do a simple XY grid,
though I think that would be limiting.

-n
-- 
------
nathan hruby
[email protected]
------



-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf