Path: ...!eternal-september.org!feeder2.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From: Lawrence D'Oliveiro <ldo@nz.invalid>
Newsgroups: comp.os.linux.misc
Subject: Re: The joy of SQL
Date: Thu, 7 Nov 2024 03:14:14 -0000 (UTC)
Organization: A noiseless patient Spider
Lines: 32
Message-ID: <vghba5$2gfu0$1@dont-email.me>
References: <pan$96411$d204da43$cc34bb91$1fe98651@linux.rocks>
	<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>
	<A7udnUgO7Ye45Ln6nZ2dnZfqn_ednZ2d@earthlink.com>
	<vg3fal$3d77d$6@dont-email.me>
	<lUmdnTqFc8TPK7j6nZ2dnZfqn_GdnZ2d@earthlink.com>
	<vg53kg$3otcc$11@dont-email.me>
	<uX2dnRuXzJsTS7v6nZ2dnZfqnPWdnZ2d@earthlink.com>
	<vg912r$j4vj$4@dont-email.me>
	<SIWdnVp4xI2DuLX6nZ2dnZfqnPudnZ2d@earthlink.com>
	<vgbgm2$14q8q$5@dont-email.me>
	<pJScnYa_tafcXLT6nZ2dnZfqn_SdnZ2d@earthlink.com>
	<vggeim$27vjt$5@dont-email.me>
	<x2udnQJd-vlTmbH6nZ2dnZfqn_adnZ2d@earthlink.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
Injection-Date: Thu, 07 Nov 2024 04:14:14 +0100 (CET)
Injection-Info: dont-email.me; posting-host="62c4ffc9f6144f4c1b882d43e665b844";
	logging-data="2637760"; mail-complaints-to="abuse@eternal-september.org";	posting-account="U2FsdGVkX19r+HpBJFlWC5p740If0jZg"
User-Agent: Pan/0.160 (Toresk; )
Cancel-Lock: sha1:7Mjo563QGN/Iu2I9LJAQpieWVf0=
Bytes: 2986

On Wed, 6 Nov 2024 19:07:41 -0500, 186282@ud0s4.net wrote:

> On 11/6/24 2:03 PM, Lawrence D'Oliveiro wrote:
>> On Tue, 5 Nov 2024 01:54:56 -0500, 186282@ud0s4.net wrote:
>> 
>>> On 11/4/24 5:09 PM, Lawrence D'Oliveiro wrote:
>>>
>>>> On Sun, 3 Nov 2024 20:36:29 -0500, 186282@ud0s4.net wrote:
>>>>
>>>>> Why join when the MV approach keeps yer data in an already-joined
>>>>> state ???
>>>>
>>>> Because the MV approach makes that hard to maintain.
>>>
>>> Never noticed that ...
>> 
>> What kind of database doesn’t need updating?
> 
> That wasn't my point ...

It was mine.

>> LDAP has multi-valued attributes. But then, it has a different model
>> where all the records are in the same table, and the primary key has a
>> hierarchical form. And it has a “modify” operation that can add/remove
>> individual values for an attribute.
> 
> LDAP is a kinda lightweight 'DB' - not built to be really 'general
> purpose'.

Think of it scaling to contain directory information across an entire 
multinational enterprise ... and then try saying it’s not “lightweight”.