Re: [ODBC] ODBC constructs

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: [ODBC] ODBC constructs
Дата
Msg-id 519BC7F5.1010703@hogranch.com
обсуждение исходный текст
Ответ на Re: [ODBC] ODBC constructs  (Dev Kumkar <devdas.kumkar@gmail.com>)
Ответы Re: [ODBC] ODBC constructs  (Dev Kumkar <devdas.kumkar@gmail.com>)
Список pgsql-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

В списке pgsql-general по дате отправления:

Предыдущее
От: Dev Kumkar
Дата:
Сообщение: Re: [ODBC] ODBC constructs
Следующее
От: Moshe Jacobson
Дата:
Сообщение: Re: Strange locking problem