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=-1.9 required=5.0 tests=BAYES_00 autolearn=ham
	autolearn_force=no version=3.4.4
X-Google-Thread: a07f3367d7,3ac0f9399164ca9f
X-Google-Attributes: gida07f3367d7,public,usenet
X-Google-NewGroupId: yes
X-Google-Language: ENGLISH,ASCII-7-bit
Path: 
 g2news2.google.com!postnews.google.com!y7g2000yqa.googlegroups.com!not-for-mail
From: Ludovic Brenta <ludovic@ludovic-brenta.org>
Newsgroups: comp.lang.ada
Subject: Re: Qt Ada database support?
Date: Tue, 9 Jun 2009 05:30:02 -0700 (PDT)
Organization: http://groups.google.com
Message-ID: <0b27299b-c0ba-4592-a312-7192da923522@y7g2000yqa.googlegroups.com>
References: <umy8hve4h.fsf@stephe-leake.org>
NNTP-Posting-Host: 153.98.68.197
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1244550602 29955 127.0.0.1 (9 Jun 2009 12:30:02
 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 9 Jun 2009 12:30:02 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: y7g2000yqa.googlegroups.com; posting-host=153.98.68.197;
	posting-account=pcLQNgkAAAD9TrXkhkIgiY6-MDtJjIlC
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
 rv:1.9.0.10)
	Gecko/2009042316 Firefox/3.0.10,gzip(gfe),gzip(gfe)
Xref: g2news2.google.com comp.lang.ada:6391
Date: 2009-06-09T05:30:02-07:00
List-Id: <comp.lang.ada>

Stephen Leake wrote on comp.lang.ada:
> I currently have a small database application, implemented using
> GtkAda and GNADE ODBC, using a MySQL backend.
>
> I'd like to switch to a direct connection to an SQLite3 database,
> mainly because the administration is much simpler. For example, I
> could not get an ODBC connection to a MySQL database installed, let
> alone working, on my Debian box (I currently have it working on
> Windows XP). The MySQL installation instructions are woefully out of
> date.
>
> The GNADE binding to SQLite3 is very minimal. I wouldn't mind very
> much improving it, but I'm investigating alternatives first.
>
> Does anyone know of an ODBC connector for SQLite3? Searching on
> Ask.com found:
[...]

SQLite is merely a shared library that you link into your program; it
runs as part of your process. There is no SQLite server and, as far as
I know, no need for an ODBC connection.

GNADE contains two bindings to SQLite: sqlite and sqlite3. The latter
is more complete but even sqlite seems sufficient to me because it
does not have or need the complexity of ODBC. It does lack the concept
of prepared statements, however; this is present in the sqlite3
binding.

Did you have some specific feature in mind?

--
Ludovic Brenta.