Re: The joy of SQL

Subject	Re: The joy of SQL
Newsgroups	comp.os.linux.misc
References	(20 earlier) <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	2024-11-02 21:48 -0400
Message-ID	<uX2dnRuXzJsTS7v6nZ2dnZfqnPWdnZ2d@earthlink.com> (permalink)

Show all headers | 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