hello,
i’m making a site like this: www.iusedtobelieve.com but i’m not sure how to make my database.
i was thinking in make a table with “id” “title” “text” “author” and “visible”(to change between visible or temporary hide, while i don’t accept the submission)
but i guess this will give me many problems to put all titles together in the same table when i have many entrys.
so i thought i should make a table for each title… but then i don’t know how to query the db for the latest 10 entrys don’t matter which title it was.
maybe i should not organize my tables this way… this was how i imagine it.
can someone help me a bit with this?
if were you how you would make a site where the structure will be the same that the one i mentioned before but with a different subject.
wont be better to put each theme in a diferent table? i mean… if i create only one table after a few time i’ll have a lot of entries and maybe will be slower to make queries… i was asking if dividing the themes in diferent tables wont be better and more organized.
in case that i create a table for each theme how can i query the db for the latest dates comparing all dates from all tables?
If it becomes too slow, then you can create an index on the table that’s suited to the way you access the table and then it’ll be fast again. But you’ll need a lot of entries before that’s an issue.
I have a (MySQL) table with over 170,000 entries and that’s still fast enough that I haven’t bothered with an index on it.
Wouldn’t it be better for him to have a seperate Authors table? that way he could store other things about the author like their e-mail address, web address, and maybe a short bio… he could then have the authors name link to the authors page to display the information on the given author.
Of course this wouldn’t be neccessary if the author isn’t important, just an idea :thumb:
that would be cool but would be less ppl posting stuff cause it was a lot of work… register and stuff… i don’t want to scare the visitants
this way it’s better because anyone can go there post and left.
i thought about asking mail to let ppl know that his posts has been inserted and keep the e-mail hidden but i haven’t decided yet if i’ll do it or not
Well, for maximum expandability then I would suggest making a seperate authors table. The information wouldn’t have to be required anyway, they could just enter their website or whatever if they wanted to.
i does make sense but only if you are anticipating repeated postings by same person.
so like APDesign said, let user post freely and give him an option to register.
then maintain top users by postings, public ratings, expert ratings etc as an incentive to register.
