Rocksolid Light

Welcome to novaBBS (click a section below)

mail  files  register  newsreader  groups  login

Message-ID:  

Science is to computer science as hydrodynamics is to plumbing.

computers / comp.os.vms / Re: a cool database... as replacement for RMS index-sequential files:: Was: VSI working on alternatives to Oracle Classic database:

SubjectAuthor
* Re: a cool database... as replacement for RMS index-sequentialArne Vajhøj
`- Re: a cool database... as replacement for RMS index-sequential<kemain.nospam

1
Re: a cool database... as replacement for RMS index-sequential files:: Was: VSI working on alternatives to Oracle Classic database:

<sc0677$17hv$2@gioia.aioe.org>

  copy mid

https://www.novabbs.com/computers/article-flat.php?id=15736&group=comp.os.vms#15736

  copy link   Newsgroups: comp.os.vms
Path: i2pn2.org!i2pn.org!aioe.org!5Avcpu9drOe6MAssky6/+Q.user.gioia.aioe.org.POSTED!not-for-mail
From: arn...@vajhoej.dk (Arne Vajhøj)
Newsgroups: comp.os.vms
Subject: Re: a cool database... as replacement for RMS index-sequential
files:: Was: VSI working on alternatives to Oracle Classic database:
Date: Mon, 5 Jul 2021 19:56:25 -0400
Organization: Aioe.org NNTP Server
Lines: 20
Message-ID: <sc0677$17hv$2@gioia.aioe.org>
References: <ru9a9i$h7t$1@dont-email.me> <ru9bqm$vnn$1@dont-email.me>
<ru9dnt$gs7$1@gioia.aioe.org> <i6qvjrFfl8mU1@mid.individual.net>
NNTP-Posting-Host: 5Avcpu9drOe6MAssky6/+Q.user.gioia.aioe.org
Mime-Version: 1.0
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 8bit
X-Complaints-To: abuse@aioe.org
User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:78.0) Gecko/20100101
Thunderbird/78.11.0
Content-Language: en-US
X-Notice: Filtered by postfilter v. 0.9.2
 by: Arne Vajhøj - Mon, 5 Jul 2021 23:56 UTC

On 1/20/2021 10:13 AM, gérard Calliet wrote:
> Le 20/01/2021 à 15:12, Arne Vajhøj a écrit :
>> SQLite is a cool database, but I see it more as
>> replacement for RMS index-sequential files.
> Yeah?
>
> I understand you think replacing some RMS index-sequential files by
> relational database is something not totally impossible.
>
> It is a very unusual opinion. I'd like to hear more from you about that,
> examples if you have some, etc,...
>
> It is also a *big* subject for infinite discutions like we can have
> here, I hope we'll have.

I just posted a link to some text and code examples on
the topic.

Arne

Re: a cool database... as replacement for RMS index-sequential files:: Was: VSI working on alternatives to Oracle Classic database:

<mailman.10.1626012840.12468.info-vax_rbnsn.com@rbnsn.com>

  copy mid

https://www.novabbs.com/computers/article-flat.php?id=15832&group=comp.os.vms#15832

  copy link   Newsgroups: comp.os.vms
Path: i2pn2.org!i2pn.org!usenet.goja.nl.eu.org!weretis.net!feeder8.news.weretis.net!feeder5.news.weretis.net!news.solani.org!.POSTED!kishost2.serverpowered.net!not-for-mail
From:
Newsgroups: comp.os.vms
Subject: Re: a cool database... as replacement for RMS index-sequential
files:: Was: VSI working on alternatives to Oracle Classic database:
Date: Sun, 11 Jul 2021 11:13:16 -0300
Lines: 67
Message-ID: <mailman.10.1626012840.12468.info-vax_rbnsn.com@rbnsn.com>
References: <ru9a9i$h7t$1@dont-email.me> <ru9bqm$vnn$1@dont-email.me>
<ru9dnt$gs7$1@gioia.aioe.org> <i6qvjrFfl8mU1@mid.individual.net>
<sc0677$17hv$2@gioia.aioe.org>
<000d01d7765e$e5176cc0$af464640$@gmail.com>
Mime-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Injection-Info: solani.org;
logging-data="27840"; mail-complaints-to="abuse@news.solani.org"
To: "'comp.os.vms to email gateway'" <info-vax@rbnsn.com>
X-Mailman-Original-Message-ID: <000d01d7765e$e5176cc0$af464640$@gmail.com>
X-Mailer: Microsoft Outlook 16.0
X-Spam-Status: No, score=2.8
X-Antivirus-Status: Clean
In-Reply-To: <sc0677$17hv$2@gioia.aioe.org>
X-Antivirus: AVG (VPS 210710-10, 7/10/2021), Outbound message
List-Help: <mailto:info-vax-request@rbnsn.com?subject=help>
Cancel-Lock: sha1:D+0SjdhJk34KFnVz4AqIoCuqXI8=
X-Gm-Message-State: AOAM532fh60MUNuXx/h9A1bKaFNHaYSSeOXlqBvb4OCi8pAYbVDaH9FX
pVylOs11bH/ewT1sSkNjM6SslvKWtLY=
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025;
h=from:to:references:in-reply-to:subject:date:message-id:mime-version
:content-transfer-encoding:thread-index:content-language;
bh=TFzqKYsD5JeXoh8i54jqKAufY1ZD/t1ZyD9KHVtGngM=;
b=dGpufQZDgpoCo4jvyJlB77/alO5YwlLQxqux0hWXAvmwkKehZcWw//FdgGewIn+vEj
Lr+apbiGf7lq6Vs/7zQR3TbJmAZysQ3J6Qo3nkjnN0EGM+N42N1xZWdLAwbtBjo7gXE4
8wmuiNT71m1/DxO2T8pz33dmPGQaeuNsLTS9TqwJdBPnOeWAwRskMwdWE+TrSyQ05q8R
DyE8eeeMfUD7x/Fj1rBw/Xh5sveq08S9s67DLgFvH0zIQzrSZBg62KByOba0qWX8MDF3
zRhGbpsXSwPIbK0YzTVVdWUY1e0FhNCIkSYBNiBHiD8NI9aM9zZfjIwaDG+Uv9S7sE0Q
Pexw==
X-BeenThere: info-vax@rbnsn.com
X-Received: by 2002:a05:622a:387:: with SMTP id
j7mr16996191qtx.24.1626012797414;
Sun, 11 Jul 2021 07:13:17 -0700 (PDT)
X-Spam-Score: 28
List-Archive: <http://rbnsn.com/pipermail/info-vax_rbnsn.com/>
X-Mailman-Version: 2.1.33
Thread-Index: AQFZpK4OUF0AU2KqOnULfEAGBs+RyAHZWhYMAPOgg14Bt/wZqAIUKCnSrASktOA=
List-Subscribe: <http://rbnsn.com/mailman/listinfo/info-vax_rbnsn.com>,
<mailto:info-vax-request@rbnsn.com?subject=subscribe>
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
d=1e100.net; s=20161025;
h=x-gm-message-state:from:to:references:in-reply-to:subject:date
:message-id:mime-version:content-transfer-encoding:thread-index
:content-language;
bh=TFzqKYsD5JeXoh8i54jqKAufY1ZD/t1ZyD9KHVtGngM=;
b=DvKX57cCquqKSsLV3Kp+N1Qf6FTW4Gljxmz/obIboNAEdLSV4zRk0v1GzcsP8P/Rc4
envkKhWZb4AdRfhnhOmoRhrDJcHoZ1mglxWZp9c3kc8FViiHGGtuJCL5GVJPDvzZDMTD
cIPf3NrxQx8sZOiwq3yOxF0Vb0TspWFEj0gdE1OUnqt4SVFy8wCfE8GI7RwGmR83u7IY
OusJBPWwtyb6jn2QYXZ/oj6SG49+bMgK9X/UIjDqRdW6LwOox844fJngJ4h1dT53bauV
6h5mue7X/Snzl2OFyDwHm7TTHTKA5yj4xzLaFzJjonaOfNq4nRbNVh1n9rzs5QNO/LX6
4BNw==
X-Google-Smtp-Source: ABdhPJzVX68t+QQ0RPr8lx6ly3EUSOc/T1pGSz4wjM4FjT+Y44QLTWEP7x8ozH86Ha/clCVR19RM0A==
List-Unsubscribe: <http://rbnsn.com/mailman/options/info-vax_rbnsn.com>,
<mailto:info-vax-request@rbnsn.com?subject=unsubscribe>
X-Spam-Bar: ++
X-Spam-Flag: NO
X-Ham-Report: Spam detection software,
running on the system "kishost2.serverpowered.net",
has NOT identified this incoming email as spam. The original
message has been attached to this so you can view it or label
similar future email. If you have any questions, see
root\@localhost for details. Content preview: >
Content analysis details: (2.8 points, 5.0 required)
pts rule name description
---- ---------------------- --------------------------------------------------
3.0 BAYES_50 BODY: Bayes spam probability is 40 to 60%
[score: 0.5000]
0.0 FREEMAIL_FROM Sender email is commonly abused enduser mail
provider [kemain.nospam[at]gmail.com]
-0.0 SPF_PASS SPF: sender matches SPF record
0.1 DKIM_SIGNED Message has a DKIM or DK signature, not necessarily
valid
-0.1 DKIM_VALID_AU Message has a valid DKIM or DK signature from
author's domain
-0.1 DKIM_VALID Message has at least one valid DKIM or DK signature
-0.1 DKIM_VALID_EF Message has a valid DKIM or DK signature from
envelope-from domain
X-Mailman-Original-References: <ru9a9i$h7t$1@dont-email.me>
<ru9bqm$vnn$1@dont-email.me> <ru9dnt$gs7$1@gioia.aioe.org>
<i6qvjrFfl8mU1@mid.individual.net> <sc0677$17hv$2@gioia.aioe.org>
List-Id: "comp.os.vms to email gateway" <info-vax.rbnsn.com>
Precedence: list
List-Post: <mailto:info-vax@rbnsn.com>
Content-Language: en-ca
X-User-ID: eJwFwQERADEIAzBL41v6IAfY4V/CEodM81Mu+vpqu2KOV0LVfZmKiJOYRJoRi2aRsfd+TD4bmhCz
 by: - Sun, 11 Jul 2021 14:13 UTC

>-----Original Message-----
>From: Info-vax <info-vax-bounces@rbnsn.com> On Behalf Of Arne Vajhøj via
>Info-vax
>Sent: July-05-21 8:56 PM
>To: info-vax@rbnsn.com
>Cc: Arne Vajhøj <arne@vajhoej.dk>
>Subject: Re: [Info-vax] a cool database... as replacement for RMS index-
>sequential files:: Was: VSI working on alternatives to Oracle Classic
database:
>
>On 1/20/2021 10:13 AM, gérard Calliet wrote:
>> Le 20/01/2021 à 15:12, Arne Vajhøj a écrit :
>>> SQLite is a cool database, but I see it more as replacement for RMS
>>> index-sequential files.
>> Yeah?
>>
>> I understand you think replacing some RMS index-sequential files by
>> relational database is something not totally impossible.
>>
>> It is a very unusual opinion. I'd like to hear more from you about
>> that, examples if you have some, etc,...
>>
>> It is also a *big* subject for infinite discutions like we can have
>> here, I hope we'll have.
>
>I just posted a link to some text and code examples on the topic.
>
>Arne
>

As a general fyi, stay tuned for another database and host integration
technology options for OpenVMS.

- SharkSQL - 100% cluster compliant database, full ACID properties support,
OpenVMS is reference platform, later releases will include Windows, Windows
- CSQL - host program integration, combines C and SQL specification
- STR - service and transaction router, provides capability to address
requirement where services must find the way to the server where the initial
request processed has been processed and the execution state is stored

Documentation is in the process of being updated, but here is a previous
OpenVMS bootcamp presentation.
http://www.sharksql.com/DOCUMENTATION/SharkSQL%20Bootcamp%202017.pdf

Expect to hear more on the beta release this Sept-Oct timeframe.

Regards,

Kerry Main
Kerry dot main at starkgaming dot com

--
This email has been checked for viruses by AVG.
https://www.avg.com

1
server_pubkey.txt

rocksolid light 0.9.81
clearnet tor