Re: [ODBC] ODBC constructs

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