On Mon, Jul 05, 2010 at 12:24:57PM -0700, Noah Kantrowitz wrote: > Name one such system that expects users to write direct SQL? Not to > be rude, but this all sounds very much like it is coming directly > from a book about DB theory, not from a practical assessment of what
I've had specific experience with at least a few commercial products that use this principle, and I'm sure there are more. http://www.protonic-software.com/ http://www.patrix.com/ We are not expecting mere mortals to touch these reports in any more than they do today, and we are not abandoning a query mechanism. Reports will have to be created one way or the other, and personallyI prefer a standard approach using SQL to the system du jour. > would help Trac improve. The only real bonus anyone has come up with > to "fix" our schema is that it would be easier to transition to > SQLAlchemy as an ORM. That has been a rather contested feature, and I think there are huge advantages in getting rid of anamolies in the system, the effectiveness of different approaches are certainly debatable. > The current system hasn't particularly limited us or plugin devs > that I know of, so I'm not sure why this is even being discussed, it I think there is a fundamental connection with this and the difficulty of adding features, like say using custom fields on milestones, or drawing an accurate gantt chart of the project. I'm not neccesarily right, but that's left for you guys to argue against, or support.. > different issue, but don't drag relational modeling and > normalization into it because those are really non-issues. I don't agree with this at all, just wanted to put that out there. The advantage as I see it with a normalized model, is that you can extend and change when new requirements surface down the line, whether they are to support new entities or reporting mechanisms, and have minimal impact on the code. This is not neccesary for someone who has intimate knowledge of the system, but it sure would have made my life easier when I first started! All the best, Terje -- You received this message because you are subscribed to the Google Groups "Trac Development" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/trac-dev?hl=en.
