[DB-SIG] questions for Python Database API Specification v2.0

[Sakesun Roykiattisak]

I see. Thanks for the perspective.

BTW. If I'd like to get to know more about odbc, what is your  
recommendation ?
I can't find many books on odbc, eventhough it should be the standard db  
connectivity.

Thanks.

> Sakesun Roykiattisak wrote:
>> Still wonder ..
>>
>>>> Given that the ODBC binary api is stable, I believe python-odbc can be
>>>> based on ctypes.
>>>> This way the re-compilation would no longer needed.
>>
>>
>>> You're underestimating the complexity of the ODBC API specification
>>> and the hundreds of implementations of it out there.
>>
>>
>> In general, I think Python is the best bet to fight with "complexity".
>
> True, but this doesn't always work for C APIs.
>
>> What is the technical aspect that ctypes cannot work around it ?
>
> They are related to memory management, dealing with pointers and
> low-level data conversion.
>
> Other than these technical issues, you also have to work around
> various ODBC driver/manager specific issues - only experience
> helps in solving these.
>