From: Guy Rouillier <guy.rouillier@gmail.com>
To: pgsql-general@postgresql.org
Subject: Re: ODBC constructs
Date: Tue, 21 May 2013 02:17:25 -0400
Message-ID: <519B1175.1060105@gmail.com> (raw)
In-Reply-To: <CALSLE1Nd6qCcywLqm7fCWF3FHP_iGDxCzHspEYf0f88QiQ+d_A@mail.gmail.com>
References: <CALSLE1MARsmPHrRi2jtYDrZz80JQnx8kMjaAh5UGHMNUcoMh3g@mail.gmail.com>
<CALSLE1N=E5XmNHn6AS=7OXMGmC379+vvuBH1Vv5Sin4fPJog+A@mail.gmail.com>
<CALSLE1NfessvrQvwGCy_LBaz4pkaeLAJOwFqmYPgH-cF5wOzRw@mail.gmail.com>
<AD6CD285-763A-46AB-9825-31BF208AAFA4@gmail.com>
<CALSLE1Nd6qCcywLqm7fCWF3FHP_iGDxCzHspEYf0f88QiQ+d_A@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-general>
On 5/21/2013 1:11 AM, Dev Kumkar wrote:
> Thanks for the comments. Yes objective is to work in C and found libpq
> useful but am not sure about psqlODBC.
> It would be really great to get comments from community here regarding
> comparison between both of them and also performance perspective. Based
> on my reading so far libpq is good from performance perspective.
One advantage of an abstraction layer is that it allows you to switch
the underlying DBMS with few if any changes to your code. ODBC is just
one of many available abstraction layers. So, one thing to consider is
if your application is intended to be at all generic, or if it is
specifically targeted to PostgreSQL. If the former, then you should
consider an abstraction layer; if not, then libpq is fine.
Another determinant for many people is what they already know. If I'm
doing a quick, one-time app and I know ODBC but I don't know libpq, I
might choose to just stick with what I know and use ODBC.
So, really, the first decision you should make is how general you want
your app to be, and how long you expect to use it. Other decisions flow
from there.
--
Guy Rouillier
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: guy.rouillier@gmail.com, pgsql-general@postgresql.org
Subject: Re: ODBC constructs
In-Reply-To: <519B1175.1060105@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox