Implementing this in as technically simple a manner as is possible can be done using postgREST, on top of postgres and nginx.

1. OpenAPI: https://docs.postgrest.org/en/v12/references/api/openapi.html
2. HTTP OPTIONS: https://docs.postgrest.org/en/v12/references/api/options.html

#postgres #postgREST #HTTP #REST #OpenAPI

Today's article is about PostgREST, a tool to expose Postgres over HTTP. I discuss the role for such tools and explain some integration patterns based on different use-cases.

https://dicioccio.fr/role-of-postgrest.html

#PostgreSQL
#postgREST
#haskell

Currently, I have a #NodeRED data pipeline pulling weather metrics from #OpenWeather every hour, a table in #PostgreSQL to store the JSON payloads, a View to query the historical data, #PostgREST to provide an HTTP REST API to read and write to the tables and views.

https://openweathermap.org/
https://nodered.org/
https://docs.postgrest.org/en/v12/

It's been so many months in the making but I've finally reached a point at which I'm ok to say I've upgraded #postgrest -table, https://dicioccio.fr/postgrest-table.html . If you do not know, PostgREST is a way to provide a #REST API on top of #PostgreSQL with little effort. I think it's always good in read-only as (a) an addition to business-code-carrying APIs (e.g., provide a 'data' api to your users easily) (b) local debugging/troubleshooting. With my tool you also get low-effort dashboards for free.

Trying out #postgrest with #csharp and the #supabase client. This might be a nice "quick and easy" way to spin up demo APIs for workshops or tutorials around #aspnetcore.

All runs locally off of #postgres #database. Pretty neat stuff for #dotnet devs.

📢 New blog post: Discover how PostgREST can simplify your workflow by instantly transforming your database into an API.

PostgREST allows you to focus on the frontend since building REST APIs becomes a solved problem.

Check out our latest article to learn more about this game-changer: 👇
https://marmelab.com/blog/2024/11/04/postgrest-revolutionizing-web-development-with-instant-apis.html

#PostgREST #API #database #js #nodejs #reactadmin #Supabase

Today, I wrote on how to combine #PostgreSQL , #PostgREST and #ApacheAPISIX to expose a developer-friendly #RESTAPI.

https://blog.frankel.ch/advanced-url-rewrite-apisix/

Now with the PostgREST deep dive completed, you can find it (and hopefully share it) as single guide

https://notso.boringsql.com/guides/postgrest-apis-made-easy/

#postgresql #postgrest #boringSQL

I always enjoy seeing #Postgrest on #HN! https://postgrest.org/en/stable/how-tos/providing-html-content-using-htmx.html

Postgrest is of course written in #Haskell. But what I didn't know was that #Supabase is based on Postgrest, and they employ the lead developer of postgrest to work on it fulltime, which means Supabase is also based on Haskell!

#FunctionalProgramming everywhere!

When #postgrest complains about columns not existing, this might be the cause https://managing.blue/2023/10/31/postgrest-column-of-relation-does-not-exist/

@Jdreben I'm liking #Svelte... now I just need to get working on one of my backburner projects which will use it, along with #PostgREST ... reckon they're a potent combination.

Creating a full-fledged #API requires resources, both time and money. In this post, I show how how you can create a #CRUD API on top of your #database writing a single line of code https://blog.frankel.ch/poor-man-api/

#PostgreSQL #postgrEST #nocode #MVP

What's the fastest way to make a #CRUD app? #Selfhost is fine

I currently have this :

- DB (#postgres)
- #Django (the Admin part)

Tried #Baserow, #NocoDB but doesn't look ready yet for use.

- #PostgREST for the backend
- Some frontend framework from https://2021.stateofjs.com/en-US/libraries/front-end-frameworks (#Svelte, #Solid maybe)

#PostgREST serves #PostgreSQL databases as RESTful APIs.

PostgREST takes in a regular PostgreSQL database and serves it through a #REST web API that can be given data using #JSON. Authentication is done via JSON web tokens (#JWT) that extend the existing database authorization. PostgREST is very fast, supporting thousands of requests per second on a modest server.

Website 🔗️: https://postgrest.org/

#free #opensource #foss #fossmendations #sysadmin #webdev

[Fr] Rassemblement mensuel de la team #Netwo, ce mois-ci c’est à Nantes ! #rust #postgrest #fullremote #mobprogramming #XP on recrute ! https://t.co/3jMEazWuBh https://t.co/syWezHMjTt

[Fr] Netwo recrute et recherche des devs full-stack expérimentés pour un projet innovant dans le domaine des télécoms. 🌏 #FullRemote 🧠 #MobProgramming 🔥 #GKE #Kubernetes 🥰 #Rust 🐘 #PostgreSQL ⚡️ #PostgREST

https://t.co/cDLkaIf0MX

Voilà qui est intéressant :
#PostgREST : un serveur #Web autonome qui transforme une base de données #PostgreSQL
Directement en une API #RESTful

https://postgresql.developpez.com/actu/283284/PostgREST-un-serveur-Web-autonome-qui-transforme-une-base-de-donnees-PostgreSQL-directement-en-une-API-RESTful/

Je découvre, apparemment, il y a même une couche de sécurité...