Re: [ODBC] ODBC constructs

From: Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
To: Dev Kumkar <devdas(dot)kumkar(at)gmail(dot)com>
Cc: Atri Sharma <atri(dot)jiit(at)gmail(dot)com>, "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: [ODBC] ODBC constructs
Date: 2013-05-21 06:32:07
Message-ID: 519B14E7.3010806@vmware.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general pgsql-odbc

On 21.05.2013 08:11, Dev Kumkar wrote:
> On Mon, May 20, 2013 at 9:12 PM, Atri Sharma<atri(dot)jiit(at)gmail(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Armand du Plessis 2013-05-21 08:37:24 Re: Transaction ID wrap limit is log entries
Previous Message Guy Rouillier 2013-05-21 06:17:25 Re: ODBC constructs

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Migowski 2013-05-21 07:55:01 Re: Cross compile custom data types for Linux and windows
Previous Message Guy Rouillier 2013-05-21 06:17:25 Re: ODBC constructs

Browse pgsql-odbc by date

  From Date Subject
Next Message ljwilson 2013-05-21 14:33:21 psqlODBC (32-bit) compiled with PostgreSQL 9.2 requires Microsoft Visual C++ 2010 Redistributable Package (x86)
Previous Message Guy Rouillier 2013-05-21 06:17:25 Re: ODBC constructs