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

Collapse
Posted by Don Baccus on
This is a MAJOR departure from our design of multi-RDBMS support in OpenACS 4.  The current way of doing things has served us well and unless there's an overwhelmingly strong argument for abandoning current practice I vote no.

If we take this route we'll end up with a toolkit that has some generic queries embedded in Tcl, others in .xql files, no consistency whatsoever.

In order to get consistency, which is easier?  Move the embedded queries in your new code to .xql files, or to get rid of all the generic .xql files and embed these queries in .tcl files?

Because the latter is what we should do to avoid a mish-mash if your proposal is adopted.  We should shoot for consistency and and either have only RDBMS-specific queries in RDBMS-specific .xql files, with all generic queries embedded in .tcl, or continue according to today's development standard, all queries in .xql files.