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.3 required=5.0 tests=BAYES_00,
	REPLYTO_WITHOUT_TO_CC autolearn=no autolearn_force=no version=3.4.4
X-Google-Thread: 103376,469b2bba5f3a7bd
X-Google-NewGroupId: yes
X-Google-Attributes: gida07f3367d7,domainid0,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Received: by 10.205.119.5 with SMTP id fs5mr111606bkc.7.1334309544814;
        Fri, 13 Apr 2012 02:32:24 -0700 (PDT)
Path: 
 h15ni118346bkw.0!nntp.google.com!news1.google.com!goblin2!goblin.stu.neva.ru!aioe.org!.POSTED!not-for-mail
From: "Dmitry A. Kazakov" <mailbox@dmitry-kazakov.de>
Newsgroups: comp.lang.ada
Subject: Re: New AWS-based website
Date: Fri, 13 Apr 2012 11:31:47 +0200
Organization: cbb software GmbH
Message-ID: <totkhnfqlqnu$.179d1ovd10858.dlg@40tude.net>
References: 
 <76df311e-7bac-4326-bf21-b611c701ebeb@do4g2000vbb.googlegroups.com>
 <2802410.1954.1334169612465.JavaMail.geo-discussion-forums@pboo1>
 <56dc7a29-264f-4d76-b5e9-2610d18067f8@2g2000yqp.googlegroups.com>
 <21586328.6.1334304311295.JavaMail.geo-discussion-forums@ynhs12>
Reply-To: mailbox@dmitry-kazakov.de
NNTP-Posting-Host: FbOMkhMtVLVmu7IwBnt1tw.user.speranza.aioe.org
Mime-Version: 1.0
X-Complaints-To: abuse@aioe.org
User-Agent: 40tude_Dialog/2.0.15.1
X-Notice: Filtered by postfilter v. 0.8.2
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Date: 2012-04-13T11:31:47+02:00
List-Id: <comp.lang.ada>

On Fri, 13 Apr 2012 01:05:11 -0700 (PDT), Ludovic Brenta wrote:

> I too like PostgreSQL but my first choice of database would
> be SQLite because it avoids all the network and administrative
> overhead associated with a database server.  I would use
> PostgreSQL as a second choice if I really needed to run the
> database and the web server on different machines or if there
> were more than one client connecting to the same database.  Is
> that your case?

But SQLite and full-scale RDBMS have just different applications. SQLite is
for single-file, single-client cases. If the standard Ada library provided
an OS-agnostic transaction safe persistence, you would not need SQLite at
all. A true stand-alone RDBMS is an absolutely different beast.

> (Oh and in case you ask: you do not need ODBC to talk to an
> SQLite database).

Yes, that follows from the above. You need no abstraction layer for the
cases where SQLite comes in question.

ODBC is about communication to a possibly unknown server in a more or less
independent way, since SQL failed to deliver. Well, ODBC failed too, but on
a lesser scale.

-- 
Regards,
Dmitry A. Kazakov
http://www.dmitry-kazakov.de