Re: [ODBC] ODBC constructs

John R Pierce <pierce@xxxxxxxxxxxx> · Tue, 21 May 2013 12:16:05 -0700



    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