Re: The joy of SQL

Path	csiph.com!weretis.net!feeder9.news.weretis.net!border-3.nntp.ord.giganews.com!nntp.giganews.com!local-2.nntp.ord.giganews.com!Xl.tags.giganews.com!local-4.nntp.ord.giganews.com!nntp.earthlink.com!news.earthlink.com.POSTED!not-for-mail
NNTP-Posting-Date	Sun, 03 Nov 2024 01:49:02 +0000
Subject	Re: The joy of SQL
Newsgroups	comp.os.linux.misc
References	<pan$96411$d204da43$cc34bb91$1fe98651@linux.rocks> <vfcptl$2hjp4$1@dont-email.me> <CCadnQ4B-oXSboT6nZ2dnZfqnPidnZ2d@earthlink.com> <vfebuf$2pkdl$4@dont-email.me> <Os6dnedZ6uqxbof6nZ2dnZfqn_WdnZ2d@earthlink.com> <nCQSO.297925$EEm7.62385@fx16.iad> <lo2as5Fj476U1@mid.individual.net> <qn_SO.297938$EEm7.187626@fx16.iad> <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>
From	"186282@ud0s4.net" <186283@ud0s4.net>
Organization	wokiesux
Date	Sat, 2 Nov 2024 21:48:47 -0400
User-Agent	Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101 Thunderbird/78.13.0
MIME-Version	1.0
In-Reply-To	<vg53kg$3otcc$11@dont-email.me>
Content-Type	text/plain; charset=utf-8; format=flowed
Content-Language	en-US
Content-Transfer-Encoding	8bit
Message-ID	<uX2dnRuXzJsTS7v6nZ2dnZfqnPWdnZ2d@earthlink.com> (permalink)
Lines	44
X-Usenet-Provider	http://www.giganews.com
NNTP-Posting-Host	99.101.150.97
X-Trace	sv3-JqnLsnpLet+mreqhDIj3kCusmCHedqk6aMXm9XHmVZgG4IIca7L8RUSo8Xjz/f2aQf9/3ZQt2Kd4e7O!UdgbGNWN26SsJ8U75KR43DUyScmmyvbcxwc41eIpwPAf3b/0vrt9/K7P5tpuya9AVCJT1nyr5Nkd!uo26A+XIjREAvsnSwFHM
X-Abuse-and-DMCA-Info	Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info	Otherwise we will be unable to process your complaint properly
X-Postfilter	1.3.40
Xref	csiph.com comp.os.linux.misc:60384

Show key headers only | View raw

On 11/2/24 7:49 AM, The Natural Philosopher wrote:
> On 02/11/2024 05:19, 186282@ud0s4.net wrote:
>> 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'.
> 
> MV? no one seems to know what 'MV' is. Did you invent it?

   ???

   MV = Multi-Valued = Data fields that can hold long
   lists of that KIND of information. If you have a
   fleet-tracking DB then there'd be ONE field saying
   "mileage" and likely another for "fuel-added" and
   they'd just be added-to over time. The record for
   that vehicle is read all-at-once, rather than there
   being dozens, hundreds, of records for said vehicle
   every time it was fueled-up.

> Insofar as data storage goes there are considerable advantages to a 
> normalised database with indices et al.
> 
> It is not a religious choice.

   Ummm ... I'd still say so.

   MV DBs can also have indexes BTW.

> The religion comes in with supporters who have been told that 
> *irrespective of the actual context or uses* it is 'simply the best'
> 
> Rules are for the guidance of wise men and the obedience of fools.

   MV DBs are still sold - sometimes for really serious
   money - so clearly a lot of people/corps DO like that
   way of dealing with data. OpenQM is likely best known
   to Linux users.

https://www.predictiveanalyticstoday.com/top-free-commercial-multivalue-database/

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

Thread

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: OT: (politics) [was Re: The joy of Linux] The Natural Philosopher <tnp@invalid.invalid> - 2024-11-09 06:01 +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-11-09 20:37 -0500
                Re: The joy of Linux rbowman <bowman@montana.com> - 2024-11-10 02:38 +0000
                Re: The joy of Linux "186282@ud0s4.net" <186283@ud0s4.net> - 2024-11-10 02:08 -0500
                Re: The joy of Linux rbowman <bowman@montana.com> - 2024-11-10 08:33 +0000
                Re: The joy of Linux Charlie Gibbs <cgibbs@kltpzyxm.invalid> - 2024-11-10 19:53 +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

csiph-web