Re: [ODBC] ODBC constructs - Mailing list pgsql-general

From Heikki Linnakangas
Subject Re: [ODBC] ODBC constructs
Date
Msg-id 519B14E7.3010806@vmware.com
Whole thread Raw
In response to Re: ODBC constructs  (Dev Kumkar <devdas.kumkar@gmail.com>)
Responses Re: [ODBC] ODBC constructs
List pgsql-general
On 21.05.2013 08:11, Dev Kumkar wrote:
> On Mon, May 20, 2013 at 9:12 PM, Atri Sharma<atri.jiit@gmail.com>  wrote:
>
>>
>> If you wish to work in C,then,I would suggest libpq.I would wait for more
>> replies on this,as I have little knowledge
>> about psqlODBC.
>>
>
> 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.

libpq is generally-speaking better than psqlodbc. The advantage of ODBC
is that if you have a suitable driver, you can connect to other DBMS' as
well, while libpq will only work with PostgreSQL. Unless you need such
portability, go with libpq.

- Heikki


pgsql-general by date:

Previous
From: Guy Rouillier
Date:
Subject: Re: ODBC constructs
Next
From: Daniel Migowski
Date:
Subject: Re: Cross compile custom data types for Linux and windows