I dont have any special insight on this. It would obviously perform pretty poorly, but overall the API you'd want to target first is pep 249: https://www.python.org/dev/peps/pep-0249/ that does all the REST stuff, then SQLAlchemy dialect is documented at https://github.com/sqlalchemy/sqlalchemy/blob/master/README.dialects.rst, I was under the impression that ibm_db_sa https://pypi.org/project/ibm-db-sa/ supported informix but I'm not sure this is the case right now.
On Sun, Jul 14, 2019, at 9:10 PM, Nestor Diaz wrote: > Hi everybody. > > I have this situation: > 1. I need to extract data from an Informix Database. > 2. Informix is not a supported engine in SqlAlchemy. > 3. There is a python informix driver, in order for it to work you must > install the informix SDK, and is definitely a PITA. > 4. Informix now have a REST interface, you can even execute SQL sentences > throught the REST interface and have the results in JSON, no need to install > client libraries, good ! > https://www.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.json.doc/ids_json_sql_rest.htm > Since I can execute any SQL statement via REST , I suppose I can develop some > "driver" for informix using this REST interface, in the beginning the idea is > to execute any arbitrary SQL statement that implements the whole SqlAlchemy > functionality. > > For those who already know how to develop such drivers I would like do > receive some hints about where to start with that, or if there is some > documentation about where to start I will appreciate such information. > > Thanks. > > -- > Nestor > > > > > -- > SQLAlchemy - > The Python SQL Toolkit and Object Relational Mapper > > http://www.sqlalchemy.org/ > > To post example code, please provide an MCVE: Minimal, Complete, and > Verifiable Example. See http://stackoverflow.com/help/mcve for a full > description. > --- > 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 [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/sqlalchemy. > To view this discussion on the web visit > https://groups.google.com/d/msgid/sqlalchemy/d7e0d3cd-228e-480f-aaa2-2d7d5818e253%40googlegroups.com > > <https://groups.google.com/d/msgid/sqlalchemy/d7e0d3cd-228e-480f-aaa2-2d7d5818e253%40googlegroups.com?utm_medium=email&utm_source=footer>. > For more options, visit https://groups.google.com/d/optout. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/sqlalchemy. To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/2ff886af-df2c-4dee-a1a5-88ab8f83be44%40www.fastmail.com. For more options, visit https://groups.google.com/d/optout.
