Actually, the problem is that in the shared environment I am in, I can't count on the transaction logs. So I need to wrap my own.
Andy -----Original Message----- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 15, 2005 9:23 AM To: CF-Talk Subject: Re: Transaction History File > Andy wrote: >> I am thinking about creating a transaction history for >> auditing, repairing >> and undoing. I am thinking about using XML since this >> would be easy to >> create and would adjust naturally to the addition of new >> attributes. >> However, this would make the file sizes larger. >> >> What are everyone's thoughts about >> 1. Keeping a transaction log >> 2. Keeping it in XML format > For what? > I would be very much inclined not to build something from > scratch, but to use some native / existing functionality: > Source code: use a versioning system > Files: use the snapshot capabilities from your OS/FS For an application that might be deployed on any given OS/FS? > Database: use the native tools from your database For an application that might be deployed with any given database? :) I suspect he wants more control than these are generally designed to provide also... any features of the OS or database won't understand the particulars of his application. By building something from scratch you get maximum control over the format and over how to handle rollbacks. Even if the database has native functionality to handle this, it's probably going to vary from one db to the next and it's probably going to make assumptions about how to handle those transactions. A custom transaction log lets you decide what can or can't be rolled back, how it's rolled back, whether data in other tables is also rolled back with it, or if the related data is ignored, on a relationship-by-relationship basis. It gives you a well defined, consistent format for doing all this that won't change from one system to the next, etc. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209549 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
