Hi Massimo!
In the past, I have used SQLAlchemy to connect to Informix (using the
db2 driver), but it was for pure lazyness -- I had to write everything
by hand, and my application already was using SQLAlchemy, so ... But
that was back in 2007. Those codes are long dead and not in my possession.
Let's see if I can address those problems better for you:
*1. *"/Does anyone know if the Informix support is something will be
added?/": you can see all official dialects supported by SQLAlchemy in
here: http://docs.sqlalchemy.org/en/rel_0_9/dialects/index.html
All supported dialects in SQLAlchemy have something in common (IMHO):
SQL, obviously. Informix have support to SQL, of couse, but it also have
a lot of other tools, spatial support, JSON and so on; that I may find
hard see completely supported by SQLAlchemy. Of course, there are some
engines that looks quite familiar to these, PostgreSQL, -but- I think
it's support in SQLAlchemy is a completely different subject.
Are you planning to use SQLAlchemy ORM on top of Informix for common SQL
tasks? If so, you can adapt - or even contribute - to the ibm_db_sa
adapter :) Here's a good lecture:
http://techspot.zzzeek.org/2012/10/25/supporting-a-very-interesting-new-database/
-- but, of course, the SQLAlchemy source code is the best way to know
how dialects works under the hood.
If you're planning to use with the new JSON integration, boy I think you
should stick to the roots somewhere, away from SQLAlchemy and close to
Mongo's adapters (somewhere else I had bumped with MongoAlchemy
<http://www.mongoalchemy.org/>, that provides a quite similar API to
Mongo as SQLAlchemy offers to others RDBMs, but IMHO it looks like a
huge waste of code time since SQL and NoSQL databases have just one
thing in common: they store data somewhere).
*2. *"/Does this mean I can only use SQLAlchemy Core features and not
the ORM?/": I don't know about that anymore, since everything I write to
Informix (if and when applied) are not SQLAlchemy (or even Python)
related, at all.
If you provide more information about what you're trying to accomplish,
it may still be possible with SQLAlcheny, given some circumstances.
Best regards,
Richard.
On 05/19/2014 08:50 AM, Massimo Valle wrote:
I'm exploring SQLAlchemy features for a new project which must use an
IBM Informix database.
Found the ibm_db and ibm_db_sa modules to integrate with SQLAlchemy
and successfully connected to the database after some tries.
I found the ibm_db_sa module only supports DB2 and NOT Informix. At
least this is what was answered me on the project page.
Now I have a couple of newbie questions for the SQLAlchemy experts:
1. Does anyone know if the Informix support is something will be
added? (planned, considering). I don't know if this module is
developed from IBM or SQLAlchemy so, I'm not even sure to whom address
this question.
2. I see, I can connect to my Informix database, but can't use the
ibm_db_sa module. Does this mean I can only use SQLAlchemy Core
features and not the ORM? That would be sad since the ORM is exactly
what I planned to use.
Thanks for help,
Massimo Valle
--
You received this message because you are subscribed to the Google
Groups "sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to sqlalchemy+unsubscr...@googlegroups.com
<mailto:sqlalchemy+unsubscr...@googlegroups.com>.
To post to this group, send email to sqlalchemy@googlegroups.com
<mailto:sqlalchemy@googlegroups.com>.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
