Re: Qt Ada database support?

[Ludovic Brenta <ludovic@ludovic-brenta.org>]

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.