Path: ...!Xl.tags.giganews.com!local-2.nntp.ord.giganews.com!nntp.earthlink.com!news.earthlink.com.POSTED!not-for-mail
NNTP-Posting-Date: Fri, 01 Nov 2024 06:45:57 +0000
Subject: Re: The joy of SQL
Newsgroups: comp.os.linux.misc
References: <pan$96411$d204da43$cc34bb91$1fe98651@linux.rocks>
 <vfamtn$21039$1@dont-email.me> <vfbo4u$28v56$5@dont-email.me>
 <vfcft1$2ftu7$1@dont-email.me> <vfcgcv$2g0g1$3@dont-email.me>
 <nv2dnXjQd4-8foT6nZ2dnZfqn_sAAAAA@earthlink.com>
 <vfcptl$2hjp4$1@dont-email.me>
 <CCadnQ4B-oXSboT6nZ2dnZfqnPidnZ2d@earthlink.com>
 <vfebuf$2pkdl$4@dont-email.me>
 <Os6dnedZ6uqxbof6nZ2dnZfqn_WdnZ2d@earthlink.com>
 <nCQSO.297925$EEm7.62385@fx16.iad> <lo2as5Fj476U1@mid.individual.net>
 <qn_SO.297938$EEm7.187626@fx16.iad> <vfif3b$3m055$4@dont-email.me>
 <y7aTO.203218$WtV9.22893@fx10.iad> <vfl257$bic6$4@dont-email.me>
 <vfmbct$jekn$9@dont-email.me>
 <VjKdnS8_KJVnhIL6nZ2dnZfqnPSdnZ2d@earthlink.com>
 <vfn6b5$rnim$1@dont-email.me> <69FTO.586561$1m96.459888@fx15.iad>
 <IPCcnWfc5tPKV7z6nZ2dnZfqn_QAAAAA@earthlink.com>
 <vfupjk$2d5v5$7@dont-email.me>
 <etqcnYUgc8mBir76nZ2dnZfqnPudnZ2d@earthlink.com>
 <vfv7j2$2j460$1@dont-email.me>
 <D1GdnVpNqtM5zLn6nZ2dnZfqnPWdnZ2d@earthlink.com>
 <vg1kji$33ioi$1@dont-email.me>
From: "186282@ud0s4.net" <186283@ud0s4.net>
Organization: wokiesux
Date: Fri, 1 Nov 2024 02:45:56 -0400
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: <vg1kji$33ioi$1@dont-email.me>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Language: en-US
Content-Transfer-Encoding: 8bit
Message-ID: <A7udnUgO7Ye45Ln6nZ2dnZfqn_ednZ2d@earthlink.com>
Lines: 45
X-Usenet-Provider: http://www.giganews.com
NNTP-Posting-Host: 99.101.150.97
X-Trace: sv3-kB4Zc4mFSAaRg4xgiJAEqn+MsELqApYT/iiDWILeznjCo02CBbLGR1vjhCatoCienkF+pvSqxetuQPV!Gx+atkJYmGFY6BHZmyD89qWUkM16t6JMseKRSh17Zf1hRIzx8nQcuab2BqxJgwiYlMI9CcEP7OnO!ggkFyk2yRoiZbichKkAS
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: 3741

On 11/1/24 12:14 AM, Lawrence D'Oliveiro wrote:
> On Thu, 31 Oct 2024 23:57:11 -0400, 186282@ud0s4.net wrote:
> 
>> On 10/31/24 2:20 AM, Lawrence D'Oliveiro wrote:
>>
>>> On Thu, 31 Oct 2024 01:35:23 -0400, 186282@ud0s4.net wrote:
>>>
>>>> On 10/30/24 10:21 PM, Lawrence D'Oliveiro wrote:
>>>>
>>>>> On Wed, 30 Oct 2024 01:55:35 -0400, 186282@ud0s4.net wrote:
>>>>>
>>>>>> SQL and flat-file DBs are kind of the all-gobbling monsters.
>>>>>>
>>>>>> But MV is still the better, saner, way to organize many kinds of
>>>>>> data.
>>>>>
>>>>> The trouble with unnormalized fields is: how do you do updates? You
>>>>> have to delete all the values and insert them all again.
>>>>
>>>> Updates CAN be annoying.
>>>
>>> Easy way to remove the annoyance: normalize your field values.
>>
>> But the 'easy' way removes some of your flexibility and reasoning
>> ability in the process.
> 
> No it doesn’t. Prove me wrong.


   This can't be "proven" per-se ... it's a matter of
   how you "feel" about how data should be represented
   to best effect/clarity. Call it 'religion' if you want ...

   Hey, which is "better", French or English ? Totally
   depends ....

   Having used flat and MV, SQL and Non, my 'spiritual bent'
   is for MV ... 'PICK-ish'.

   In CPU-microseconds, the sheer volume of records produced
   using flat systems -vs- the slight xtra effort needed to
   update MV records ... pretty much even - though I'm not
   entirely sure any benchmarks exist. On mag disks, the
   volume thing might be more of a drag, but with e-disks
   maybe not as much.