I agree. For the uninitiated, Lighthouse keeps a change log for open issues by appending a carriage return followed by a datestamp and comments reflecting the changes to an issue to a carchar field. It keeps things simple (architecturally) but has limits on the amount of history that can be stored, and makes the data less usable for searching and reporting. If someone (like Aaron, wink wink, nudge nudge) were to break the historty out into a seperate table and check in the changes, it would be a big improvent for what is probably the biggest drawback to the product. Seth
_____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Aaron Rouse Sent: Monday, March 31, 2008 9:58 AM To: [email protected] Subject: [houcfug] Re: free issue tracking systems? That reminds me, we used it on Oracle on the project I mentioned earlier. At the time the scripts for Oracle created the comments/issues fields as varchar2. We routinely were getting to the point of running out of room due to the datatype. First tried to increase it to 4000k and ultimately went to a clob. Ray, the maker of LH, seemed to think that the scripts for Oracle did a clob out of the box but the ones we got did not, do not know if he since updated this. I personally always wanted to modify it so that comments were their own record in the database to make it easier to search on comments based upon user and time/date. On Mon, Mar 31, 2008 at 9:48 AM, Seth Bienek <[EMAIL PROTECTED]> wrote: I've had good luck using Lighthouse Pro for a 4-person team on my current project. http://lighthousepro.riaforge.org/ It's not a full-featured system, but it is CF-based, and well architected, so you can add the functionality you need fairly easily.. On a side note, the SQL is pretty plain vanilla, which makes it good for deploying on most DB platforms. It was designed for MySQL, but we deployed it on Oracle with only minor modifications (mostly to account for Oracle's case-sensitivity). Trac is a more complete free "project management" system, but is a little more (functionally) than we have needed, and I was put off by the poor usability and learning curve aspects. It may suit your needs, though: http://trac.edgewall.org/ Take Care, Seth _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Davis Sent: Monday, March 31, 2008 9:11 AM To: [email protected] Subject: [houcfug] free issue tracking systems? Anyone recommend a free or inexpensive issue tracking system? Mark Davis __________________________________________________ ProjecTools.com P.O. Box 786 Bellville, TX 77418 (713) 371 9840 x 1308 cell (303) 261-7851 [EMAIL PROTECTED] -- Aaron Rouse http://www.happyhacker.com/ --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the "Houston ColdFusion Users' Group" discussion list. To unsubscribe, send email to [EMAIL PROTECTED] For more options, visit http://groups.google.com/group/houcfug?hl=en -~----------~----~----~----~------~----~------~--~---
