|over 1 year ago||3 days ago|
|GNU Affero General Public License v3.0 only||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.
We haven't tracked posts mentioning pg-harness-server yet.
Tracking mentions began in Dec 2020.
A poor man's API
9 projects | dev.to | 23 Nov 2022
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 #49 projects | dev.to | 23 Nov 2022
[Q] Which backend for elm?
2 projects | reddit.com/r/elm | 13 Oct 2022
You mentioned Postgres however. If you’d like to just set up a simple REST-type backend API from a Postgres db, you could use https://github.com/PostgREST/postgrest. Maybe a CMS like Strapi or Contentful could suit your needs?
Hyperlambda HTTP Interceptors
2 projects | dev.to | 7 Oct 2022
Other use cases might be adding business logic to an HTTP endpoint you cannot add business logic to, such as for instance a GraphQL or PostgREST endpoints, such as those given to you by Hasura or Supabase. Logically this becomes the HTTP and Hyperlambda equivalent of OOP “polymorphism”, since it allows you to take some static thing, and modify how it behaves by “overriding” your original HTTP method. In the video below I am showing you how such interceptors works.
A comparison of Supabase, Hasura and Aista
6 projects | dev.to | 5 Oct 2022
In only 2 years Supabase has dwarfed Hasura. In its existence it has achieved 39.400 stargazers at GitHub. Supabase is built on an entirely different technology. However, Supabase seems to have GraphQL initiatives in the making, and might deliver GraphQL later since it’s currently a BETA product they deliver. However, their primary product today is based upon PostgREST. PostgREST is a thin layer similar to OData that sits on top of your web server allowing you to transmit basic queries that are executed towards your database. It suffers from the same “business logic injection attack” problems as GraphQL, and simply moves the burden of implementing business logic to the client, solving few problems really.
Nocodb: Turns Any MySQL, Postgres, SQLite into a Spreadsheet with REST APIs
6 projects | news.ycombinator.com | 4 Oct 2022
Similarly for Postgres, but without the spreadsheet part: https://github.com/PostgREST/postgrest
What is your preferred low-code framework for building REST API?
5 projects | reddit.com/r/selfhosted | 26 Sep 2022
depends, but I'd consider postgREST
Announcing pGenie: Generate typesafe Haskell from plain SQL for Postgres
5 projects | reddit.com/r/haskell | 24 Aug 2022
It must be mentioned that some applications do truly need dynamic statements. Typically such applications control the structure of the DB and change it dynamically too. One example is PostgREST. Most of applications deal with a statically structured database though and hence don't need dynamic statements.
A rest library
2 projects | reddit.com/r/haskell | 12 Aug 2022
Perhaps you'll find this project interesting https://github.com/PostgREST/postgrest
Querying SQL from React without a backend (bear with me here)
5 projects | reddit.com/r/reactjs | 27 Jun 2022
PostgREST is what you are looking for. If you don't want to set it up yourself, supabase is a basically a hosted version of PostgREST (and more, but the rest is likely irrelevant for you).
What are some alternatives?
Hasura - Blazing fast, instant realtime GraphQL APIs on your DB with fine grained access control, also trigger webhooks on database events.
supabase - The open source Firebase alternative. Follow to stay updated about our public Beta.
postgres-websockets - PostgreSQL + Websockets
TimescaleDB - An open-source time-series SQL database optimized for fast ingest and complex queries. Packaged as a PostgreSQL extension.
Appwrite - Secure Backend Server for Web, Mobile & Flutter Developers 🚀 AKA the 100% open-source Firebase alternative.
supabase-graphql-example - A HackerNews-like clone built with Supabase and pg_graphql
swagger2 - Swagger 2.0 data model.
pg-transact - Another postgresql-simple transaction monad
gotrue - An SWT based API for managing users and issuing SWT tokens
appsmith - Low code project to build admin panels, internal tools, and dashboards. Integrates with 15+ databases and any API.
json - Haskell JSON library