jacobJun 17
En favoritstack jag laborerat med på sistone (#opensource så klart), för att ersätta lösa excelfiler som mest innehåller relationell data, är baserat på #mathesar - ett slags kalkylbladsinspirerat lagringssystem på #postgresql. Om man sedan kopplar på #postgrest så får man även ett REST-api över sin data, med väldigt liten arbetsinsats. Fin synergi 😊
Show threadmichabbbApr 9

⚡ Benchmarks: #NpgsqlRest is 6.1x faster than #PostgREST at 100 concurrent users — AOT-compiled native binaries, zero runtime dependencies & instant startup time

🔧 Install via npm, Docker, direct download or as a #dotnet library — requires #PostgreSQL >= 13 — no runtime dependencies for the native executable builds

📝 Declarative config via SQL comment annotations — define routes, auth rules & caching directly in your DB. One source of truth, zero drift between logic and config.

lucasdicioccioDec 5, 2025
I run #PostgREST on CloudRun, and I'm reasonably happy with it. It requires a modicum amount of setup. Would that make an interesting blog post?
Show threadRichard FreemanJun 13, 2025

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

OpenAPI

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

PostgREST 12.2
lucasdicioccioMar 3, 2025

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

Lucas DiCioccio's Blog - Using PostgREST for development, troubleshooting, and data endpoint

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.

lucasdicioccioJan 14, 2025
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.
Lucas DiCioccio's Blog - PostgREST Table: simplifying Postgres exploration

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.

Khalid ⚡Dec 24, 2024

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.

marmelabNov 5, 2024

📢 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

PostgREST: Revolutionizing Web Development with Instant APIs

PostgREST has been around for a long time, but many web developers still haven't discovered how it can simplify their workflow.

Nicolas Fränkel 🇪🇺🇺🇦🇬🇪Jul 14, 2024

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/

Advanced URL rewriting with Apache APISIX

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

A Java geek
boringSQLJun 8, 2024

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

PostgREST Tutorial: APIs made easy | boringSQL

Practical guide that deep dives into the world of building APIs with PostgREST, a tool that leverages your existing PostgreSQL database.