Re: Ada DB bindings and APQ

[Brian May <bam@snoopy.apana.org.au>]

>>>>> "Dmitry" == Dmitry A Kazakov <mailbox@dmitry-kazakov.de> writes:

    Dmitry> I didn't mean APQ, otherwise I wouldn't consider it as a
    Dmitry> starting point. I meant only the way of constructing
    Dmitry> queries. Specifically, that there is no *typed* difference
    Dmitry> between "CREATE", "1.35" and "INTEGER". Everything is a
    Dmitry> string to append. This is untyped => error prone,
    Dmitry> uncheckable, unmaintainable.

Good point. SQL was never designed to be type safe, and as such it is
the weakest link when combined with a type safe language like Ada. For
example, you can pass SQL a string for an integer type, and as long as
the string happens to be a integer, you will never notice any
problems. Pass it a string that cannot be parsed as an integer, and
the database will complain.

However, I consider this a low priority at the moment, I think some of
the other issues are a higher priority.
-- 
Brian May <bam@snoopy.apana.org.au>