Re: Frontend/Backend protocol 3.0

Jonathan Fuerth wrote:
> On Jun 6, 2005, at 5:39 PM, Joshua D. Drake wrote:
> >>> I don't think I'm the only person who has been suffering from a lack
> >>> of background knowledge in this regard.
> >> OK, who is working on improving ODBC at this point? Please give us a
> >> status report.
> >
> > My understanding is that there are two ODBC Projects.
> >
> > 1. ODBCng which is the GPL Command Prompt venture
>
> This seems clear enough--a from-scratch, GPL/commercial licensed ODBC
> driver which doesn't use libpq and only works with PostgreSQL backend
> >=8.0. Command Prompt will host this separately from the existing
> psqlodbc project.
>
> > 2. ODBC which is the original LGPL version and is being worked on by
> > Pervasive.
>
> I'm fuzzy on this one. Is pervasive just contributing incremental
> updates to the existing driver in the existing CVS repository, or will
> they post a lump-sum update to the driver one day, or will they fork
> the project and host their version on their own site?
>
> I can't find any evidence that they've publicly forked the project (or
> made any improvements to the odbc driver), but that doesn't mean they
> haven't been working on something in secret.
>
> Thanks for helping me discover these other projects. Now that we can
> get SQLSTATE from the backend, the driver works with our product (which
> is not open source).
>
> The next step will be to optimise SQL INSERT and UPDATE performance,
> and the most obvious place to start is with the new bind/execute part
> of the v3 backend protocol. I'm trying to decide if it's worth
> implementing on top of our current patched driver, or if I should just
> wait for Pervasive or Command Prompt to do it.

I am fuzzy on what Pervasive is doing and hope they will jump into this
discussion.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073