Public
- Public
- Network
- Groups
- Featured
- Popular
- People

Conversation

Notices

Embed this notice
Evan Prodromou (evan@cosocial.ca)'s status on Thursday, 17-Oct-2024 19:53:30 JST Evan Prodromou

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.
https://postgrest.org/

In conversation about a month ago from cosocial.ca permalink
- Embed this notice
  Geoff (opinionatedgeek@mastodon.social)'s status on Thursday, 17-Oct-2024 20:44:51 JST Geoff
  in reply to
  
  @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.'
  In conversation about a month ago permalink
  Attachments
  1. Domain not in remote thumbnail source whitelist: adriano.fyi
    
    Choose Postgres queue technology
    
    Introduction Postgres queue tech is a thing of beauty, but far from mainstream. Its relative obscurity is partially attributable to the cargo cult of “scale”. The scalability cult has decreed that there are several queue technologies with greater “scalability” than Postgres, and for that reason alone, Postgres isn’t suitably scalable for anyone’s queueing needs. The cult of scalability would rather we build applications that scale beyond our wildest dreams than ones that solve real problems beyond our wildest dreams.
- Embed this notice
  Evan Prodromou (evan@cosocial.ca)'s status on Thursday, 17-Oct-2024 20:44:51 JST Evan Prodromou
  in reply to
  - Geoff
  @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.
  
  In conversation about a month ago permalink
- Embed this notice
  Aslak Raanes (aslakr@mastodon.social)'s status on Thursday, 17-Oct-2024 20:47:58 JST Aslak Raanes
  in reply to
  - Lovasoa
  @evan Maybe @lovasoa's https://sql.datapage.app is better suited?
  In conversation about a month ago permalink
  Attachments
  1. Domain not in remote thumbnail source whitelist: sql.datapage.app
    
    SQLPage: SQL to web pages
    
    Go from SQL queries to web applications in an instant.
- Embed this notice
  Evan Prodromou (evan@cosocial.ca)'s status on Thursday, 17-Oct-2024 20:47:58 JST Evan Prodromou
  in reply to
  - Aslak Raanes
  - Lovasoa
  @aslakr @lovasoa it doesn't seem to be oriented towards APIs, so: no, I don't think so.
  
  In conversation about a month ago permalink
- Embed this notice
  Evan Prodromou (evan@cosocial.ca)'s status on Thursday, 17-Oct-2024 22:07:22 JST Evan Prodromou
  in reply to
  - Achim Domma
  @achim "Has anyone built an #ActivityPub server using just Postgrest? [...] https://postgrest.org/"
  I'm talking about using Postgrest.
  In conversation about a month ago permalink
  Attachments
  1. Domain not in remote thumbnail source whitelist: docs.postgrest.org
    
    PostgREST Documentation
    
    , PostgREST is a standalone web server that turns your PostgreSQL database directly into a RESTful API. The structural constraints and permissions in the database determine the API endpoints and operations. Sponsors:,, Database as Single Source of Truth: Using PostgREST is an alternative to manua...
- Embed this notice
  Achim Domma (achim@social.saarland)'s status on Thursday, 17-Oct-2024 22:07:23 JST Achim Domma
  in reply to
  
  @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 ?
  In conversation about a month ago permalink
  Attachments
  1. Domain not in remote thumbnail source whitelist: opengraph.githubassets.com
    
    GitHub - PostgREST/postgrest: REST API for any Postgres database
    
    REST API for any Postgres database. Contribute to PostgREST/postgrest development by creating an account on GitHub.
- Embed this notice
  Evan Prodromou (evan@cosocial.ca)'s status on Thursday, 17-Oct-2024 22:14:33 JST Evan Prodromou
  in reply to
  - Achim Domma
  @achim no big deal! It just took me a few reads to understand what you were asking!
  
  In conversation about a month ago permalink
- Embed this notice
  Achim Domma (achim@social.saarland)'s status on Thursday, 17-Oct-2024 22:14:34 JST Achim Domma
  in reply to
  
  @evan Argh, sorry. Stupid me! The preview was somehow not displayed properly for me and I misread the url.
  
  In conversation about a month ago permalink

Public

Conversation

Notices

Feeds