Clickhouse: A good notice - Enterprise ClickHouse Database IDE

[jonatasfreitasv]

Hello Yandex friends,

after several tests on ClickHouse, I felt the power of this tool.

I would like to thank the wonderful work done by the Yandex team.

We are already using the company where I work, Zenvia, and is bringing us great solutions for data analysis.

However we are having some difficulties in making it available for "non-technical" users to do querys, monitor features and everything else. For the tools of interaction with ClickHouse are very bad and full of bug (like Tabix).

ClickHouse has to have a tool similar to that of MemSQL for example, I'm sure it will greatly increase the use of ClickHouse throughout the community.

Thinking about that, I decided to start a project to make it possible, it's right at the beginning, but I have good visions of how it should be.

This is the initial repository -> https://github.com/jonatasfreitasv/HouseDash
The name I'm still thinking, if you have suggestions hehe :).

My vision with some features -> https://github.com/jonatasfreitasv/HouseDash/projects

I want to do something really relevant, to be proud of Yandex and your team.

If anyone wants to contribute to the project, I will be very grateful ([email protected]).

I need UX / UI and React professionals.

If you can publish this work so that I can get more contributors, I would appreciate it.

Thank you again, and got o work hard!!!

[sundy-li]

Sounds great!

[jonatasfreitasv]

Last commits:

• Implement query post and ace editor
• Implement React Table
• Added basic layout with React Ant Design

[tannerlinsley]

I can be of assistance.

[jonatasfreitasv]

Wow! Thx a lot @tannerlinsley !

[jonatasfreitasv]

Last commits:

• Database, Tables, Columns spec in SideBar
• Split panels
• Database settings

[jonatasfreitasv]

Last comits:

• Refactor a lot of thinks in layout
• Added refresh data in SideBar
• Added ScrollBars in Table, SideBar and JSON Response
• Added Keyboar ShortCuts in Query
• Added Query header Buttons

[jonatasfreitasv]

Day 4 (2018-04-26)

• Added Split Panel horizontal on Query
• Refactor all design in SideBar Tree
• Fix bugs when query not have any data

Day 3 (2018-04-19)

• Refactor a lot of thinks in layout
• Added refresh data in SideBar
• Added ScrollBars in Table, SideBar and JSON Response
• Added Keyboar ShortCuts in Query
• Added Query header Buttons

Day 2 (2018-04-18)

• Database, Tables, Columns spec in SideBar
• Split panels
• Database settings

Day 1 (2018-04-17)

• Implement query post and ace editor
• Implement React Table
• Added basic layout with React Ant Design

[zhaodagang]

dear @jonatasfreitasv:

We are also doing this product, we hope to develop together.

[jonatasfreitasv]

Day 5 (2018-04-29)

• First alpha release (https://github.com/jonatasfreitasv/HouseOps/releases/tag/0.0.1-alpha.1)
• User and Pass on Database Configuration
• Launch Query in selected text
• Change prmary color to Yandex Yellow
• Remove a lot of unused files.

[jonatasfreitasv]

Version 1.0.0-beta is open!!!!

https://github.com/HouseOps/HouseOps

[meshpaul]

Wow great effort! One thing I would like to mention there are some Java based tools that are easily used all they need is ClickHouse JDBC driver. Ex Netbeans, Eclipse or DBVisualizer (not sure if it's open source) but I use it . Anyhow wanted to mention some here but for basic SQL queries and desenet grid to display data Netbeans will work

[sundy-li]

@meshpaul By the way, we are working on Java Native jdbc library,
see here

[perez1987]

Congratulations! I'm going to try it and test it.

[meshpaul]

@sundy-li anything wrong with this one https://github.com/yandex/clickhouse-jdbc. We use it and WOW what a difference 75% decrease on our GC during massive heavy loads when we switched from Oracle

[jonatasfreitasv]

Version 1.1.0-beta!!!

Waiting feedbacks!!!

[Epic Feature] Process List Screen

[Epic Feature] Server Settings section

[Epic Feature] Database Graph (alpha)

[Feature] Database Alias

[Feature] Abort query

[Feature] Select database for run query

[Feature] Copy to clipboard results in CSV format

[Feature] Copy to clipboard JSON Object

[UI/UX] Add color in buttons

[Improvement] In Database Tree, remove kb in table when is 0

[Improvement] Hidden menu when database is not configured and disable soon features buttons

[Improvement] Information about success query in second bar and disable success notification

[Refactor] Remove first call functions inside from constructor and put in componentWillMount function

[Dependencies Updates] Update Electron to 2.0.2 Version

[Dependencies Updates] Update all packages to last version

[perez1987]

Testing in development environment :-)

[jonatasfreitasv]

Version 0.3.0-beta!
https://github.com/HouseOps/HouseOps

Feature In Processes List, recording feature to capture all processes.
Feature In Processes List, added line graphic to show pending processes.
Feature Query history.

Improvement Put http:// or https:// before host message in Database Settings.

UI/UX Add icons in all buttons.
UI/UX Added animations in elements on show.
UX/UI EULA dialog cause undesired scroll.

BUG Error connection message in Database Tree when run count in bugged Distributed table.

Refactor A lot of refactors.

[blinkov]

HouseOps is listed on a 3rd party GUI page: https://clickhouse.yandex/docs/en/interfaces/third-party/gui/