omdb-postgresql
postgrest-starter-kit
omdb-postgresql | postgrest-starter-kit | |
---|---|---|
1 | 3 | |
39 | 710 | |
- | - | |
4.0 | 0.0 | |
about 2 months ago | about 3 years 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.
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:
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?
What are some alternatives?
blog - OpenSource,Database,Business,Minds. git clone --depth 1 https://github.com/digoal/blog
sqlx - general purpose extensions to golang's database/sql
aquameta - Web development platform built entirely in PostgreSQL
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!
zombodb - Making Postgres and Elasticsearch work together like it's 2023
seafowl - Analytical database for data-driven Web applications 🪶
pg_partman - Partition management extension for PostgreSQL
pocketbase - Open Source realtime backend in 1 file
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