News for hackers. Stuff that matters.

A comment on Ask HN: How Can I Make My Front End React to Database Changes in Real-Time?. Parent comment

Re:Ask HN: How Can I Make My Front End React to Database Cha... by codingdave on Wednesday April 17, 2024 @01:06PM (#40067458)
...and that oversimplifies everything. Yes, websockets to the browser are likely to be a piece of the answer. But a server needs to maintain the session for the websocket and send messages. And that server needs to subscribe to data updates in the database... while also respecting auth of the current user.

It is certainly a problem with an achievable solution, but it is not simple.

[ Parent | on HN ]
Re:Ask HN: How Can I Make My Front End React to Database Cha... by bruchim on Thursday April 18, 2024 @04:04AM (#40074009)
Agree.
[ Parent | on HN ]
Re:Ask HN: How Can I Make My Front End React to Database Cha... by helloworld42024 on Thursday April 18, 2024 @05:01AM (#40074269)
In his initial message, the original poster provided a link to Supabase, which integrates PostgreSQL with PostgREST out of the box. This setup automatically offers websocket server functionality:

1. The websocket server, database data subscriptions, and all session management are consolidated in this layer.

2. Updates to data are efficiently managed using a built-in PostgreSQL function.

3. User authentication is managed via React, employing either JWT or OAuth.

As I mentioned earlier, it's quite simple.

[ Parent | on HN ]