RE: Win ODBC drivers for Postgres

See below...

--
Peter Mount
Enterprise Support
Maidstone Borough Council
Any views stated are my own, and not those of Maidstone Borough Council

> -----Original Message-----
> From: Byron Nikolaidis [SMTP:byron(dot)nikolaidis(at)home(dot)com]
> Sent: Wednesday, June 07, 2000 10:31 PM
> To: Mihai Gheorghiu; pgsql-interfaces(at)postgresql(dot)org
> Subject: Re: [INTERFACES] Win ODBC drivers for Postgres
>
> Hey there partner,
>
> To quote the immortal Butthead: "uhhhh....................., ok."
>
> Seriously, I wonder how this "consultant" came up with this? Sounds
> awefully generalized. I think I could say that line about anything,
> including ODBC itself.
[Peter Mount] I can think of a few non-public domain items that are
even worse...

> Also, many of the compromises of the ODBC driver are based on shortcomings
> of the backend. Jeez, we still "simulate" a Prepared Statement because
> there isn't one in the backend. Is the backend ever gonna have
> this?AFAIK,
> the JDBC driver simulates the prepared statement also.
>
[Peter Mount] Yes, JDBC does simulate prepared statements, but as
soon as the backend supports it (which, some one correct me, may be possible
after a parser rewrite?) it will be changed over. This is one of the big
performance hits in JDBC at the moment.

> Some may remember the "declare/fetch" feature of the ODBC driver, that
> makes
> use of postgres cursors. This feature was added to help with the network
> bandwidth problem -- instead of getting the entire query result, it
> fetched
> it in chunks when required.
>
[Peter Mount] I want to add this capability to JDBC, especially the
JDBC2 driver, as it's ResultSet can implicitly handle cursors. I was
originally going to do it for 7.0.

> Yeah, so maybe connection pooling would be nice, but most things use one
> or
> two connections don't they? Do most processes keep asking odbc for a new
> connection?
[Peter Mount] I'm not sure about ODBC, but in JDBC a lot of people
use connection pools, especially with Servlets or CORBA applications.

> Byron
>
> ----- Original Message -----
> From: Mihai Gheorghiu <tanhq(at)bigplanet(dot)com>
> To: <pgsql-interfaces(at)postgresql(dot)org>
> Sent: Wednesday, June 07, 2000 10:36 AM
> Subject: [INTERFACES] Win ODBC drivers for Postgres
>
>
> > The following is a quote from a consultant's opinion on my intention to
> > migrate to Postgresql.
> > Quote:
> > [ODBC public domain drivers] are immature, inefficient and are network
> > bandwidth hogs. The public domain drivers don't support connection
> caching
> > which reuses an existing database connection for same queries to reduce
> the
> > query result time.
> > Unquote.
> > Please comment.
> >
> > Best regards,
> >
> > Mihai
> >
> > PS See also pgsql-general for opinion on Postgres :-)
> >