Ask HN: Best way to mirror a Postgres database to parquet?

7 points by hoerzu 2y ago ↗ HN

I know pg_analytics is doing something similar but it's append only

5 comments

[ 3.0 ms ] story [ 35.6 ms ] thread

e1g 2y ago ↗

DuckDB or ClickHouse can read from PG and output to parquet

hoerzu 2y ago ↗

sure but it will not mirror / no?

philippemnoel 2y ago ↗

ParadeDB founder here -- It is append-only for now, but we're working on upserts!

hoerzu 2y ago ↗

Very cool project! Is there a timeline on upserts?

philippemnoel 2y ago ↗

No timeline yet, but we know it's a high-priority feature and are working hard on it. Best way would be to join our Slack (link here: https://github.com/paradedb/paradedb/blob/dev/README.md) to follow along. It will be in the coming weeks/months, though.