duckdb_fdw
subzero-starter-kit
Our great sponsors
duckdb_fdw | subzero-starter-kit | |
---|---|---|
4 | 3 | |
235 | 162 | |
- | - | |
7.3 | 0.0 | |
2 months ago | over 1 year ago | |
PLpgSQL | PLpgSQL | |
MIT License | 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.
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
subzero-starter-kit
- SubZero – GraphQL and REST API for your database
-
Thick Databases
What about cases where we need to bypass the automated API entirely? In such cases, we can use a proxy to redirect requests to a sidecar API, written in a language (or languages) of our choosing. This gives us more direct control in those cases where we need it. Many proxies will fill the task, such as OpenResty, which is used by subzero. When a request comes in, our proxy decides whether to forward it to our PostgREST API, or to our sidecar API. There are some downsides to this, as it won't appear in PostgREST's description of available endpoints, but it will work (I discuss an untested way to get it to appear in PostgREST's description).
- Auto generating API schema code?
What are some alternatives?
odbc2parquet - A command line tool to query an ODBC data source and write the result into a parquet file.
postgrest - REST API for any Postgres database
aquameta - Web development platform built entirely in PostgreSQL
postgrest-starter-kit - Starter Kit and tooling for authoring REST API backends with PostgREST
postgres_vectorization_test - Vectorized executor to speed up PostgreSQL
Keycloak - Open Source Identity and Access Management For Modern Applications and Services
parquet_fdw - Parquet foreign data wrapper for PostgreSQL
sqlx - general purpose extensions to golang's database/sql
parquet_s3_fdw - ParquetS3 Foreign Data Wrapper for PostgresSQL
auth0-java - Java client library for the Auth0 platform
cstore_fdw - Columnar storage extension for Postgres built as a foreign data wrapper. Check out https://github.com/citusdata/citus for a modernized columnar storage implementation built as a table access method.
lua-nginx-module - Embed the Power of Lua into NGINX HTTP servers