Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

What is the best way to build a blog from scratch?

A vague question I know. I do know what I'm doing, I'm more or less looking for advice while I have the chance. So I'll leave the comments wide open for your opinions. Anyway, here's the background. I custom made a website with a public face and a behind-the-scenes administration side to take care of messages dropped on the site, etc. Well I want to add a blog. I am basing my entire website on ASP.NET using an Access database. I know that's not wise but I do have reasons for going with Access.

So with each post (that could be 10 paragraphs or more), should I save all that data into one record in the database for easy retrieval (what is the size limitation?), or should I stream write it to a text file and mark the text file name into the database?

The concept is rather simple, but coding it is the hard part. Also, is anyone jumping out of their skin yelling at me to get away from Access? I use it for simplicity and the convenience of portability when it comes to the actual database file.

1 Answer

Relevance
  • 1 decade ago
    Favorite Answer

    If you insist on using Access, which you seem to already know is a really bad idea for a web site, then I would store the contents of you blog entries in external files. The less you put in the Access database the better you will be.

Still have questions? Get your answers by asking now.