Another pretty cool option would be to use PECL's xdiff w/ the db
content ...
Table it w/ created_at, updated_at, content
http://us2.php.net/manual/en/function.xdiff-string-diff.php
Haven't had a chance to check it out but would be able to show
changes over time.
- Jon
On Jun 27, 2007, at 6:47 PM, Steve Francia wrote:
If it is just for a single document you can do it pretty easily
with just
sql (mysql).
Make a document table and a version table.
The document table would have the shell of what a document was
(title, etc).
The version table would have the document_id, content and the
mod_date and
author_id.
To get a document just do a join on the most recent version. All
the other
solutions would require support outside of the application, which
could
cause scalability problems down the road.
On 6/27/07, Jon Baer <[EMAIL PROTECTED]> wrote:
Subversion and WebSVN :-)
http://websvn.tigris.org/
On Jun 27, 2007, at 12:43 PM, David Krings wrote:
Jake McGraw wrote:
Hi All, this is my first post, so if this is in the wrong section
please let me know.
I'd like to know if anyone has developed a database schema for
storing
the revision history for a plain text document by multiple users.
Basically, I'm talking about a wiki, but something much more simple.
Any suggestions on methods of organizing the information using SQL
(specifically MySQL) would be much appreciated.
Thanks!
- jake
I'd just keep individual copies of the text files in the file
system and
then use a db table to keep track of the file location and their
chronological sequence using a UNIX time stamp. Can't think of any
easier
way to do it.
David
_______________________________________________
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
_______________________________________________
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
_______________________________________________
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
_______________________________________________
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
