5 ms·

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

7 points by hoerzu 3y ago

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

e1g 3y ago
DuckDB or ClickHouse can read from PG and output to parquet
- hoerzu 3y ago
  sure but it will not mirror / no?
philippemnoel 3y ago
ParadeDB founder here -- It is append-only for now, but we're working on upserts!
- hoerzu 3y ago
  Very cool project! Is there a timeline on upserts?
  - philippemnoel 3y 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 https://github.com/paradedb/paradedb/blob/dev/README.md) to follow along. It will be in the coming weeks/months, though.