🚀 Feature: Replace Websocket by Server Sent Events

### 🔖 Feature description Replace Websocket by SSE , wich is [browser native](https://developer.mozilla.org/en-US/docs/Web/API/EventSource#browser_compatibility) ### 🎤 Pitch If I'm not mistaken, realtime is currently used in one direction only (data updates are done via SDK, not websocket) so losing bidirectionnal feature isn't a big deal (otherwise I wouldn't propose the replacement) SSE allow automatic reconnection, stream resume, works with HTTP protocol and bypass proxy protection (thanks to use of http) This would also make it possible to use realtime in the backend ? Works with HTTP protocol also mean compression, easier handshare / session management, I don't know enough about the realtime source code to realize whether the two can coexist, and have a configuration via environment variables (or in the console) to have one or the other (or both?). But of course the change should not be so complicated, as the trigger would remain via the resque tail. It should also mean less maintenance, as it's based on a standard and doesn't need an external library to work. More read - [Appwrite issue](https://github.com/appwrite/appwrite/pull/692) (for realtime) - [Why use Server-Sent Events over WebSockets?](https://ably.com/blog/websockets-vs-sse#why-use-server-sent-events-over-web-sockets) - OR wait some years and change to [WebTransport ](https://www.w3.org/TR/webtransport/)^^ ### 👀 Have you spent some time to check if this issue has been raised before? - [X] I checked and didn't find similar issue ### 🏢 Have you read the Code of Conduct? - [X] I have read the [Code of Conduct](https://github.com/appwrite/.github/blob/main/CODE_OF_CONDUCT.md)