From mboxrd@z Thu Jan  1 00:00:00 1970
X-Spam-Checker-Version: SpamAssassin 3.4.4 (2020-01-24) on polar.synack.me
X-Spam-Level: 
X-Spam-Status: No, score=-0.9 required=5.0 tests=BAYES_00,FORGED_GMAIL_RCVD,
	FREEMAIL_FROM autolearn=no autolearn_force=no version=3.4.4
Path: 
 eternal-september.org!reader01.eternal-september.org!reader02.eternal-september.org!.POSTED!not-for-mail
From: =?UTF-8?Q?Bj=c3=b6rn_Lundin?= <b.f.lundin@gmail.com>
Newsgroups: comp.lang.ada
Subject: Re: libgnadeodbc
Date: Wed, 11 Apr 2018 14:46:27 +0200
Organization: A noiseless patient Spider
Message-ID: <pal034$545$1@dont-email.me>
References: <ohra9f$hd2$1@gioia.aioe.org>
 <69b9d281-0697-452e-a5a5-475257c1435d@googlegroups.com>
 <pahpof$1d9l$1@gioia.aioe.org> <pajbqp$fah$1@franka.jacob-sparre.dk>
 <pakd4u$1o8k$1@gioia.aioe.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 8bit
Injection-Date: Wed, 11 Apr 2018 12:46:28 -0000 (UTC)
Injection-Info: reader02.eternal-september.org;
 posting-host="9e5b9bba9bd13383f8ebcd7b9d2e8aca";
	logging-data="5253"; mail-complaints-to="abuse@eternal-september.org";
	posting-account="U2FsdGVkX18+ZSAg2kbHciYUHn2MYjct"
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101
 Thunderbird/45.8.0
In-Reply-To: <pakd4u$1o8k$1@gioia.aioe.org>
Cancel-Lock: sha1:uxbe1SAO3lgVwYTkWYktWvM14BI=
Xref: reader02.eternal-september.org comp.lang.ada:51441
Date: 2018-04-11T14:46:27+02:00
List-Id: <comp.lang.ada>

On 2018-04-11 09:23, Dmitry A. Kazakov wrote:

> 
> 1. Do we need a shared persistent storage with a well-defined,
> concurrent, networking, consistent etc interface?

It would be nice to have.
As being one that *needs* DBMS, I'd like to have a consistent
interface to a DBMS. Yes there is ODBC, but runs real bad on AIX.
SQLite and Access (JET engine db) does not work well when many processes
access the same database. Having only one process, they may very well do.
But not in a system of processes.

The differences in SQL are mostly in the DDL area (create table etc)
than in DML (select/update etc)
and if you *need* a DBMS you don't create the database on the fly.
It is there to use, created by someone else.

I develop/maintain a system with ~1_000_000 locs (a Warehose control
system) and I know of 3 sql-statements in the code that differs
because of DBMS vendor (Oracle/MS-sql/Postgresql).
They all have to do with function 'substring' is called 'substr' by Oracle.

I get the feeling that SQL is frowned upon by this group,
but it is very useful even as is.


> 2. Must it be relational?

It must at least be easy to use 3rd party tools to generate reports from
The relational part is a way of not doubly define data, which is good.
But works clunky with objects though, since it is set based.




-- 
--
Björn