Hi, anyone found a way to connect a prefect self-hosted to a clickhouse server instead of postgresql ?

hi @Eliot Courtel - the prefect server works with postgres or sqlite, Clickhouse is a different type of database and you wouldn't readily be able to use it as the prefect db

Hi @Nate - As clickhouse support postgresql interface, I guessed it would be feasible https://clickhouse.com/docs/en/interfaces/postgresql

hmm i'm not familiar with that compat interface, but I'd be skeptical that "supports the PostgreSQL wire protocol" equates to "supporting all postgres features prefect leverages"

tried the blocking point was that prefect onlly support postgresql+asyncpg the async par isn't supported by clickhouse but i was wondering if their was a workaround or if this was not doable "by design"

hmm yes at this time these are what we support