Professional Web Applications Themes

revisioning - MySQL

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 ...

  1. #1

    Default revisioning

    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

    [url]http://www.atte.dk[/url]
    Atte André Jensen Guest

  2. #2

    Default Re: revisioning

    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
    _|
    [url]http://datacharmer.blogspot.com/[/url]
    Giuseppe Maxia Guest

  3. #3

    Default Re: revisioning

    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

    [url]http://www.atte.dk[/url]
    Atte André Jensen Guest

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139