Real-time Notifications (SSE)

Subscribe to PostgreSQL NOTIFY channels over Server-Sent Events:

curl -N "http://localhost:8080/sse/my_database?channels=orders,users" \
  -H "Authorization: Bearer $TOKEN"

Each message is JSON with the channel name and payload:

{"channel":"orders","data":{"id":123,"status":"created"}}

If the payload is plain text, it is wrapped as a string in data.