File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Servlets and the fly likes database-driver website Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Servlets
Bookmark "database-driver website" Watch "database-driver website" New topic

database-driver website

Karim zibari

Joined: Aug 19, 2005
Posts: 6
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?

Christophe Verré

Joined: Nov 24, 2005
Posts: 14688

Any particular reason why you want to store everything in a DB ?

[My Blog]
All roads lead to JavaRanch
Karim zibari

Joined: Aug 19, 2005
Posts: 6
i plan to store everything in a db to make the site as dynamic as possible.
Bruce Jin
Ranch Hand

Joined: Sep 20, 2001
Posts: 672
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.

We love Java programming. It is contagious, very cool, and lot of fun. - Peter Coad, Java Design

Crazy Bikes created by m-Power
Stan James
(instanceof Sidekick)
Ranch Hand

Joined: Jan 29, 2003
Posts: 8791
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.

A good question is never answered. It is not a bolt to be tightened into place but a seed to be planted and to bear more seed toward the hope of greening the landscape of the idea. John Ciardi
I agree. Here's the link:
subject: database-driver website
jQuery in Action, 3rd edition