Xiangdong Huang created COMDEV-404:
--------------------------------------

             Summary: Integrating Apache IoTDB and Apache Superset
                 Key: COMDEV-404
                 URL: https://issues.apache.org/jira/browse/COMDEV-404
             Project: Community Development
          Issue Type: Task
          Components: GSoC/Mentoring ideas
            Reporter: Xiangdong Huang


Apache IoTDB [1] is an Open Source IoT database designed to meet the rigorous 
data, storage, and analytics requirements of large-scale Internet of Things 
(IoT) and Industrial Internet of Things (IIoT) applications.

Apache Superset [2] is fast, lightweight, intuitive, and loaded with options 
that make it easy for users of all skill sets to explore and visualize their 
data, from simple line charts to highly detailed geospatial charts.

We hope that Superset can be used as a data display and analysis tool of IoTDB, 
which will bring great convenience to analysts of the IoT and IIoT.

For a database engine to be supported in Superset, it requires having a Python 
compliant SQLAlchemy dialect [3] as well as a DBAPI driver [4] defined. The 
current Python client of IoTDB is packaged by Apache Thrift generated code and 
does not follow a certain interface specification. Therefore, the first thing 
you need to do is to implement a standard SQLAlchemy connector based on the 
current Python client (or some new interfaces defined and generated by Thrift).

Next, you need to explore how to integrate IoTDB and Superset and document the 
usage in a user-friendly way. The integration documentation for Apache Kylin 
and Superset is here [5] for your reference.

What knowledge you need to know:
- Basic database knowledge (SQL)
- Python

[1] https://iotdb.apache.org
[2] https://superset.apache.org/
[3] https://docs.sqlalchemy.org/en/13/dialects/
[4] https://www.python.org/dev/peps/pep-0249/
[5] http://kylin.apache.org/blog/2018/01/01/kylin-and-superset/



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@community.apache.org
For additional commands, e-mail: dev-h...@community.apache.org

Reply via email to