Forum OpenACS Improvement Proposals (TIPs): Re: TIP #37 (Proposed): Queries in XQL file conventions

Posted by Janine Ohmer on
Although I agree with the drawbacks of xql files, I'm not sure that this would be any less confusing, especially for new people. And how many times would someone who only develops on one database put all the queries into the tcl script and not move out the ones that need to be moved?  But perhaps that is no worse than what we have now.

However, the main comment that comes to mind is that in order to do this you will have to make sure that every single bit of SQL that has been left behind in existing queries has been removed or replaced.  I know that this has been an ongoing process but there is probably some left.  This could be a huge job, or not, depending on how much has already been done.