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

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?

Show 4 replies

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

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. Show 1 reply

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

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

Show 4 replies