Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

078274121, info0a ip, should prodicers of software_based services be held liable or not liable for economic injuries, should producers of soft ware based services such as ATMs be held liable for economic injuries suffered when their systems fail?, nisc wwwxxx, wwwxxx0cm, should producers of software-based services, such as atms, be held liable for economic injuries suffered when their systems fail?, wwwxxx0cm, www.webdp.net, Event 9 IIS log failed to write entry

Links

XODOX
Impressum

#1: History of changed rows

Posted on 2008-04-18 10:52:26 by C K

------=_Part_1655_26061686.1208508746278
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi all.
How can we manage the history of changed rows in the database. I have some
idea but not yet implemented. By using triggers to make a copy of the row
being changed to the another table in the same db. Is there any way to only
save the changed fields data and field name? Any other idea?
Thanks
CPK

--
Keep your Environment clean and green.

------=_Part_1655_26061686.1208508746278--

Report this message

#2: Re: History of changed rows

Posted on 2008-04-18 14:59:26 by Eric Frazier

--------------080900080907040804050706
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

C K wrote:
> Hi all.
> How can we manage the history of changed rows in the database. I have some
> idea but not yet implemented. By using triggers to make a copy of the row
> being changed to the another table in the same db. Is there any way to only
> save the changed fields data and field name? Any other idea?
> Thanks
> CPK
>
How about mysqlbinlog? :)


--------------080900080907040804050706
Content-Type: text/plain; charset=us-ascii


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org
--------------080900080907040804050706--

Report this message

#3: Re: History of changed rows

Posted on 2008-04-18 17:13:18 by Peter Brawley

--------------040503050505000004060506
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

CK,

>How can we manage the history of changed rows in the database.

Point-in-time architecture. For a bit of discussion see
http://www.artfulsoftware.com/infotree/tip.php?id=547

PB

-----

C K wrote:
> Hi all.
> How can we manage the history of changed rows in the database. I have some
> idea but not yet implemented. By using triggers to make a copy of the row
> being changed to the another table in the same db. Is there any way to only
> save the changed fields data and field name? Any other idea?
> Thanks
> CPK
>
>
> ------------------------------------------------------------ ------------
>
> No virus found in this incoming message.
> Checked by AVG.
> Version: 7.5.519 / Virus Database: 269.23.1/1385 - Release Date: 4/18/2008 9:30 AM
>

--------------040503050505000004060506--

Report this message

#4: Re: History of changed rows

Posted on 2008-04-18 19:53:37 by Rob Wultsch

------=_Part_363_5958666.1208541217226
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On Fri, Apr 18, 2008 at 8:13 AM, Peter Brawley <peter.brawley@earthlink.net>
wrote:

> CK,
>
> > How can we manage the history of changed rows in the database.
> >
>
> Point-in-time architecture. For a bit of discussion see
> http://www.artfulsoftware.com/infotree/tip.php?id=547
>
> PB


I have used this convention and it works well.

I have a real problem with how it suggests using NULL. NULL is undefined,
and they are basically abusing it to mean infinite positive. NULL has issues
being indexed, big datetime values don't.

At the recent postgres convention I eavesdropped on a discussion about a
possible new temporal range format which would basically consist of a start
date and an end date and preclude any other entries from overlapping. Such
a format would be ideal for PITA, but the start and end would need to be not
null...

--
Rob Wultsch
wultsch@gmail.com
wultsch (aim)

------=_Part_363_5958666.1208541217226--

Report this message

#5: Re: History of changed rows

Posted on 2008-04-20 17:02:14 by C K

------=_Part_6412_2067932.1208703734419
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Thanks for all of you. I will test the suggestions and then reply.
CPK


--
Keep your Environment clean and green.

------=_Part_6412_2067932.1208703734419--

Report this message