SEO

#1 (**permalink**) 02-28-2008, 07:15 AM

Hi

I'm writing an invoice system in php/mysql. I need to show old invoices
exactly as they appeared at the date they were created. But I also need
to be able to update customer information. A friend of mine who's a very
knowing oracle programmer told me that in oracle it's possible to have
each update not replace old data, but automatically save a new revision.
This should make it possible to get content from a row, table possible
even entire system as it appeared on a certain date.

Is something like this possible in mysql? Any thoughts about this idea?
How do others handle these conflicting interrests of a) updating
information while b) beeing able to recreate how things looked at a
certain point in time?

Thanks in advance for any feedback.

--
peace, love & harmony
Atte

http://www.atte.dk

#2 (**permalink**) 02-28-2008, 07:15 AM

Atte André Jensen wrote:
> Hi
>
> I'm writing an invoice system in php/mysql. I need to show old invoices
> exactly as they appeared at the date they were created. But I also need
> to be able to update customer information. A friend of mine who's a very
> knowing oracle programmer told me that in oracle it's possible to have
> each update not replace old data, but automatically save a new revision.
> This should make it possible to get content from a row, table possible
> even entire system as it appeared on a certain date.
>
> Is something like this possible in mysql? Any thoughts about this idea?
> How do others handle these conflicting interrests of a) updating
> information while b) beeing able to recreate how things looked at a
> certain point in time?
>
> Thanks in advance for any feedback.
>

MySQL does not have any support for revision.
You can save old versions of each record using triggers (in MySQL 5.0),
but to get a snapshot you must be much more creative than that.

ciao
gmax

--
_ _ _ _
(_|| | |(_|>< The Data Charmer
_|
http://datacharmer.blogspot.com/

#3 (**permalink**) 02-28-2008, 07:15 AM

Giuseppe Maxia wrote:

> MySQL does not have any support for revision.
> You can save old versions of each record using triggers (in MySQL 5.0),
> but to get a snapshot you must be much more creative than that.

Thanks for the reply. Seems I'll have to roll my own then...

--
peace, love & harmony
Atte

http://www.atte.dk

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

revisioning