Sujet : Re: The joy of SQL
De : 186283 (at) *nospam* ud0s4.net (186282@ud0s4.net)
Groupes : comp.os.linux.miscDate : 02. Nov 2024, 06:19:13
Autres entêtes
Organisation : wokiesux
Message-ID : <lUmdnTqFc8TPK7j6nZ2dnZfqn_GdnZ2d@earthlink.com>
References : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
User-Agent : Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Thunderbird/78.13.0
On 11/1/24 4:56 PM, Lawrence D'Oliveiro wrote:
On Fri, 1 Nov 2024 02:45:56 -0400, 186282@ud0s4.net wrote:
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:
>
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 ...
“Religion” is when followers are rewarded for believing in doctrine, not
just in the absence of evidence, but directly contrary to the evidence.
In other words, I think you’ve just admitted my point.
And you just admitted mine :-)
I don't think there's any distinct "advantage" these
days in either flat-file or MV. Plusses and minuses
for each approach. It's all a matter of how you FEEL
data should be structured/stored.
In short, 'religion'.
But I'm pretty libertine, so you can have your
religion so long as you tolerate mine :-)
…