|
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 > > >
|