Re: The joy of SQL

Subject	Re: The joy of SQL
Newsgroups	comp.os.linux.misc
References	(20 earlier) <vg53kg$3otcc$11@dont-email.me> <uX2dnRuXzJsTS7v6nZ2dnZfqnPWdnZ2d@earthlink.com> <vg912r$j4vj$4@dont-email.me> <SIWdnVp4xI2DuLX6nZ2dnZfqnPudnZ2d@earthlink.com> <vgbgm2$14q8q$5@dont-email.me>
From	"186282@ud0s4.net" <186283@ud0s4.net>
Organization	wokiesux
Date	2024-11-05 01:54 -0500
Message-ID	<pJScnYa_tafcXLT6nZ2dnZfqn_SdnZ2d@earthlink.com> (permalink)

Show all headers | View raw

On 11/4/24 5:09 PM, Lawrence D'Oliveiro wrote:
> On Sun, 3 Nov 2024 20:36:29 -0500, 186282@ud0s4.net wrote:
> 
>> On 11/3/24 6:30 PM, Lawrence D'Oliveiro wrote:
>>> On Sat, 2 Nov 2024 21:48:47 -0400, 186282@ud0s4.net wrote:
>>>
>>>> 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.
>>>
>>> This is why you have joins: so that you can retrieve multiple related
>>> records with a single query. This is the proper relational way of doing
>>> it.
>>
>> 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 ...

   Everything always in nice structure/order and
   all-together. Nirvana.


>> Python, and to some extent FORTRAN, have very good string
>> list-manipulation/reading/writing/insertion/deletion capabilities ...
>> it'd be fairly easy to set up a MV DB in those languages.
> 
> Python is quite good at SQL database manipulations. This include
> setting up complicated joins.


   But why would you want to use SQL ? Insane  :-)


> I have some basic tutorials here
> <https://gitlab.com/ldo/python_topics_notebooks/-/blob/master/Databases,%20Iterators%20&%20Looping.ipynb?ref_type=heads>
> 
>> The old PICK-ish DB I spent a decade with used pure ASCII-delimited
>> fields (this was pre-unicode, you could bring 'em up in a text editor
>> and see all the old IBM-BIOS high-ascii symbols).
> 
> I know, it was crap. Probably scarred you for life, which is why you
> think the way you do.

   LOVED those little IBM chars. That they buried them SO
   deep in the unicode codex suggests deliberate bias.

   Anyway, clearly, our religions are never gonna be
   in-sync here.

   You CAN download OpenQM if you want, see how the MV
   approach can be useful. Having used both, and seeing
   flat-file forced down everyone's throats, I'm gonna
   stick with my belief MV has a slight edge and is
   more sane and 'organic'.

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

Thread

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 rbowman <bowman@montana.com> - 2024-11-11 00:29 +0000
                Re: The joy of Linux "186282@ud0s4.net" <186283@ud0s4.net> - 2024-11-10 19:44 -0500
                Re: The joy of Linux rbowman <bowman@montana.com> - 2024-11-11 03:03 +0000
                Re: The joy of Linux "186282@ud0s4.net" <186283@ud0s4.net> - 2024-11-12 01:19 -0500
                Re: The joy of Linux rbowman <bowman@montana.com> - 2024-11-12 07:47 +0000
                Re: The joy of Linux "186282@ud0s4.net" <186283@ud0s4.net> - 2024-11-13 03:19 -0500
                Re: The joy of Linux rbowman <bowman@montana.com> - 2024-11-13 18:30 +0000
                Re: The joy of Linux "186282@ud0s4.net" <186283@ud0s4.net> - 2024-11-14 00:59 -0500
                Re: The joy of Linux The Natural Philosopher <tnp@invalid.invalid> - 2024-11-12 08:38 +0000
                Re: The joy of Linux "186282@ud0s4.net" <186283@ud0s4.net> - 2024-11-13 03:50 -0500
                Re: The joy of Linux The Natural Philosopher <tnp@invalid.invalid> - 2024-11-13 08:57 +0000
                Re: The joy of Linux "186282@ud0s4.net" <186283@ud0s4.net> - 2024-11-14 01:08 -0500
                Re: The joy of Linux Rich <rich@example.invalid> - 2024-11-14 14:16 +0000
                Re: The joy of Linux The Natural Philosopher <tnp@invalid.invalid> - 2024-11-14 16:06 +0000
                Re: The joy of Linux The Natural Philosopher <tnp@invalid.invalid> - 2024-11-14 16:08 +0000
                Re: The joy of Linux "186282@ud0s4.net" <186283@ud0s4.net> - 2024-11-15 03:04 -0500
                Re: The joy of Linux "186282@ud0s4.net" <186283@ud0s4.net> - 2024-11-16 01:04 -0500
                Re: The joy of Linux rbowman <bowman@montana.com> - 2024-11-16 06:13 +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

csiph-web