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=-0.3 required=5.0 tests=BAYES_00, REPLYTO_WITHOUT_TO_CC autolearn=no autolearn_force=no version=3.4.4 X-Google-Thread: 103376,a0be06fbc0dd71f1 X-Google-Attributes: gid103376,public,usenet X-Google-Language: ENGLISH,ASCII-7-bit Path: g2news1.google.com!news2.google.com!eweka.nl!lightspeed.eweka.nl!194.134.4.77.MISMATCH!news2.euro.net!news.mixmin.net!news2.arglkargh.de!noris.net!newsfeed.arcor.de!newsspool1.arcor-online.net!news.arcor.de.POSTED!not-for-mail From: "Dmitry A. Kazakov" Subject: Re: The future of Ada is at risk Newsgroups: comp.lang.ada User-Agent: 40tude_Dialog/2.0.15.1 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Reply-To: mailbox@dmitry-kazakov.de Organization: cbb software GmbH References: <20071229040639.f753f982.coolzone@it.dk> <878x3436pj.fsf@ludovic-brenta.org> <1199531506.9355.8.camel@K72> <1199539751.9355.46.camel@K72> <1xu2jerm6vwjv.mt6we9a8wu5q.dlg@40tude.net> <1199554944.14020.47.camel@K72> Date: Sat, 5 Jan 2008 19:40:27 +0100 Message-ID: NNTP-Posting-Date: 05 Jan 2008 19:40:27 CET NNTP-Posting-Host: 2b859df5.newsspool3.arcor-online.net X-Trace: DXC=82DcemMLe[ag`45cDR8l?oMcF=Q^Z^V3h4Fo<]lROoRagUcjd<3m<;b=MD[NO]LmMj[6LHn;2LCVn[ On Sat, 05 Jan 2008 18:42:24 +0100, Georg Bauhaus wrote: > On Sat, 2008-01-05 at 15:35 +0100, Dmitry A. Kazakov wrote: > > To me, a DB management system is an essential part of the operating > system. Just like a file system, only an RDBMS has more to offer. The word is "persistence." Yes it is a function of OS to provide a scope for applications, and a scope for the former scope which is traditionally called file system. All that an application may want is to reach that scope. >>> Hypothesis: The more magic is put in the layer above the high >>> level language SQL, the more difficult it is to actually use >>> that language, hiding all advantages of SQL[*]. >> >> Advantages of SQL? Over what? (:-)) > > Advantages of SQL over fiddling with semi-successful reinventions > of somehow relational not-really-algebras in programming languages > that academic theses tend to produce. (Yes, OK, at least there is > something for the respective pet language.) Huh, SQL is neither quite relational, nor properly typed, nor portable, nor standardized (as we, Ada people used to understand it). And, actually, SQL is a language, so if you are looking for its advantages ... then they must be over Ada! (:-)) If rather bindings are in question, then it is Interfaces.DB.Relational vs. Interfaces.DB.SQL. I vote for the former. > Therefore, I need > access to the RDMS in a transparent way, without having to go through > a chain of implications that a non-SQL better-than-SQL Ada type set > offers behind the scene. I need to work behind the scene. How SQL should help you here? Note that people want DBMS-specific bindings exactly because SQL and relational algebra fail to deliver needed performance and scalability. What happens if you need the id of an inserted row? What has row id to do with RA at all? > In case you find a way to represent a better relational algebra > in Ada types, I'll be happy to join your newly founded DB company > operating the coffee machines or whatever is needed. ;-) (:-)) First we need bindings to the existing mess... Second, the typical scenario of DBMS choice is as follows. Before the project start, the customer decides to use Oracle (that is not discussed). Within next two weeks he switches to MS SQL server. And finally, the project is delivered under MS-Access... (:-)) -- Regards, Dmitry A. Kazakov http://www.dmitry-kazakov.de