Pg_ClickHouse: A Postgres extension for querying ClickHouse

This is nice because there are a lot of clickhouse fdw implementations and none of them are well maintained from what I can tell.

This is pretty good. It will allow us to use PostgREST as an API endpoint to query the ClickHouse database directly

Added to https://github.com/Olshansk/postgres_for_everything.

At this stage it may be possible to build one's entire application stack inside of postgres extensions.

I'm using Postgres as my base business database, and thinking now about linking it to either DuckDb/DuckLake or Clickhouse...

what would you recommend and why?

I understand part of the interest of pg_clickhouse is to be able to use "pre-existing Postgres queries" on an analytical database without having to change anything, so if I am building my database now and have no legacy, would pg_clickhouse make sense, or should I do analytics differently?

Also, would you have some kind of tutorial / sample setup of a typical business application in Postgres and kind of replication in clickhouse to make analytics queries? so I can see how Clickhouse would be typically used?

The name of the project is a reference to P. G. Wodehouse[0] for those unaware.

[0] https://www.gutenberg.org/ebooks/author/783