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@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073