Hacker GitHub

← All repos

alitrack/duckdb_fdw

View on GitHub ↗ ★ 416 C

DuckDB Foreign Data Wrapper for PostgreSQL

9 mentions on Hacker News by 6 people: 1 story, 8 comments · first 2021-02-20 · latest 2024-06-08

Mentions per year 9 mentions · busiest year 2022 (5)
20082026
AllStoriesComments NewestTopOldest
  1. Have you seen duckdb_fdw ( https://github.com/alitrack/duckdb_fdw )? IIRC it's built based on sqlite_fdw, but points the outbound queries to DuckDB instead of SQLite, and it does handle running aggregations inside of DuckDB. Could be…
    comment by mildbyte · 2024-06-08 · in Show HN: Pg_analytica – Speed up queries by exporting tables to columnar format
  2. …There's a 3rd party duckdb_fdw plugin for postgres that allows querying DuckDB from Postgres: https://github.com/alitrack/duckdb_fdw
    comment by nlnn · 2022-09-30 · in Querying Postgres Tables Directly from DuckDB
  3. You can use the DuckDB FDW (linked in the blog post) for this! https://github.com/alitrack/duckdb_fdw
    comment by 1egg0myegg0 · 2022-09-30 · in Querying Postgres Tables Directly from DuckDB
  4. …there is a Postgres FDW that can read from DuckDB! https://github.com/duckdblabs/postgresscanner https://github.com/alitrack/duckdb_fdw
    comment by 1egg0myegg0 · 2022-05-13 · in Friendlier SQL with DuckDB
  5. …graph.com/blog/postgresql-fdw-aggregation-p... [4] https://www.splitgraph.com/trase/supply-chains [5] https://github.com/alitrack/duckdb_fdw [6] https://swarm64.com/post/scaling-elastic-postgres-cluster/
    comment by mildbyte · 2022-05-05 · in Postgres and Parquet in the data lake
  6. …performance gains to be had using this setup. I won't take that for granted until it's tested. [1] https://github.com/alitrack/duckdb_fdw
    comment by iknownothow · 2022-05-05 · in Postgres and Parquet in the data lake
  7. …read from your parquet files and do faster transformations before you pull your data into Postgres! https://github.com/alitrack/duckdb_fdw
    comment by 1egg0myegg0 · 2021-12-03 · in DuckDB quacks Arrow: A zero-copy data integration between Arrow and DuckDB
  8. Here is a DuckDB FDW for Postgres! I have not used it, but it sounds like what you need! https://github.com/alitrack/duckdb_fdw
    comment by legg0myegg0 · 2021-06-25 · in Querying Parquet with Precision Using DuckDB