Hacker News Reader

difference to something like duckdb?

> > Alternatives

> DuckDB:

> - Designed for OLAP use cases. Easy to run with a single binary.

> - Limited support in the data ecosystem (notebooks, BI tools, etc.). Requires manual data syncing and schema mapping for best performance.

^ This!

Here is the link that briefly describes pros and cons of different alternatives for analytics https://github.com/BemiHQ/BemiDB#alternatives

How can you setup automatic replication from Postgresql to a duckdb instance?

The most common approach is to read Postgres data in DuckDB https://duckdb.org/docs/extensions/postgres.html