Menu
This evening I decided it would be fun to reinvent the wheel, (create my own blogging system). I’m wondering how others who have done this (Ryan, Daniel, Conor), have structured your databases?
I was considering 1 table for posts and 1 for comments, or maybe 1 table per post (probably not though). Anyways, how have you all went about this?
[i]Originally posted by MstrBob [/i]
[B]Considering that your blog entries are different types of data, they should be in different tables. However, and don't think you need to create a new table for each blog entry, seeing as how, unless you write very, very long entries, your index information for the table will occupy more space than your data, not good space managment. I would suggest having two tables, one for entries, the other for comments. Simply tie the comments to the correct blog entries and you should be fine. That's all IMHO. [/B][/QUOTE]
[i]Originally posted by dera [/i]
[B]do you think my website is to long? [/B][/QUOTE]
[i]Originally posted by Sam [/i]
[B]Really? If you don't mind my asking, what do info do they store? [/B][/QUOTE]
0.1.9 — BETA 6.17