How to implement SSE

[gladiiss]

I want to implement Server Side Events (SSE).
For example:
One client's action results in some changes in a db table (server side).
This triggers an event (SSE).
All connected clients receive this event and update a custom component (say status text)
Is this possible with Orchid?

[gladiiss]

Is it possible to use turbo streams for this?
From this page, what I understand is, it is doable with orchid.
(https://turbo.hotwired.dev/handbook/streams)

Turbo Streams deliver page changes as fragments of HTML wrapped in self-executing elements. Each stream element specifies an action together with a target ID to declare what should happen to the HTML inside it. These elements are delivered by the server over a WebSocket, SSE or other transport to bring the application alive with updates made by other users or processes. A new email arriving in your imbox is a great example.

Can someone give an example on how to do the turbo way?