NYCPHP Meetup

NYPHP.org

[nycphp-talk] MySQL versioning system

Mark L. Withington mwithington at PLMresearch.com
Wed Apr 28 18:52:40 EDT 2004


Afraid MySQL is a requirement, but I've come up with a relatively painless
way to achieve this.  Thanks for the info just the same.

--------------------------
Mark L. Withington
PLMresearch
"eBusiness for the Midsize Enterprise"
PO Box 1354
Plymouth, MA  02362
o: 800-310-3992
f: 508-746-4973
v: 508-746-2383
m: 508-801-0181
http://www.PLMresearch.com
Netscape/AOL/MSN IM: PLMresearch
mwithington at plmresearch.com
Public Key: http://www.PLMresearch.com/keys/MLW_public_key.asc
Calendar: http://www.plmresearch.com/calendar.php


-----Original Message-----
From: talk-bounces at lists.nyphp.org
[mailto:talk-bounces at lists.nyphp.org]On Behalf Of Ophir Prusak
Sent: Wednesday, April 28, 2004 5:52 PM
To: NYPHP Talk
Subject: Re: [nycphp-talk] MySQL versioning system


This is almost exactly what I'm doing where I work.
We need to record all changes to data (what changed, when, and by who).

If using MySQL is not a must, then you should look into PostgreSQL.
You can use triggers (and rules) in PostgreSQL to automatically record
all the changes on table A into table B.

Ophir

Mark Withington wrote:

>I have a client who would like to store product development information
>within a MySQL table.  The table will consist of multiple fields, each
>representing a product attribute (height, weight, color, etc.).  The client
>would like to store each iteration (or version) of the product development
>information along with the ability to role back to prior versions if
>necessary.
>
>I'd like to ensure that I'm not reinventing the wheel on this.  Anyone have
>any experience with such an effort?  Is this kind of information stored in
>the MySQL logs?  Any light shedding would be appreciated.
>
>Mark
>
>--------------------------
>Mark L. Withington
>PLMresearch
>"eBusiness for the Midsize Enterprise"
>PO Box 1354
>Plymouth, MA  02362
>o: 800-310-3992
>f: 508-746-4973
>v: 508-746-2383
>m: 508-801-0181
>http://www.PLMresearch.com
>Netscape/AOL/MSN IM: PLMresearch
>mwithington at plmresearch.com
>Public Key: http://www.PLMresearch.com/keys/MLW_public_key.asc
>Calendar: http://www.plmresearch.com/calendar.php
>_______________________________________________
>talk mailing list
>talk at lists.nyphp.org
>http://lists.nyphp.org/mailman/listinfo/talk
>
>
_______________________________________________
talk mailing list
talk at lists.nyphp.org
http://lists.nyphp.org/mailman/listinfo/talk




More information about the talk mailing list