search

timeplus-io / proton

A streaming SQL engine, a fast and lightweight alternative to ksqlDB and Apache Flink, 🚀 powered by ClickHouse.
https://timeplus.com
Apache License 2.0
1.49k stars 62 forks source link

Allowing others to connect to Timeplus Proton via mysql client/JDBC #825

Open jovezhong opened 3 weeks ago

jovezhong commented 3 weeks ago

Use case

Although Timeplus team provides some drivers for different tools/languages, in some cases, we cannot add the Timeplus integration/driver to the 3rd party system. One example is AWS QuickSight.

While querying Timeplus historical data, we should allow the users to use MySQL client/lib to connect to Timeplus databases. Comparing to Postgresql, ClickHouse provides much better compatibility support on mySql protocol. We should leverage such code from ClickHouse community to improve the interoperability for Timeplus for other data engineering tools.

Describe the solution you'd like

Restore and enhance the mysql protocol support in Timeplus

Describe alternatives you've considered

Use Timeplus JDBC, ODBC or Go/python driver to talk to 8463, 8123, or 9000 port. But still there are some cases using MySQL port/protocol is preferred

Additional context

evanzhousy commented 3 weeks ago

"+1, our use case requires integration with various third-party data analysis platforms. While native support would be ideal, most third-party platforms support PostgreSQL/MySQL connection interfaces. I believe building a MySQL/PostgreSQL interface will sufficiently meet most use cases. Additionally, Node.js can utilize existing MySQL/PostgreSQL packages to facilitate connections to Timeplus."