On 6/27/07, David Krings <[EMAIL PROTECTED]> wrote:
Steve Francia wrote:
> The version table would have the document_id, content and the mod_date
> and author_id.
I am by no means a database expert, but why would one want to store
guaranteed to be static data in a table such as the content. That
content will never ever change. I agree with all other parts of your
proposal, but recommend to store only a file path to each version of the
file to keep the static bloat as small as possible.
Be careful of over-simplifying so much that it becomes complex. By
storing important data outside of the database, you have created a
situation in which two different sets of data need to be backed up,
migrated to different servers, configured into applications, etc.
Databases are extremely useful for keeping related data together.
--
Chris Snyder
http://chxo.com/
_______________________________________________
New York PHP Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
