bigquery_fdw
dopg_cli
bigquery_fdw | dopg_cli | |
---|---|---|
2 | 2 | |
89 | 12 | |
- | - | |
3.9 | 10.0 | |
3 months ago | over 1 year ago | |
Python | Python | |
MIT License | Apache License 2.0 |
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.
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
dopg_cli
What are some alternatives?
CueObserve - Timeseries Anomaly detection and Root Cause Analysis on data in SQL data warehouses and databases
pg-counter-metrics - PG Counter Metrics ( PGCM ) is a tool for publishing PostgreSQL performance data to CloudWatch. By publishing to CloudWatch, dashboards and alarming can be used on the collected data.
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
FastAPIQuickCRUD - Generate CRUD methods in FastApi from an SQLAlchemy schema
firebird_fdw - A PostgreSQL foreign data wrapper (FDW) for Firebird - latest version 1.3.1 (2023-06-22)
pgadmin4 - pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.
Redash - Make Your Company Data Driven. Connect to any data source, easily visualize, dashboard and share your data.
sqlalchemy-declarative-extensions - Library to declare additional kinds of objects not natively supported by SqlAlchemy/Alembic.
pgcli - Postgres CLI with autocompletion and syntax highlighting
SciTS - A tool to benchmark Time-series databases
dbmate - :rocket: A lightweight, framework-agnostic database migration tool.