@dcsan Welcome to the Redwood community! 
I have a Redwood chat example using Supabase here: https://github.com/Tobbe/supaslack
Redwood does not support GraphQL Subscriptions (yet), so unfortunately you can’t leverage that.
Redwood can 100% run on your own hardware. @viperfx is doing that. But I don’t think we have a complete write up on how to do it yet. There has been some talk here: Serverfull hosting
We would for sure want to make Redwood’s realtime story more solid, so we’re super happy to have you here with your experience in the area. If you have any concrete ideas on how we can improve, don’t hesitate to let us know 