From: John R Pierce <pierce@hogranch.com>
To: pgsql-general@postgresql.org
Subject: Re: [ODBC] ODBC constructs
Date: Tue, 21 May 2013 12:16:05 -0700
Message-ID: <519BC7F5.1010703@hogranch.com> (raw)
In-Reply-To: <CALSLE1MTNLFS_15Xw7L52fWs17VGqyLRTYewv2V4ssmw7AJqNw@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>
<519B14E7.3010806@vmware.com>
<CALSLE1MTNLFS_15Xw7L52fWs17VGqyLRTYewv2V4ssmw7AJqNw@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-general>
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
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: pierce@hogranch.com, pgsql-general@postgresql.org
Subject: Re: [ODBC] ODBC constructs
In-Reply-To: <519BC7F5.1010703@hogranch.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