firebird_fdw
bigquery_fdw
firebird_fdw | bigquery_fdw | |
---|---|---|
2 | 2 | |
36 | 89 | |
- | - | |
5.1 | 3.9 | |
6 days ago | 3 months ago | |
C | Python | |
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.
firebird_fdw
bigquery_fdw
-
Is using pandas considered terrible practice in ELT?
You can also take a look at this repo: https://github.com/gabfl/bigquery_fdw/blob/main/src/bqclient.py if not for the FDW, then at least to the python bit that reads data, though I'm not sure how well it goes through large datasets.
-
Good way to pull data from BQ to PostgreSQL?
Give this a try and report back, https://github.com/gabfl/bigquery_fdw
What are some alternatives?
tds_fdw - A PostgreSQL foreign data wrapper to connect to TDS databases (Sybase and Microsoft SQL Server)
CueObserve - Timeseries Anomaly detection and Root Cause Analysis on data in SQL data warehouses and databases
parquet_s3_fdw - ParquetS3 Foreign Data Wrapper for PostgresSQL
ethereum-etl - Python scripts for ETL (extract, transform and load) jobs for Ethereum blocks, transactions, ERC20 / ERC721 tokens, transfers, receipts, logs, contracts, internal transactions. Data is available in Google BigQuery https://goo.gl/oY5BCQ
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.
dopg_cli - ππ³π A python command line interface for DigitalOcean postgres clusters (5+ integrations).
pg_auto_failover - Postgres extension and service for automated failover and high-availability
Redash - Make Your Company Data Driven. Connect to any data source, easily visualize, dashboard and share your data.
orioledb - OrioleDB β building a modern cloud-native storage engine (... and solving some PostgreSQL wicked problems) Β πΊπ¦
pgcli - Postgres CLI with autocompletion and syntax highlighting