Path: ...!local-4.nntp.ord.giganews.com!Xl.tags.giganews.com!local-3.nntp.ord.giganews.com!news.giganews.com.POSTED!not-for-mail
NNTP-Posting-Date: Fri, 28 Feb 2025 12:55:06 +0000
Subject: Re: The joy of FORTRAN
Newsgroups: comp.os.linux.misc
References: <5mqdnZuGq4lgwm_7nZ2dnZfqnPSdnZ2d@earthlink.com>
 <iJEJO.198176$kxD8.81657@fx11.iad>
 <3hOdnWpQ649QMGr7nZ2dnZfqnPidnZ2d@earthlink.com>
 <vd8doi$15q07$1@dont-email.me> <vd8eg7$15v1j$2@dont-email.me>
 <cxicnVzg_cn_eGX7nZ2dnZfqnPadnZ2d@earthlink.com>
 <vdapbn$1kp35$5@dont-email.me> <lltpunF4fseU2@mid.individual.net>
 <1smdnSjX3YoxgWf7nZ2dnZfqn_idnZ2d@earthlink.com>
 <llv30aFa6uvU3@mid.individual.net> <vde4b8$268qv$22@dont-email.me>
 <1396870532.749421730.052473.peter_flass-yahoo.com@news.eternal-september.org>
 <wrapper-20241001111737@ram.dialup.fu-berlin.de>
 <vpl5uk$hhk$3@reader1.panix.com>
 <c4acndn4jJXKwCP6nZ2dnZfqnPSdnZ2d@giganews.com>
 <1214951717.762291306.657281.peter_flass-yahoo.com@news.eternal-september.org>
 <gIUvP.1415795$21T3.138928@fx18.iad> <vpp6b0$31cet$2@dont-email.me>
 <5DWdnXyIYo7er136nZ2dnZfqnPednZ2d@giganews.com>
 <vppkbv$33b82$6@dont-email.me> <vpqm2d$39d65$1@dont-email.me>
 <-ducnbYn4JrmyFz6nZ2dnZfqn_idnZ2d@giganews.com>
 <m2d8haFnv00U2@mid.individual.net>
From: c186282 <c186282@nnada.net>
Date: Fri, 28 Feb 2025 07:55:08 -0500
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101
 Thunderbird/78.13.0
MIME-Version: 1.0
In-Reply-To: <m2d8haFnv00U2@mid.individual.net>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Language: en-US
Content-Transfer-Encoding: 7bit
Message-ID: <4rOcnbWnvNi3L1z6nZ2dnZfqn_GdnZ2d@giganews.com>
Lines: 36
X-Usenet-Provider: http://www.giganews.com
X-Trace: sv3-jUCpPBV0ODE2dAu9VN8+rLqUGM6gruT0KOFD0md5LFD0vMlNaQhGqjrzRYZZC8Lsi/VoHuzOqDA5hSg!V/cS8QZQBpMEBqSlhkrQ9s9CJbHGWTg5eNHmCriTUlGq1broDB3Vzq/GmPsn7CyxfunlrSllf0yk
X-Complaints-To: abuse@giganews.com
X-DMCA-Notifications: http://www.giganews.com/info/dmca.html
X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly
X-Postfilter: 1.3.40
Bytes: 3868

On 2/28/25 2:56 AM, rbowman wrote:
> On Fri, 28 Feb 2025 01:19:38 -0500, c186282 wrote:
> 
>>     I only used SQL to do the initial selection - and then more custom
>>     code to go through/organize that. Table-joins and the rest are just
>>     too evil. No "simple" once you get to that junk (and it's SLOW too).
>>     Dump the initial find to a file and use 'C' to go on from there.
> 
> We had a person who handcrafted a query using a wide range of DB2 scalar
> functions. I have no idea how many hours it took and it kept growing. I
> don't remember the DB2 version but it broke on some sites where the DB2
> version had a 4k limit rather than the later 8k.
> 
> I knew what it was supposed to do but I didn't have a clue how it did it.
> The idea was to provide configurable queries that a user could modify for
> their needs but that one got handed down to generations of support people
> untouched.  That was the case for a lot of the 'configurable' reports. It
> would have been easier to hard code the reports.

   I wrote an "unlimited sorting levels" function once
   for Revelation DB ... pretty compact ... and not long
   afterwards I could NOT figure out how it worked. It *did*
   work though. Sometimes ya just get 'in the zone' when
   writing code and maybe yer head can't get back there
   later on ?

   The 'configurable' stuff ... sometimes you get a sort of
   next-level idea that SOUNDS great, but by the time you
   really get into it then it WOULD be just easier to
   write one-off reports or whatever.

   Once got about three days into a socket server, and
   scope-creep took over. Then I suddenly, rudely,
   realized I was re-inventing the FTP server. Oh well  :-)