Re: [phpslash-users] OT -- MySQL/general database info
Brought to you by:
joestewart,
nhruby
From: Tigran <ti...@us...> - 2003-05-13 00:34:48
|
At 06:05 AM 5/2/2003, you wrote: >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. Ahhh forgot yes it actually is an XY grip but there are hundreds of these XY grids which make it hard to keep track of in excel. Which is how they are stored now. I am thinking putting it into a database will make it easer. Right now when we need to find anything we have to go through several excel files, in a database a simple quarry should fix the problem. >-n >-- >------ >nathan hruby >na...@ds... >------ |