What is the best way to store blog entries?

Question

I am making my own website from scratch using PHP and I want to know the best way to strore a blog entry. Should I store the data in a database such as MySQL? Should I store a blog entry as an XML file? Should I use some sort of hybrid method? Please don't bother mentioning any third-party products as I am only interested in creating my website myself from scratch.

Answer 1

If you use MySQL, then the blog will be SEARCHABLE. That would be awesome. The text that you store in the MySQL could easily generate some cool XML or something nifty.



Go for it.

Answer 2

For this project I would go with MySQL. Just recently I have tried using PostgreSQL since I had only been familier with MySQL and MS SQL in the past. PostgreSQL is okay, but MySQL recently has been pulling ahead by quite a bit.



MySQL is also far more supported than any other open source database -- which is why it would make a good starter tool. It will take you some time for get MySQL and PHP to talk to each other but it is a lot of fun as well. Good luck.

Answer 3

MySQL of course.

Answer 4

get some professional help at-



http://tinyurl.com/o5e26



all the best :)