I hope it's suitable because I will be using as well for an app that will have 1k+ user base. As far as self-hosting goes, if you're planning on using Supabase Realtime, it can be self-hosted along with the other pieces of the Supabase stack.