I have a Django server with a user database stored in MySQL. I’m using Django Rest Framework and Django Allauth for user authentication.

I want to build another application for storing user questions. The data for these questions should be stored in Supabase. I want to authenticate users with the Django server, and only authenticated users with the required authorization should be able to ask questions in the other application.

Here’s what I want to achieve:

User logs in through the Django server (using Django Allauth).
Once authenticated, the user can ask questions in the other application.
The questions are stored in Supabase in real-time.
Only authenticated users with the required authorization can ask questions.
I’m not sure how to integrate Django with Supabase and handle real-time data updates. I also want to ensure that the authentication and authorization processes are secure and efficient.

I have checked the documentation of supabase but I haven’t found any information about third party authentication except the social the authentication that’s what I noticed, maybe I missed someting.

Any guidance or resources on how to achieve this would be greatly appreciated. Thanks in advance!

P.S: I want to take advantage of the real time feature of supabase and maybe other features in the future, so it’s hard to find other alternatives.