Add Support for ClickHouse
Open
enhancement
- Dominant language
- Python
- Stars
- 486
- Forks
- 8
- PR merge metrics
- No merged PRs in 30d
Description
[ClickHouse](https://clickhouse.com) seems to have a PostgreSQL compatible interface, but according to a customer report it is not compatible with Postico.
Judging by the error message, it sounds like ClickHouse doesn't support the "SHOW ALL" command that Postico executes after connecting to the server.
Might be worth it to just fall back to default settings if that query fails.
Contributor guide
No contributing guide indexed for this repository
Research direction
No files or tests are named. Start by locating the connection setup and the code that runs SHOW ALL, then reproduce the connection against ClickHouse. Done means Postico connects successfully and uses default settings when that query fails.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- clickhouse, postgresql, python
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Quiet
- Clarity
- Mostly clear
- Newbie friendliness
- 48/100