• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

database-driver website

 
Karim zibari
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i am designing a dynamic website for a local newspaper. i plan to store all the sites content in a MySQL database inculing articles, pictures, thumbnail etc.

i've read that this solution (using a database for all content generation) is an overkill and would significantly undermine the site's responce times and efficiency. even the site's links are all dynamically generated from the database.

i am using html, jsp, servlets and classes to access MySQL.
any ideas?

akz
 
Christophe Verré
Sheriff
Posts: 14691
16
Eclipse IDE Ubuntu VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Any particular reason why you want to store everything in a DB ?
 
Karim zibari
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i plan to store everything in a db to make the site as dynamic as possible.
 
Bruce Jin
Ranch Hand
Posts: 672
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It may be a good idea to store the index of all articles in DB. Then you can locate the articles using the index and redirect to the real articles on the fly.
 
Stan James
(instanceof Sidekick)
Ranch Hand
Posts: 8791
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The database might be good if you're going to let site users write content. Maybe give them an editing page and save what they write to the database. The database isn't required even for this kind of thing. You could write the content to flat files and just use the database for some kind of indexing and organizing. When you're that dynamic you're into "content management system" territory. You might Google around on those just to become familiar with the kinds of things they do and see if you want to use an existing one or implement some similar features.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic