Re: The joy of SQL

From	Lawrence D'Oliveiro <ldo@nz.invalid>
Newsgroups	comp.os.linux.misc
Subject	Re: The joy of SQL
Date	2024-11-01 04:14 +0000
Organization	A noiseless patient Spider
Message-ID	<vg1kji$33ioi$1@dont-email.me> (permalink)
References	(21 earlier) <IPCcnWfc5tPKV7z6nZ2dnZfqn_QAAAAA@earthlink.com> <vfupjk$2d5v5$7@dont-email.me> <etqcnYUgc8mBir76nZ2dnZfqnPudnZ2d@earthlink.com> <vfv7j2$2j460$1@dont-email.me> <D1GdnVpNqtM5zLn6nZ2dnZfqnPWdnZ2d@earthlink.com>

Show all headers | View raw

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.

Back to comp.os.linux.misc | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Re: The joy of FORTH (not) John Ames <commodorejohn@gmail.com> - 2024-10-22 15:36 -0700
  Re: The joy of FORTH (not) magardner2010 <magardner2010@gmail.com> - 2024-10-23 14:33 +0300
    Re: The joy of FORTH (not) Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-10-23 21:00 +0000
      Re: The joy of FORTH (not) magardner2010 <magardner2010@gmail.com> - 2024-10-24 06:45 +0300
        Re: The joy of FORTH (not) Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-10-24 03:54 +0000
          Re: The joy of FORTH (not) "186282@ud0s4.net" <186283@ud0s4.net> - 2024-10-24 02:03 -0400
            Re: The joy of Ada Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-10-24 06:36 +0000
              Re: The joy of Ada "186282@ud0s4.net" <186283@ud0s4.net> - 2024-10-24 03:11 -0400
                Re: The joy of Ada Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-10-24 20:50 +0000
                Re: The joy of Ada "186282@ud0s4.net" <186283@ud0s4.net> - 2024-10-24 21:23 -0400
                Re: The joy of Ada Charlie Gibbs <cgibbs@kltpzyxm.invalid> - 2024-10-25 17:32 +0000
                Re: The joy of Ada rbowman <bowman@montana.com> - 2024-10-25 19:46 +0000
                Re: The joy of SQL Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-10-25 22:41 +0000
                Re: The joy of SQL "186282@ud0s4.net" <186283@ud0s4.net> - 2024-10-25 21:58 -0400
                Re: The joy of SQL Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-10-26 02:40 +0000
                Re: The joy of SQL rbowman <bowman@montana.com> - 2024-10-26 06:02 +0000
                Re: The joy of SQL p.dean@invalid.net (Peter Dean) - 2024-10-26 16:35 +0000
                Re: The joy of SQL p.dean@invalid.net (Peter Dean) - 2024-10-26 16:52 +0000
                Re: The joy of SQL rbowman <bowman@montana.com> - 2024-10-26 05:53 +0000
                Re: The joy of SQL Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-10-26 07:18 +0000
                Re: The joy of SQL John Ames <commodorejohn@gmail.com> - 2024-10-28 08:04 -0700
                Re: The joy of SQL Chris Ahlstrom <OFeem1987@teleworm.us> - 2024-10-28 11:33 -0400
                Re: The joy of SQL "Kerr-Mudd, John" <admin@127.0.0.1> - 2024-10-28 17:59 +0000
                Re: The joy of SQL The Natural Philosopher <tnp@invalid.invalid> - 2024-10-26 11:07 +0100
                Re: The joy of SQL Lars Poulsen <lars@cleo.beagle-ears.com> - 2024-10-26 16:44 +0000
                Re: The joy of SQL antispam@fricas.org (Waldek Hebisch) - 2024-10-26 18:48 +0000
                Re: The joy of SQL The Natural Philosopher <tnp@invalid.invalid> - 2024-10-27 09:52 +0000
                Re: The joy of SQL Mister Johnson <root@example.net> - 2024-10-27 13:00 +0000
                Re: The joy of SQL rbowman <bowman@montana.com> - 2024-10-27 17:40 +0000
                Re: The joy of SQL John Levine <johnl@taugh.com> - 2024-10-27 18:38 +0000
                Re: The joy of SQL Charlie Gibbs <cgibbs@kltpzyxm.invalid> - 2024-10-28 02:42 +0000
                Re: The joy of SQL The Natural Philosopher <tnp@invalid.invalid> - 2024-10-27 09:32 +0000
                Re: The joy of SQL rbowman <bowman@montana.com> - 2024-10-27 17:35 +0000
                Re: The joy of Ada Charlie Gibbs <cgibbs@kltpzyxm.invalid> - 2024-10-26 04:38 +0000
                Re: The joy of Ada Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-10-26 05:39 +0000
                Re: The joy of Ada The Natural Philosopher <tnp@invalid.invalid> - 2024-10-26 11:08 +0100
                Re: The joy of Ada Charlie Gibbs <cgibbs@kltpzyxm.invalid> - 2024-10-26 18:01 +0000
                Re: The joy of Linux Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-10-26 20:26 +0000
                Re: The joy of Ada The Natural Philosopher <tnp@invalid.invalid> - 2024-10-27 09:46 +0000
                Re: The joy of Ada rbowman <bowman@montana.com> - 2024-10-27 18:40 +0000
                Re: The joy of Ada Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-10-27 21:30 +0000
                Re: The joy of Ada "186282@ud0s4.net" <186283@ud0s4.net> - 2024-10-28 00:58 -0400
                Re: The joy of Ada Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-10-28 05:09 +0000
                Re: The joy of Ada Charlie Gibbs <cgibbs@kltpzyxm.invalid> - 2024-10-28 05:18 +0000
                Re: The joy of Linux Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-10-29 04:56 +0000
                Re: The joy of Linux Charlie Gibbs <cgibbs@kltpzyxm.invalid> - 2024-10-29 18:35 +0000
                Re: The joy of Linux Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-10-30 00:14 +0000
                Re: The joy of Linux rbowman <bowman@montana.com> - 2024-10-30 01:24 +0000
                Re: The joy of Linux "186282@ud0s4.net" <186283@ud0s4.net> - 2024-10-30 02:00 -0400
                Re: The joy of Linux Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-10-31 02:20 +0000
                Re: The joy of Linux Lars Poulsen <lars@cleo.beagle-ears.com> - 2024-11-03 19:19 +0000
                Re: The joy of Linux Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-11-03 23:28 +0000
                Re: The joy of Linux The Natural Philosopher <tnp@invalid.invalid> - 2024-11-04 13:19 +0000
                Re: The joy of Linux Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-11-04 22:13 +0000
                Re: The joy of Linux "186282@ud0s4.net" <186283@ud0s4.net> - 2024-11-04 22:33 -0500
                Re: The joy of Linux Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-11-06 23:00 +0000
                Re: The joy of Linux John Ames <commodorejohn@gmail.com> - 2024-11-04 14:26 -0800
                Re: The joy of Linux The Natural Philosopher <tnp@invalid.invalid> - 2024-11-05 13:53 +0000
                Re: The joy of Linux "186282@ud0s4.net" <186283@ud0s4.net> - 2024-11-06 03:35 -0500
                Re: The joy of Linux The Natural Philosopher <tnp@invalid.invalid> - 2024-11-06 11:31 +0000
                Re: The joy of Linux rbowman <bowman@montana.com> - 2024-11-06 17:59 +0000
                Re: The joy of Linux The Natural Philosopher <tnp@invalid.invalid> - 2024-11-06 18:44 +0000
                Re: The joy of Linux rbowman <bowman@montana.com> - 2024-11-06 18:55 +0000
                Re: The joy of Linux The Natural Philosopher <tnp@invalid.invalid> - 2024-11-07 10:40 +0000
                OT: (politics) [was Re: The joy of Linux] Robert Riches <spamtrap42@jacob21819.net> - 2024-11-08 03:28 +0000
                Re: OT: (politics) [was Re: The joy of Linux] The Natural Philosopher <tnp@invalid.invalid> - 2024-11-08 12:37 +0000
                Re: OT: (politics) [was Re: The joy of Linux] Rich <rich@example.invalid> - 2024-11-08 15:50 +0000
                Re: The joy of Linux D <nospam@example.net> - 2024-11-06 21:55 +0100
                Re: The joy of Linux The Natural Philosopher <tnp@invalid.invalid> - 2024-11-07 11:25 +0000
                Re: The joy of Linux D <nospam@example.net> - 2024-11-06 21:46 +0100
                Re: The joy of Linux Chris Ahlstrom <OFeem1987@teleworm.us> - 2024-11-06 16:43 -0500
                Re: The joy of Linux The Natural Philosopher <tnp@invalid.invalid> - 2024-11-07 10:50 +0000
                Re: The joy of Linux rbowman <bowman@montana.com> - 2024-11-07 01:31 +0000
                Re: The joy of Linux The Natural Philosopher <tnp@invalid.invalid> - 2024-11-07 10:52 +0000
                Re: The joy of Linux rbowman <bowman@montana.com> - 2024-11-07 20:10 +0000
                Re: The joy of Linux The Natural Philosopher <tnp@invalid.invalid> - 2024-11-08 03:06 +0000
                Re: The joy of Linux rbowman <bowman@montana.com> - 2024-11-08 04:12 +0000
                Re: The joy of Linux The Natural Philosopher <tnp@invalid.invalid> - 2024-11-08 12:43 +0000
                Re: The joy of Linux rbowman <bowman@montana.com> - 2024-11-08 18:56 +0000
                Re: The joy of Linux Pancho <Pancho.Jones@proton.me> - 2024-11-08 22:33 +0000
                Re: The joy of Linux rbowman <bowman@montana.com> - 2024-11-09 02:16 +0000
                Re: The joy of Linux The Natural Philosopher <tnp@invalid.invalid> - 2024-11-07 10:45 +0000
                Re: The joy of Linux Rich <rich@example.invalid> - 2024-11-07 19:23 +0000
                Re: The joy of Linux The Natural Philosopher <tnp@invalid.invalid> - 2024-11-08 02:46 +0000
                Re: The joy of Linux Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-11-06 22:59 +0000
                Re: The joy of Linux Rich <rich@example.invalid> - 2024-11-06 13:20 +0000
                Re: The joy of Linux The Natural Philosopher <tnp@invalid.invalid> - 2024-11-06 14:04 +0000
                Re: The joy of Linux D <nospam@example.net> - 2024-11-06 16:49 +0100
                Re: The joy of Linux The Natural Philosopher <tnp@invalid.invalid> - 2024-11-06 18:40 +0000
                Re: The joy of Linux rbowman <bowman@montana.com> - 2024-11-06 18:52 +0000
                Re: The joy of Linux John Ames <commodorejohn@gmail.com> - 2024-11-06 11:14 -0800
                Re: The joy of Linux rbowman <bowman@montana.com> - 2024-11-07 01:18 +0000
                Re: The joy of Linux D <nospam@example.net> - 2024-11-06 21:56 +0100
                Re: The joy of Linux rbowman <bowman@montana.com> - 2024-11-07 01:21 +0000
                Re: The joy of Linux D <nospam@example.net> - 2024-11-06 21:52 +0100
                Re: The joy of Linux Robert Riches <spamtrap42@jacob21819.net> - 2024-11-07 05:11 +0000
                Re: The joy of Linux The Natural Philosopher <tnp@invalid.invalid> - 2024-11-07 11:50 +0000
                Re: The joy of Linux rbowman <bowman@montana.com> - 2024-11-06 18:09 +0000
                Re: The joy of Linux rbowman <bowman@montana.com> - 2024-11-06 18:05 +0000
                Re: The joy of Linux Rich <rich@example.invalid> - 2024-11-06 18:17 +0000
                Re: The joy of Linux rbowman <bowman@montana.com> - 2024-11-06 19:01 +0000
                Re: The joy of Linux "186282@ud0s4.net" <186283@ud0s4.net> - 2024-10-30 01:40 -0400
                Re: The joy of Ada "186282@ud0s4.net" <186283@ud0s4.net> - 2024-10-30 01:55 -0400
                Re: The joy of SQL Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-10-31 02:21 +0000
                Re: The joy of SQL "186282@ud0s4.net" <186283@ud0s4.net> - 2024-10-31 01:35 -0400
                Re: The joy of SQL Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-10-31 06:20 +0000
                Re: The joy of SQL "186282@ud0s4.net" <186283@ud0s4.net> - 2024-10-31 23:57 -0400
                Re: The joy of SQL Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-11-01 04:14 +0000
                Re: The joy of SQL "186282@ud0s4.net" <186283@ud0s4.net> - 2024-11-01 02:45 -0400
                Re: The joy of SQL Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-11-01 20:56 +0000
                Re: The joy of SQL "186282@ud0s4.net" <186283@ud0s4.net> - 2024-11-02 01:19 -0400
                Re: The joy of SQL Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-11-02 06:18 +0000
                Re: The joy of SQL "186282@ud0s4.net" <186283@ud0s4.net> - 2024-11-02 03:21 -0400
                Re: The joy of SQL Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-11-03 00:15 +0000
                Re: The joy of SQL "186282@ud0s4.net" <186283@ud0s4.net> - 2024-11-02 21:51 -0400
                Re: The joy of SQL Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-11-03 23:32 +0000
                Re: The joy of SQL The Natural Philosopher <tnp@invalid.invalid> - 2024-11-02 11:49 +0000
                Re: The joy of SQL "186282@ud0s4.net" <186283@ud0s4.net> - 2024-11-02 21:48 -0400
                Re: The joy of SQL Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-11-03 23:30 +0000
                Re: The joy of SQL "186282@ud0s4.net" <186283@ud0s4.net> - 2024-11-03 20:36 -0500
                Re: The joy of SQL Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-11-04 22:09 +0000
                Re: The joy of SQL "186282@ud0s4.net" <186283@ud0s4.net> - 2024-11-05 01:54 -0500
                Re: The joy of SQL Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-11-06 19:03 +0000
                Re: The joy of SQL "186282@ud0s4.net" <186283@ud0s4.net> - 2024-11-06 19:07 -0500
                Re: The joy of SQL Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-11-07 03:14 +0000
                Re: The joy of Ada "186282@ud0s4.net" <186283@ud0s4.net> - 2024-10-30 01:52 -0400
                Re: The joy of Ada "186282@ud0s4.net" <186283@ud0s4.net> - 2024-10-25 21:40 -0400
                Re: The joy of Ada Charlie Gibbs <cgibbs@kltpzyxm.invalid> - 2024-10-26 04:38 +0000
                Re: The joy of Ada rbowman <bowman@montana.com> - 2024-10-26 06:27 +0000
          Re: The joy of strong typing magardner2010 <magardner2010@gmail.com> - 2024-10-24 10:56 +0300
            Re: The joy of Python Lawrence D'Oliveiro <ldo@nz.invalid> - 2024-10-24 20:55 +0000
    Re: The joy of FORTH (not) Peter Flass <peter_flass@yahoo.com> - 2024-10-24 17:13 -0700
      Re: The joy of FORTH (not) "186282@ud0s4.net" <186283@ud0s4.net> - 2024-10-25 03:24 -0400
  Re: The joy of FORTH (not) Jim Jackson <jj@franjam.org.uk> - 2024-10-23 14:41 +0000

csiph-web