Has anyone built an #ActivityPub server using just Postgrest?
-
Has anyone built an #ActivityPub server using just Postgrest? I don't think it'd be easy but it could be very fun. The tricky part would be making the delivery job queues work; don't think Postgrest has them built in.
-
@evan maybe with the LISTEN / NOTIFY and triggers setup. But exposing your database directly to the internet still sounds like a bad idea to me
-
@evan Just out of curiosity: Are you talking about using Postgres as the only database or implementing it directly in Postgres using something similar to https://github.com/PostgREST/postgrest ?
-
@evan Maybe @lovasoa's https://sql.datapage.app is better suited?
-
@evan If someone does give it a go, they might find this useful: https://adriano.fyi/posts/2023-09-24-choose-postgres-queue-technology/
'By combining `NOTIFY` and `LISTEN`, Postgres makes adding pub/sub to any application trivial.'
-
@OpinionatedGeek yes, I thought of that as well! I don't know if you can LISTEN with a stored procedure that runs inside the PostgreSQL server, though.
-
-
@achim "Has anyone built an #ActivityPub server using just Postgrest? [...] https://postgrest.org/"
I'm talking about using Postgrest.
-
@evan Argh, sorry. Stupid me! The preview was somehow not displayed properly for me and I misread the url.
-
@achim no big deal! It just took me a few reads to understand what you were asking!
