From mboxrd@z Thu Jan 1 00:00:00 1970 X-Spam-Checker-Version: SpamAssassin 3.4.4 (2020-01-24) on polar.synack.me X-Spam-Level: X-Spam-Status: No, score=-1.9 required=5.0 tests=BAYES_00 autolearn=ham autolearn_force=no version=3.4.4 X-Google-Thread: 103376,ee0dc912649d50d4 X-Google-Attributes: gid103376,public X-Google-Language: ENGLISH,ASCII-7-bit From: Brian May Newsgroups: comp.lang.ada Subject: Re: Ada DB bindings and APQ References: <1km3c584awura$.y7djkir1ozya$.dlg@40tude.net> <1x4xxn0yx1abu.myr2odcsdxg8$.dlg@40tude.net> Date: Thu, 16 Dec 2004 08:54:31 +1100 Message-ID: User-Agent: Gnus/5.1007 (Gnus v5.10.7) Emacs/21.3 (gnu/linux) Cancel-Lock: sha1:LLNJgERLgc3sySCL1o0b9134PBs= MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii NNTP-Posting-Host: snoopy.microcomaustralia.com.au X-Trace: news.melbourne.pipenetworks.com 1103147646 202.173.153.89 (16 Dec 2004 07:54:06 +1000) X-Complaints-To: abuse@pipenetworks.com X-Abuse-Info: Please forward all headers to enable your complaint to be properly processed. Path: g2news1.google.com!news2.google.com!news.maxwell.syr.edu!news-south.connect.com.au!news-north.connect.com.au!news.alphalink.com.au!news.melbourne.pipenetworks.com!not-for-mail Xref: g2news1.google.com comp.lang.ada:6982 Date: 2004-12-16T08:54:31+11:00 List-Id: >>>>> "Dmitry" == Dmitry A Kazakov 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