[mod_python] Python Data Objects&[email protected]

David Fraser davidf at sjsoft.com
Tue Feb 10 10:02:32 EST 2004


Hi

The basic difference is that this code is just a Python wrapper around
ADO, where as pyado.sourceforge.net as a Python DB-API 2.0 compliant
driver for any database using PyADO.
So we don't have to have multiple versions of the driver to support
different databases. This has been used successfully with Access and
Oracle and SQL server.
Also the code will work for any Python system that has been set up to
use the DB-API interface. So it is more natural to the Python way of
doing things.
You may find that your speed problems require using some of the Python
win32 extensions to statically link the types:
run
python makepy.py "Microsoft ActiveX Data Objects 2.5 Library"
(but substitute the right version number)

David

Khurram wrote:

>Hi,
>
>Thats the interface to microsofts ActiveX Database Objects. adodb was first
>developed for php and it has drivers for almost any database. PHP version has
>also been developed in native code and is 80% faster. It works on unix,linux,
>windows etc. Similar is the python version, but it has support for only 4-5
>databases unlike the php-version. Please see examples on the adodb site for
>more help. If you use adodb you code can support many databases.
>
>Khurram Ijaz,
>Renaissance Software.
>http://www.renai-soft.com
>
>Quoting David Fraser <davidf at sjsoft.com>:
>
>  
>
>>Khurram wrote:
>>
>>    
>>
>>>Hi,
>>>
>>>Please check http://php.weblogs.com/adodb_python#download for python ado_db.
>>>      
>>>
>>Its
>>    
>>
>>>supports transactions. You can also use transactions by native db calls
>>>      
>>>
>>such
>>    
>>
>>>BEGIN TRANSACTION etc.
>>>
>>>Khurram Ijaz,
>>>http://www.renai-soft.com
>>>
>>> 
>>>
>>>      
>>>
>>Interesting. We also have a Python DB-API driver for ADO, at 
>>pyado.sourceforge.net
>>I wonder what the similarities/differences are
>>
>>David
>>    
>>




More information about the Mod_python mailing list