3 ms·
If you have some data in postgresql and want to query it with duckdb (really fast) you can try extracting the data to a parquet file; this file can then be quer
by spapas82 3y ago
If you have some data in postgresql and want to query it with duckdb (really fast) you can try extracting the data to a parquet file; this file can then be queried from duckdb with incredible speed. I've written a small program in python that reads from postgresql and exports to parquet for anybody that wanna try it https://github.com/spapas/pg-parquet-py#why https://github.com/spapas/pg-parquet-py#why
- chrisjc 3y agoThere's also the option to use the DuckDB PostgreSQL scanner https://duckdb.org/docs/archive/0.9.1/extensions/postgres_scanner https://duckdb.org/docs/archive/0.9.1/extensions/postgres_sc...