Skip site navigation (1) Skip section navigation (2)

Re: ODBC Rewrite

From: markw(at)mohawksoft(dot)com
To: "Stephen Frost" <sfrost(at)snowman(dot)net>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: ODBC Rewrite
Date: 2004-12-07 14:35:34
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
> * markw(at)mohawksoft(dot)com (markw(at)mohawksoft(dot)com) wrote:
>> Looking at both ODBC and libpq and I think that the difference is that
>> libpq aims to make PostgreSQL interfacing easy, while ODBC strives to be
>> a
>> comprehensive SQL interface. 99% of what will be done with the ODBC
>> interface will be simple SQLAllocStmt, SQLPrepare, and SQLExecute.
> Saying what 99% of what the ODBC driver does isn't terribly useful-
> What's that 1% that libpq can't do?  Having looked at the code, can you
> give us an idea on that?
> 	Stephen

Off the top of my head, binding data to the SQL statement, reusing
statements, stuff like that.

The ODBC API isn't designed to talk to any one database, so there are no
short cuts. Unfortunately, applications based on ODBC assume there are no
short cuts, and rely on that behavior.

In response to


pgsql-odbc by date

Next:From: markwDate: 2004-12-07 14:55:23
Subject: Re: ODBC Rewrite
Previous:From: Stephen FrostDate: 2004-12-07 14:16:38
Subject: Re: ODBC Rewrite

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group