[mod_python] Python Data Objects&[email protected]

David Fraser davidf at sjsoft.com
Wed Feb 11 08:57:33 EST 2004


perry.tew at cibavision.novartis.com wrote:

>Hey.  What's the thread safety on this library?
>-Perry
>  
>
It's basically threadsafe assuming the underlying OLE DB drivers etc you 
use are threadsafe.
I think you would have problems sharing the same cursor between threads, 
but the same connection can be used on multiple threads to create 
different cursors

David

>
>
>
>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
>>>
>>>
>>>      
>>>
>
>
>_______________________________________________
>Mod_python mailing list
>Mod_python at modpython.org
>http://mailman.modpython.org/mailman/listinfo/mod_python
>
>
>
>_______________________________________________
>Mod_python mailing list
>Mod_python at modpython.org
>http://mailman.modpython.org/mailman/listinfo/mod_python
>
>  
>



More information about the Mod_python mailing list