Sujet : Re: The joy of SQL
De : ldo (at) *nospam* nz.invalid (Lawrence D'Oliveiro)
Groupes : comp.os.linux.miscDate : 31. Oct 2024, 07:20:18
Autres entêtes
Organisation : A noiseless patient Spider
Message-ID : <vfv7j2$2j460$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 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.
…