Forum OpenACS Development: Response to Query dispatcher

Collapse
Posted by Don Baccus on
It will actually cost us time in the short run (because it needs to be
written).  The benefit is really down the road.

We want to keep code compatibility with Oracle because this increases
the odds that OpenACS/ACS Classic can supply single modules that
"know" how to run with more than a single database.

This also will help simplify the support of other databases in the
future, if we choose to do so, because Postgres supports the standard
SQL92 for some features Oracle has private syntax for, most notably
outer joins.  Interbase and a couple of the other database systems of
interest also support the standard SQL92 syntax for this important
feature...