Sujet : Re: The joy of SQL
De : ldo (at) *nospam* nz.invalid (Lawrence D'Oliveiro)
Groupes : comp.os.linux.miscDate : 01. Nov 2024, 05:14:42
Autres entêtes
Organisation : A noiseless patient Spider
Message-ID : <vg1kji$33ioi$1@dont-email.me>
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 26
User-Agent : Pan/0.160 (Toresk; )
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.
…