Postgres Pro
Downloads
Home   >   mailing lists

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

From John R Pierce
Subject Re: [ODBC] ODBC constructs
Date
Msg-id 519BC7F5.1010703@hogranch.com
Whole thread Raw
In response to Re: [ODBC] ODBC constructs  (Dev Kumkar <devdas.kumkar@gmail.com>)
Responses Re: [ODBC] ODBC constructs  (Dev Kumkar <devdas.kumkar@gmail.com>)
List pgsql-general
Tree view
On 5/21/2013 11:58 AM, Dev Kumkar wrote:
Thanks everyone for sharing comments, really useful ones. Yes the requirement is not connecting to other DBMS but only Postgres and libpq is the correct way so far from comments here. Regarding libpq performance wanted to discuss about connection polling like pgpool but I think a separate post of performance will make sense.


for pooling, check out pgbouncer.   IMHO its a better basic pooler than pg_pool. 

So, coming back to the original question actually I am exploring on both fronts here - libpq and psqlODBC.
Just one thought here, there is an existing ODBC business logic code which is talking to sybase database and now same code need to be ported to talk to postgres, then in this case will the use of psqlODBC quick way? Otherwise porting of ODBC business logic to libpq constructs needs to be done.


thats the perfect use case for ODBC.    you'll probably still need to rework some of your SQL if you did stuff thats Sybase specific, but thats a lot less hassle than rewriting all the API calls.


-- 
john r pierce                                      37N 122W
somewhere on the middle of the left coast

pgsql-general by date:

Previous
From: Dev Kumkar
Date:
Subject: Re: [ODBC] ODBC constructs
Next
From: Moshe Jacobson
Date:
Subject: Re: Strange locking problem