Mark Hensler — Wed, 04 Feb 2004 21:51:34 +0000

I don't like the idea of seperate tables for each person.

You may want to consider spliting the blog "headers" from the "body" (similar to email headers). The blog_headers table could be fully indexed and maybe even fixed length (If you don't have titles for your blogs, otherwise you'll be wasting space using a char datatype), which would search faster. Then the blog_body would contain an id and blob().

Right now, I would make a feature list...

Do you want to be able to pull stats from your data? (what kind? stats per user? blogs-per-[unit_of_time]? longest blog to date? most read blog? most commented blog?)

Should it be searchable? (titles too? by date ranges? by author?)

Should there be user comments? (searchable?)

If there are user comments, should there be a mechanism for the blogger to reply to a specific user comment? (like some guestbooks provide)

Is there a need for attachments? (stored in db or in filesystem? un/limited attachments per blog?)

Is there a need for bbcode or URL parsing?

Will this be template driven?

m3rajk — Sun, 01 Feb 2004 01:18:13 +0000

kewl
someome at a different forums suggested i rethink splittingot each user having their own table since it creates issues tryingto find the last past, posts today, etc.

so i have a question here. who thinks there's a better way to make it more scalable?

Suzanne — Sat, 31 Jan 2004 20:17:40 +0000

Does this meet what you need?

http://ca.php.net/manual/en/function.mysql-list-tables.php

Quote:
thebitman at attbi dot com
07-May-2003 01:49
okay everybody, the fastest, most accurate, safest method:

<?php function mysql_table_exists($table, $link) { $exists = mysql_query(\"SELECT 1 FROM `$table` LIMIT 0\", $link); if ($exists) return true; return false; } ?>

Note the "LIMIT 0", I mean come on, people, can't get much faster than that!

As far as a query goes, this does absolutely nothing. But it has the ability to fail if the table doesnt exist, and that's all you need!

If not, http://www.mysql.com/doc/en/CREATE_TABLE.html should suit your needs.