From: "Dmitry A. Kazakov" <mailbox@dmitry-kazakov.de>
Subject: Re: libgnadeodbc
Date: Mon, 9 Apr 2018 13:55:52 +0200
Date: 2018-04-09T13:55:52+02:00 [thread overview]
Message-ID: <pafkc7$1pru$1@gioia.aioe.org> (raw)
In-Reply-To: paffag$1gif$1@gioia.aioe.org
On 09/04/2018 12:29, J-P. Rosen wrote:
> Le 09/04/2018 à 12:02, Dmitry A. Kazakov a écrit :
>> Why there should be any? There are hundreds of RDBMS. It is silly to
>> have bindings for each possible RDBMS client and have a mess of the
>> application if that must work with RDBMS from different vendors.
>>
>> This is why there is ODBC, to have a universal access to any RDBMS. Any
>> decent RDBMS provides ODBC drivers. E.g. MySQL connector comes with ODBC
>> drivers.
> ODBC just provides a protable way to submit queries.
+ binding parameters (SQL has huge problems with literal values)
+ walking the result set
> In my experience,
> the major factor of (lack of) portability if you change your DBMS is in
> the variations in the SQL language, not in the interface.
>
> So, you are bound to a given DBMS in any way.
Yes, but that is the language problem of SQL.
With ODBC one can at least query the capabilities of the DBMS. Surely
that is not what the Ada programmer expects: tell the semantics and
leave the language to implement it, but better than nothing.
--
Regards,
Dmitry A. Kazakov
http://www.dmitry-kazakov.de
next prev parent reply other threads:[~2018-04-09 11:55 UTC|newest]
Thread overview: 22+ messages / expand[flat|nested] mbox.gz Atom feed top
2017-06-14 12:30 libgnadeodbc lyttlec
2017-06-14 12:53 ` libgnadeodbc Dmitry A. Kazakov
2018-04-06 10:54 ` libgnadeodbc JA
2018-04-06 13:51 ` libgnadeodbc Bojan Bozovic
2018-04-06 14:58 ` libgnadeodbc Dmitry A. Kazakov
2018-04-09 9:26 ` libgnadeodbc jafparejo
2018-04-09 10:02 ` libgnadeodbc Dmitry A. Kazakov
2018-04-09 10:29 ` libgnadeodbc J-P. Rosen
2018-04-09 11:55 ` Dmitry A. Kazakov [this message]
2018-04-10 4:08 ` libgnadeodbc Stephen Leake
2018-04-10 7:39 ` libgnadeodbc Dmitry A. Kazakov
2018-04-10 21:54 ` libgnadeodbc Randy Brukardt
2018-04-10 22:28 ` libgnadeodbc Paul Rubin
2018-04-11 7:17 ` libgnadeodbc Dmitry A. Kazakov
2018-04-13 13:49 ` libgnadeodbc Marius Amado-Alves
2018-04-13 16:58 ` libgnadeodbc Dennis Lee Bieber
2018-04-10 22:46 ` libgnadeodbc Shark8
2018-04-11 7:23 ` libgnadeodbc Dmitry A. Kazakov
2018-04-11 12:46 ` libgnadeodbc Björn Lundin
2018-04-15 16:08 ` libgnadeodbc jrmarino
2018-04-15 16:25 ` libgnadeodbc Dmitry A. Kazakov
2018-04-12 1:56 ` libgnadeodbc Shark8
replies disabled
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox