parquet_s3_fdw
duckdb_fdw
parquet_s3_fdw | duckdb_fdw | |
---|---|---|
1 | 4 | |
165 | 241 | |
6.7% | - | |
2.3 | 7.3 | |
about 1 month ago | 2 months ago | |
PLpgSQL | PLpgSQL | |
GNU General Public License v3.0 or later | MIT License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
parquet_s3_fdw
duckdb_fdw
- Querying Postgres Tables Directly from DuckDB
- Postgres and Parquet in the Data Lke
-
DuckDB quacks Arrow: A zero-copy data integration between Arrow and DuckDB
I should also add that there is a duckdb fdw, so you could have DuckDB read from your parquet files and do faster transformations before you pull your data into Postgres!
https://github.com/alitrack/duckdb_fdw
- DuckDB Postgres Foreign Data Wrapper
What are some alternatives?
pgddl - DDL eXtractor functions for PostgreSQL (ddlx)
subzero-starter-kit - Starter Kit and tooling for authoring GraphQL/REST API backends with subZero
firebird_fdw - A PostgreSQL foreign data wrapper (FDW) for Firebird - latest version 1.3.1 (2023-06-22)
odbc2parquet - A command line tool to query an ODBC data source and write the result into a parquet file.
postgres-aws-s3 - aws_s3 postgres extension to import/export data from/to s3 (compatible with aws_s3 extension on AWS RDS)
aquameta - Web development platform built entirely in PostgreSQL
pgrocks-fdw - Bring RocksDB to PostgreSQL as an extension. It is the first foreign data wrapper (FDW) that introduces LSM-tree into PostgreSQL. The underneath storage engine can be RocksDB. The FDW also serves for VidarDB engine, a versatile storage engine for various workloads. See the link for more info about VidarDB engine.
postgres_vectorization_test - Vectorized executor to speed up PostgreSQL