upvote
In my (minor) experience Timescale works fine. The developer experience is good and it is very convenient to be able to JOIN against your hypertables. My only real complaints are operational (no logical replication, normal postgres update complaints), but man Clickhouse is really slick. I wrote some small reviews of the two in my submission history if you want a bit more detail.
reply
I would just run both and decomission the old one when a) all data is migrated, b) old data is no longer relevant and can be archived
reply
Worked on peerdb. If you're able to batch changes on your end & push to both postgres & clickhouse, do that. Only move to peerdb when you know you need cdc
reply
Just looked up PeerDB expecting a Db as per its name.

But it’s a ETl tool. Stupid naming

reply
I know I know. Some people have loved it as it captures what it does (peering dbs) and some haven't because of the exact reason you called out. So we get it! :)
reply