This week's book giveaway is in the OCMJEA forum. We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara on-line! See this thread for details.
Thanks.. I was trying to create a sort of BLOG , and was wondering how to tackle it. Should i be creating a database with files (using clob) or should i save the posts as VARCHAR? Blogs seems to be pretty complex things to implement so thats why confused. -Thanks.
Originally posted by prakash chauhan: Thanks.. I was trying to create a sort of BLOG , and was wondering how to tackle it. Should i be creating a database with files (using clob) or should i save the posts as VARCHAR? Blogs seems to be pretty complex things to implement so thats why confused. -Thanks.
You should think about how you want to organize the data first and how it will relate to each other before you worry about data types. At the moment you seem to be making an assumption that there is one column entry per blog... it doesn't necessarily have to be that way.
Joined: Jun 22, 2007
well i have the ideas in my mind ,, what i have thought i would go about it is like this.. I ll be needing three tables , one for users , one for quetions posted and one for answers. each question posted will be saved in the questions table (primary key=QuestionID)and will have a user id to indicate who posted it .. every answer will be a row in a table will be linked with its corressponding question by its QuestionID and again user who posted it.
now i can have queries to pull up answers to a questions or number of replies to a question and all that ..
now i came to know that javaracnch uses file and no database as such so how can we use files to save blog data without using a database?
Ideas i m having i know are blurry but thats possibly because i am still new and thats why just think of Jumping to Coding and try to bypass design consideration and all that..