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
PostgREST automatically serves a full OpenAPI description on the root path. This provides a list of all endpoints (tables, foreign tables, views, functions), along with supported HTTP verbs and example payloads. For extra customization, the OpenAPI output contains a “description” field for every ...
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.
PostgREST is a relatively widely adopted solution for exposing a PostgreSQL database via an HTTP interface. We'll explore the benefits of considering PostgREST for your development and production environments.
Postgrest-Table is a powerful, browser-based exploration and dashboard tool that simplifies data analysis and visualization. By eliminating server-side dependencies and minimizing setup requirements, it's ideal for development, troubleshooting, and creating custom dashboards. With its auto-refresh feature, AJAX capabilities, customizable knobs, and graphing capabilities, Postgrest-Table augments the usefulness of your Postgres database without taking much space in your life.
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
Today, I wrote on how to combine #PostgreSQL , #PostgREST and #ApacheAPISIX to expose a developer-friendly #RESTAPI.
I spoke at Swiss PgDay in Switzerland in late June. The talk was about how to create a no-code API with the famous PostgreSQL database, the related PostgREST, and Apache APISIX, of course. I already wrote about the idea in a previous post. However, I wanted to improve it, if only slightly. PostgREST offers a powerful SELECT mechanism. To list all entities with a column equal to a value, you need the following command: curl /products?id=eq.1 id is the columneq.1 corresponds to the WHERE cla
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/
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!
author, Laurence Isla,. This how-to shows a way to return HTML content and use the htmx library to handle the AJAX requests. Htmx expects an HTML response and uses it to replace an element inside the DOM (see the htmx introduction in the docs). Preparatory Configuration: We will make a to-do app ...
lucasdicioccio
Richard Freeman
Khalid ⚡
marmelab
Nicolas Fränkel 🇪🇺🇺🇦🇬🇪
boringSQL
Anupam 🇮🇳《ミ》λ≡
Yiorgos Adamopoulos