Re: S.O.D.A. database Query API - call for comments

Carl Rosenberger wrote:
>
> we are working on an API to query databases.
>
> Some points we would like to achieve:
> ...
> - String queries do not have to be parsed by database engines.
> Advantages:
> - improved performance
> - reduced overhead and less resource consumption
> - less sources of error
> - less implementation work for db developers
> - Objects use less resources in code than strings. They can be compiled.

Hmm, there some real advantages to queries in string form:

+ easy to build using standard facilities

+ usually the most compact form for network transport

+ portable to multiple DBMSs

+ human readable.

I'll think of more later.

-- 
Lee Fesperman, FFE Software, Inc. (http://www.firstsql.com)
===================================================================
* Check out Database Debunkings (http://www.firstsql.com/dbdebunk/)
* "The Forum Where Database Matters Are Set Straight"