I don’t know much about Python, but according to this [2] the standard interface is the Python DB API. How does SQLAlchemy fit with that?
Julian [2] https://wiki.python.org/moin/DatabaseInterfaces <https://wiki.python.org/moin/DatabaseInterfaces> > On Jun 15, 2017, at 9:38 AM, Josh Elser <[email protected]> wrote: > > I would be happy to help with development of an Avatica Python driver that > uses SQLAlchemy instead of Python's DB2.0 API. > > There was a WIP patch sent to Apache Phoenix which didn't appear to go > anywhere [1]. Beware that there are appear to be some sketchy licensing > issues going on. > > [1] https://pypi.python.org/pypi/sqlalchemy-phoenix/0.3.0 > > On 6/13/17 12:19 PM, Junxian Wu wrote: >> Hi, Dev community, >> Right now, our team are trying to connect Druid to Superset >> (https://github.com/airbnb/superset) and other database monitoring tools. I >> wonder that what will be the best way to do so. Superset is based on python >> and it uses a python SQL connection toolkit called SQLAlchemy, they provided >> some experimental ways to connect mySQL through JDBC and those probably >> could be potentially used to connect Calcite. Calcite can provide a standard >> JDBC connection but I am not sure how to expose that. Should I do it through >> Avatica or there exists a simpler way to do it just with Calcite. >> Thank you.
