Forum OpenACS Development: Re: Eliminating 90% of DB-specific queries

Collapse
3: Re: Eliminating 90% of DB-specific queries (response to 1)
Posted by Eduardo Pérez on 02/21/03 05:16 PM
What do you mean?

Adding PL/pgSQL to Oracle or adding PL/SQL to PostgreSQL?

Could anyone with experience in both languages comment the benefits and
drawbacks of either one?

Collapse
5: Re: Eliminating 90% of DB-specific queries (response to 3)
Posted by Jeff Davis on 02/21/03 05:22 PM
the safest thing is to map __ to . in oracle queries.  Trying to map . to __ but only when it is a function and not a table.column reference is _hard_.

It is not entirely risk free but I think we would see fewer bugs because of this than we now see because we have two
parallel sets of queries when one would suffice.