Should I replace all db select query REST APIs with a single generic router ?

• postgrest

  103 22,512 9.8 Haskell

  REST API for any Postgres database

  

It's neither MySQL nor Go, but https://github.com/PostgREST/postgrest has figured out most of the patterns and API designs you could follow.

• pg_ivm

  21 834 6.3 C

  IVM (Incremental View Maintenance) implementation as a PostgreSQL extension

  

It makes sense to perform managed denormalization - use a materialized view or automatically refresh a table or foreign server (via FDW) using common triggers (like pg_ivm does). And it's fine to add a TTL to it and use as a read store... update on user login and make a partial index just for that. And that's how you could get CQRS...

• InfluxDB

  www.influxdata.com featured

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

• contour

  6 3,651 9.7 Go

  Contour is a Kubernetes ingress controller using Envoy proxy.

  

Practically, it makes more sense to adopt GRPC services and publish them using REST/GraphQL bridges/gateways, respective API Gateways (I prefer Contour). Those have some AAA requirements and limitations on their own, and shape the design for everything else, including observability and service delivery (i.e. blue green vs canary).

Suggest a related project