postgrest-starter-kit
omdb-postgresql
| postgrest-starter-kit | omdb-postgresql | |
|---|---|---|
| 3 | 1 | |
| 710 | 39 | |
| - | - | |
| 0.0 | 4.0 | |
| about 3 years ago | about 1 month ago | |
| PLpgSQL | PLpgSQL | |
| 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?
omdb-postgresql
-
Text Search example with the OMDB sample database
The https://github.com/credativ/omdb-postgresql project has a procedure to load into PostgreSQL. I can use the same to load into YugabyteDB, but this is not optimal. It is better to define the PRIMARY in the CREATE TABLE statement rather than ALTER TABLE later. What I did was load into PostgreSQL in order to export with pg_dump:
What are some alternatives?
sqlx - general purpose extensions to golang's database/sql
blog - OpenSource,Database,Business,Minds. git clone --depth 1 https://github.com/digoal/blog
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!
aquameta - Web development platform built entirely in PostgreSQL
seafowl - Analytical database for data-driven Web applications 🪶
zombodb - Making Postgres and Elasticsearch work together like it's 2023
pocketbase - Open Source realtime backend in 1 file
pg_partman - Partition management extension for PostgreSQL
subzero-starter-kit - Starter Kit and tooling for authoring GraphQL/REST API backends with subZero
annuaire-entreprises-sirene-api
showcase - REST api for your database (PostgreSQL/Sqlite/ClickHouse/MySQL).
postgresql-replicant - A streaming PostgreSQL logical replication client library for Haskell