A poor man's API

• postgrest

  100 22,376 9.7 Haskell

  REST API for any Postgres database

  

FROM debian:bookworm-slim #1 ARG POSTGREST_VERSION=v10.1.1 #2 ARG POSTGREST_FILE=postgrest-$POSTGREST_VERSION-linux-static-x64.tar.xz #2 RUN mkdir postgrest WORKDIR postgrest ADD https://github.com/PostgREST/postgrest/releases/download/$POSTGREST_VERSION/$POSTGREST_FILE \ . #3 RUN apt-get update && \ apt-get install -y libpq-dev xz-utils && \ tar xvf $POSTGREST_FILE && \ rm $POSTGREST_FILE #4

• poor-man-api

  1 58 10.0 Shell
  

Note that you can find the whole source code on GitHub to follow along.

• 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.

  

• PostgreSQL

  411 14,788 10.0 C

  Mirror of the official PostgreSQL GIT repository. Note that this is just a *mirror* - we don't work with pull requests on github. To contribute, please see https://wiki.postgresql.org/wiki/Submitting_a_Patch

  

The main requirement of the solution is to use the PostgreSQL database. It's a well-established Open Source SQL database.

• apisix

  64 13,715 9.6 Lua

  The Cloud-Native API Gateway

  

Grafana configuration. Most of it comes from the configuration provided by APISIX.

• prometheus

  383 52,933 9.9 Go

  The Prometheus monitoring system and time series database.

  

A much-undervalued feature of any software system is monitoring. As soon as you deploy any component in production, you must monitor its health. Nowadays, many services are available to monitor. We will use Prometheus as it's Open Source, battle-proven, and widespread. To display the data, we will rely on Grafana for the same reasons. Let's add the components to the Docker Compose file:

• Grafana

  380 60,503 10.0 TypeScript

  The open and composable observability and data visualization platform. Visualize metrics, logs, and traces from multiple sources like Prometheus, Loki, Elasticsearch, InfluxDB, Postgres and many more.

  

A much-undervalued feature of any software system is monitoring. As soon as you deploy any component in production, you must monitor its health. Nowadays, many services are available to monitor. We will use Prometheus as it's Open Source, battle-proven, and widespread. To display the data, we will rely on Grafana for the same reasons. Let's add the components to the Docker Compose file:

• etcd

  61 46,470 9.9 Go

  Distributed reliable key-value store for the most critical data of a distributed system

  

APISIX stores its configuration in etcd

• SaaSHub

  www.saashub.com featured

  SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

  

• apisix-dashboard

  35 929 4.1 Go

  Dashboard for Apache APISIX

  

Instead of nginx, we would benefit from a full-fledged API Gateway: enters Apache APISIX. We shall add it to our Docker Compose:

Suggest a related project