postgrest-starter-kit
subzero-starter-kit
postgrest-starter-kit | subzero-starter-kit | |
---|---|---|
3 | 3 | |
710 | 162 | |
- | - | |
0.0 | 0.0 | |
about 3 years 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.
postgrest-starter-kit
- Starter Kit and tooling for authoring REST API back ends for PostgREST
-
PostgREST – Serve a RESTful API from Any Postgres Database
I think the recommended way to use Postgrest is to put a layer of views and optionally stored functions on top of your schema to decouple it from your API. Take a look at this Postgrest starter kit[1] which uses a separate API schema for this purpose.
[1] https://github.com/subzerocloud/postgrest-starter-kit
- Auto generating API schema code?
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?
sqlx - general purpose extensions to golang's database/sql
postgrest - REST API for any Postgres database
graphile-engine - Monorepo home of graphile-build, graphile-build-pg, graphile-utils, postgraphile-core and graphql-parse-resolve-info. Build a high-performance easily-extensible GraphQL schema by combining plugins!
duckdb_fdw - DuckDB Foreign Data Wrapper for PostgreSQL
seafowl - Analytical database for data-driven Web applications 🪶
Keycloak - Open Source Identity and Access Management For Modern Applications and Services
pocketbase - Open Source realtime backend in 1 file
annuaire-entreprises-sirene-api
auth0-java - Java client library for the Auth0 platform
showcase - REST api for your database (PostgreSQL/Sqlite/ClickHouse/MySQL).
lua-nginx-module - Embed the Power of Lua into NGINX HTTP servers