[DB-SIG] SQL statement parse for Oracle

Greg Stein gstein@lyra.org
Mon, 4 Feb 2002 03:58:07 -0800


On Fri, Dec 14, 2001 at 10:53:30AM +0100, M.-A. Lemburg wrote:
>...
> Perhaps I should add a .prepare() method to the set of standard
> DB API extensions though ?!

Why? What's the point?

You're just adding more APIs, but with no benefit. The whole concept of a
prepare() is to get a cursor with a prepared statement which you can execute
over and over. The existing API provides for that, for those databases which
can support such a concept.

Adding prepare() only monkeys up the interface. Now you have a separate
call. But wait! That call might not do anything.

It just seems senseless to keep throwing more and more APIs in. When the
functionality is *already* there, then keep the API simple.

Cheers,
-g

-- 
Greg Stein, http://www.lyra.org/