Forum OpenACS Q&A: xql files and db version
If sql queries have been separated out into .xql files by db type, can this be taken one step further by db type version? amazing-package-postgresql-7.2.1.xql, amazing-package-7.3.4.xql, amazing-package-oracle-20i.xql... so that it's easier to support version-specific sql changes?
Or is there a better way within the file itself?
We could break out query files by version - that's why we implemented that level of granularity in the query dispatcher.
But in practice thus far we've been able to do our version migrations without doing so. With PG we've tried to support the current and current-less-one major version - at the moment PG 7.2.x and 7.3.x. OpenACS 5.0 will support Oracle 9i and 8i, and PG 7.2/7.3 (PG 7.4 is still in beta).