On Jun 29, 2011, at 6:43 AM, Luca Lesinigo wrote: > Hello there. I'd like to use SQLalchemy with an existing db2 database > (I can already access it with plain SQL using pyODBC from a python-2.6/ > win32 system). > > Googling around, I found http://code.google.com/p/ibm-db and it seems > to have an updated DB-API driver for python-2.6/win32, but the latest > SA adapter is for sqlalchemy-0.4. > > Is there any way to access DB2 from sqlalchemy-0.6 or -0.7? > If that helps, I'm gonna use it in read-only (ie, no INSERT, UPDATE, > DELETE queries will be issued nor would they be accepted by the db)
A project I'd like to take on at some point, or to get someone else to do it, would be to write a modernized SQLAlchemy 0.7 dialect for DB2, where we would use DB2's DBAPI, but not their SQLAlchemy dialect which is out of date and they appear to not be doing much with. I'd write a new dialect rather than porting/looking at the one IBM wrote just so there's no potential licensing issues. The new DB2 dialect would live with all the other dialects under the SQLAlchemy project itself. I understand DB2 has a free "express" edition so it would be a matter of getting that going and working out the dialect. Dialects aren't too hard to write so we do get them contributed, but for the moment we don't have a DB2 story for modern SQLAlchemy versions. > > thanks, Luca > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To post to this group, send email to sqlalchemy@googlegroups.com. > To unsubscribe from this group, send email to > sqlalchemy+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.