Path: news.eternal-september.org!eternal-september.org!news.eternal-september.org!feeder2.eternal-september.org!border-2.nntp.ord.giganews.com!nntp.giganews.com!Xl.tags.giganews.com!local-1.nntp.ord.giganews.com!nntp.earthlink.com!news.earthlink.com.POSTED!not-for-mail
NNTP-Posting-Date: Fri, 01 Nov 2024 03:57:24 +0000
Subject: Re: The joy of SQL
Newsgroups: comp.os.linux.misc
References: <pan$96411$d204da43$cc34bb91$1fe98651@linux.rocks>
 <vf98l2$1lsqn$3@dont-email.me> <20241022153631.00002ec9@gmail.com>
 <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>
From: "186282@ud0s4.net" <186283@ud0s4.net>
Organization: wokiesux
Date: Thu, 31 Oct 2024 23:57:11 -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: <vfv7j2$2j460$1@dont-email.me>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Language: en-US
Content-Transfer-Encoding: 7bit
Message-ID: <D1GdnVpNqtM5zLn6nZ2dnZfqnPWdnZ2d@earthlink.com>
Lines: 25
X-Usenet-Provider: http://www.giganews.com
NNTP-Posting-Host: 99.101.150.97
X-Trace: sv3-OdqXEaSNnGxbkVC5YDS7yXJjVm9oFEnyzSY1STkuqHlW2znaQqqccoA+s00fWD1LEjLxWRL2ZAX/off!X9tHyYFjflnA+88REC1bEU5ltBZxK937kJne6XoWv1j/uOIP84sruWUwszEH1u6gvHXVgRZfNd2+!ckftOn7VX6tIuOB8Jw9g
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

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.

   I'd rather do MV, even if updates are a little odd,
   than be forced into flat-field fascism.