Create accountLogin

Recent searches

No recent searches

Search options

Only available when logged in.
cosocial.ca is one of the many independent Mastodon servers you can use to participate in the fediverse.
A co-op run social media server for all Canadians. More info at https://blog.cosocial.ca

Administered by:

Server stats:

140
active users

cosocial.ca: AboutProfiles directoryPrivacy policy

Mastodon: AboutGet the appKeyboard shortcutsView source codev4.3.4

Public
Emelia 👸🏻

@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

Quiet public
jon ⚝

@thisismissem
Somehow to me the question reads: which is the minimum viable shim to plug on top of a networked state store & RPC/query engine that gives an AP-compatible endpoint?
@evan

Public
Evan Prodromou

@aslakr @lovasoa it doesn't seem to be oriented towards APIs, so: no, I don't think so.

Public
Geoff

@evan If someone does give it a go, they might find this useful: adriano.fyi/posts/2023-09-24-c

'By combining `NOTIFY` and `LISTEN`, Postgres makes adding pub/sub to any application trivial.'

Adriano Caloiaro's personal blog · Choose Postgres queue technologyIntroduction 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 queuing needs. The cult of scalability would rather we build applications that scale beyond our wildest dreams than applications that meet concrete customer and business needs.
Public
Evan Prodromou

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

ExploreLive feeds
About