Hi Michael,
i am intrested in writing a dialect for DB2. Is there any howto which
covers what is needed to start. Do you think we should write an
extension, or should this dialect in sqlalchemy itself?
Thanks in advance
Christian
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.