Re: Updates via ODBC commands

On 14/1/06 13:57, "Ludek Finstrle" <luf(at)pzkagis(dot)cz> wrote:

>> They now got back to their original product, and were suprised to find
>> out that what used to work no longer does. I described the work done on
>> the ODBC driver as a "rewrite". Assuming they decide to move forward
>> with the support, there are three possible avenues for continuing:
>> 1. Fix the performance problem with 7.4
>> 2. Add updateable cursors to 8.01
>> 3. Switch the product to use OLE DB and add updateable rowsets there
>> (PgOleDb does not currently support updates either).
>>
>> I'm currently assuming that any of the above would have to actually be
>> done by Lingnu with their sponsorship, but feel free to pleasently
>> surprise me. I'm fairly sure that I'll manage to convince them that 1 is
>> not a good idea (unless someone here thinks that the new version
>> under-performs in relation to the direct socket version). I believe they
>> will go with 2, in which case we'll obviously release any work we do.
>
> I'm sorry I don't answer you directly. I hope Dave will answer you in
> relative short time.

Sorry, I'm short of time for psqlODBC right now so haven't been following
the list much the last week or so.

The libpq and previous versions of the driver do perform similarly - I
benchmarked them quite extensively when Anoop first ported the code.

Personally I'd like to see #2 happen, and even better, for them to sponsor
your time to do the work Shachar - we know you are experienced at writing
drivers, and I'm sure you could put your hand to psqlODBC fairly easily :-)

I'd rather not see #3 happen (from a psqlODBC contributor's point of view),
but obviously that doesn't apply to you!

Regards, Dave.