clidey / whodb

A lightweight next-gen data explorer - Postgres, MySQL, SQLite, MongoDB, Redis, MariaDB & Elastic Search with Chat interface
https://whodb.clidey.com
GNU General Public License v3.0
1.9k stars 56 forks source link

add ClickHouse support #211

Open modelorona opened 4 weeks ago

modelorona commented 4 weeks ago

hey! I managed to get some code in to support ClickHouse. Never used it before but figured it was a good learning opportunity.

I've tested it with the sample db here: https://clickhouse.com/docs/en/getting-started/example-datasets/nyc-taxi and so far it's working fine.

You'll probably have more to test it with :)

hkdeman commented 4 weeks ago

This is great! Checking this out :)

modelorona commented 6 days ago

table is visible image

data is visible image

changing passenger count to 102 image

deleted first two rows image

added row image

modelorona commented 6 days ago

will check these merged changes locally

modelorona commented 6 days ago

worked fine on my machine :))

modelorona commented 6 days ago

also this does not have the chat capability, I wasn't able to get around to it. could be for someone else to pick up :))