Robizzle01
Limp Gawd
- Joined
- Sep 30, 2005
- Messages
- 159
Campus book stores are a huge ripoff and i'm thinking about making a book-swap website for my school. I have a lot of the inner workings layed out in my mind but before I even start coding anything, I need to figure out how i'm going to work with all the different books.
My first idea was to simply allow users to add new books to the database and they would fill in all the information about a book for me (author, title, publisher, date published, ISBN #, etc) but I am very scared of ending up with a database that has 10 copies of every book each with different spellings and typos in various fields. I wont have the time to log into the database and merge records of duplicate books so this idea is out.
My second idea would be to find a database somewhere that either allows free accessing or one that I can download and install onto my server then do all the lookups from there. Problems with this solution could be adding new books throughout the life of the website or incomplete databases. Also, my database should only need 500-1000 (I'm not a good estimator) books to cover every required reading for all the classes here whereas if I download and import one from a website somewhere, it would be much much larger -- would this impact my performance any or would it simply be a harddrive space issue? If I remember, mySQL will self organize entries such that the most common items are also the fastest to find and return (if this is true, then after a week of using the database I should have a fairly fast website and maybe even after a few months of use I could go ahead and delete all the books with zero accesses.)
And then a fallback plan that would be horrible would be to maintain and add all entries myself. If I had to go this route i'd likely just setup my website for the most common 25-50 classes and leave it at that.
Sorry for the lengthy description but understanding my problem may help people give me more directed feedback. Does anyone know of a database somewhere that is free to download that contains information such as ISBN numbers, authors and titles? Or any other solutions anyone else could come up with?
My first idea was to simply allow users to add new books to the database and they would fill in all the information about a book for me (author, title, publisher, date published, ISBN #, etc) but I am very scared of ending up with a database that has 10 copies of every book each with different spellings and typos in various fields. I wont have the time to log into the database and merge records of duplicate books so this idea is out.
My second idea would be to find a database somewhere that either allows free accessing or one that I can download and install onto my server then do all the lookups from there. Problems with this solution could be adding new books throughout the life of the website or incomplete databases. Also, my database should only need 500-1000 (I'm not a good estimator) books to cover every required reading for all the classes here whereas if I download and import one from a website somewhere, it would be much much larger -- would this impact my performance any or would it simply be a harddrive space issue? If I remember, mySQL will self organize entries such that the most common items are also the fastest to find and return (if this is true, then after a week of using the database I should have a fairly fast website and maybe even after a few months of use I could go ahead and delete all the books with zero accesses.)
And then a fallback plan that would be horrible would be to maintain and add all entries myself. If I had to go this route i'd likely just setup my website for the most common 25-50 classes and leave it at that.
Sorry for the lengthy description but understanding my problem may help people give me more directed feedback. Does anyone know of a database somewhere that is free to download that contains information such as ISBN numbers, authors and titles? Or any other solutions anyone else could come up with?