Informix as supported database

[Former user]

It'd be great if SA'd support Informix database. InformixDB is mature DB API 2.0 implementation and it works great.

If there is no anything done in that direction I'd like to get involved in that. In fact, I've already started to work on sqlalchemy.database.informix using PostgreSQL implementation as a skeleton.

[Mike Bayer]

sounds great, let me know if you need any help. added an "informix" component to trac.

[Mike Bayer]

patch courtesy of [e-mail] attached. per our emails, it needs cleanup; the oracle and postgres features dont apply here, most of the unit test changes should not be patched either save for the "@unsupported('informix')" tests.

also need to add "informix" to the docs as a preliminary-ish supported database.

[Former user]

i cleanup all the test code and change it to fit the new SA's interface.

the code only tested at informix7 and aix4.3, so I have to block many stronger features test.i think in the informix upper version, these features will be supported good.

i will work at informix9 and linux, but time will last longer.

[Former user]

-- [e-mail]

[Mike Bayer]

notes on the patch:

• changed the default to () to None in base.py execute_text().
• oracle fix - OK
• unit tests - theres just too many changes here, such as adding an extra drop_all() to relationships.py line 252, and shortening the "item_policy_eff_date" column name, but then the actual test is unsupported by informix anyway. Also im not comfortable with the various "lazy=True" changes and id rather be able to mark an entire test class (or even module) as unsupported by informix. theres too many dozens of "unsupported('informix')" lines, and in fact the unit tests are only known to pass completely for sqlite, postgres and mysql. only a subset of tests pass for oracle/firebird/ms-sql, and many of these tests (mostly ORM tests) are not critical to be passable for every kind of database.
• informix patch - committed in changeset:2529. Terrific job and thanks for your efforts !

[Former user]

Carsten Haese here, maintainer of InformixDB. I just noticed this ticket, and I think it's great to see that SQLalchemy is getting Informix support. I'd like to express my thanks to Jun Zhang for doing all the heavy lifting.

If there's anything I can do to help, whether it's writing documentation, providing test coverage on more recent Informix versions, or making any changes to InformixDB that would make things easier for SQLalchemy's informix mapping, please let me know at chaese(at)users(dot)sourceforge(dot)net.

-Carsten