StarRocks / starrocks

The world's fastest open query engine for sub-second analytics both on and off the data lakehouse. With the flexibility to support nearly any scenario, StarRocks provides best-in-class performance for multi-dimensional analytics, real-time analytics, and ad-hoc queries. A Linux Foundation project.
https://starrocks.io
Apache License 2.0
8.95k stars 1.8k forks source link

Free SQL Analysis Client for StarRocks #51067

Open ryanhamilton opened 1 month ago

ryanhamilton commented 1 month ago

Hi, I'm the author of qStudio https://github.com/timeseries/qstudio a free SQL tool specialized for data analysis, that allows easy charting, excel export and pivots. I'm looking for a StarRocks expert to work together with to get qStudio working well with StarRocks.

Ideally we will produce a guide like this one but for starrocks: https://www.timestored.com/qstudio/database/clickhouse

I understand you are MySQL compatible so all I really need someone to do is:

  1. Try connecting using qStudio
  2. Try queries with most data types.
  3. Report any bugs or improvements.

I will then fix all the issues and bugs. The reason we can't do the testing ourself is that we cannot be experts and know every data type etc. that exists for every database. Hence why we need help.

Let me know if interested.

ryanhamilton commented 1 month ago

I have tested this and ensured that it queries and charts results. Instructions for querying starrocks using qStudio client: https://www.timestored.com/qstudio/database/starrocks-client

Please if possible give it a try and I will try to fix any issues you find. Thanks.

chaoyli commented 1 month ago

@ryanhamilton Thanks for your contribution. I'll test it.