Deutsch English Français Italiano |
<ciohcj9nnk51n7kvsrn34m0hia4cgbfo1m@4ax.com> View for Bookmarking (what is this?) Look up another Usenet article |
Path: ...!weretis.net!feeder9.news.weretis.net!i2pn.org!i2pn2.org!.POSTED!not-for-mail From: George Neuner <gneuner2@comcast.net> Newsgroups: comp.arch Subject: Re: Article on new mainframe use Date: Fri, 23 Aug 2024 16:08:12 -0400 Organization: i2pn2 (i2pn.org) Message-ID: <ciohcj9nnk51n7kvsrn34m0hia4cgbfo1m@4ax.com> References: <v9iqko$h7vd$1@dont-email.me> <bb873f7f6a14f222f73abacd698e60eb@www.novabbs.org> <3f8sbj9chugcr6arbpck2t7nb0g87ff6ik@4ax.com> <f7fe11f84f9342f0a7e27d4a729aadad@www.novabbs.org> <li71t8Fs9jnU1@mid.individual.net> <v9mc57$15mm9$2@dont-email.me> <kmvubjdn7ub4bkgfhpj89c5vsl37vpp16d@4ax.com> <va88rq$ioap$1@dont-email.me> <va8sji$otgt$5@dont-email.me> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Injection-Info: i2pn2.org; logging-data="3633462"; mail-complaints-to="usenet@i2pn2.org"; posting-account="h5eMH71iFfocGZucc+SnA0y5I+72/ecoTCcIjMd3Uww"; User-Agent: ForteAgent/8.00.32.1272 X-Spam-Checker-Version: SpamAssassin 4.0.0 Bytes: 2538 Lines: 37 On Fri, 23 Aug 2024 02:36:34 -0000 (UTC), Lawrence D'Oliveiro <ldo@nz.invalid> wrote: >On Thu, 22 Aug 2024 15:59:34 -0500, BGB wrote: > >> Underused: It is a sensible way of structuring data, but needing to >> interface with it though SQL strings is awkward and inefficient. > >Actually, that works fine in any language with decent string handling. I believe BGB was referring to how bad SQL is as a language. It's overly verbose, assymetric, context sensitive, uses synonyms to distinguish context, etc. Don Chamberlan and Ed Codd both have said SQL's grammar simply grew rather than being planned, and that IBM releasing it as it existed was a mistake. But due to IBM's market power, it caught on so quickly that there was no chance to fix or refine the grammar. Homework: read up on QUEL. Factoid : SQL originally was called SEQUEL. >> Or, do some weird OO thing where object methods exist for SQL keywords >> and each method returns an object that can be used to glue on the next >> keyword: >> res=db.select().from("FOOTAB").where().equals("NAME", "John").end(); > >ORMs are a waste of time. Absolutely! The real problem with most ORM tools is that they tend to treat the database as dumb storage rather than as an intelligent server. ORM generated applications often end up doing a lot of unnecessary work on the client because the SQL that would perform the task on the server very often is vendor specific.