❔ Help Using Supabase
Would you happen to know of any guides which explained how to create an auth schema db since the auth db template looks quite intimidating compared to the regular empty db template. The tables and items required in the db is:
Users Table : Username, Password, UserID
Conversations Table: ConversationID and ConversationType (Group or private DMs)
Participants Table: participant ID, UserID and ConversationID
Messages Table: MessageID, MessageContent, SenderID, ReceiverID, ConversationID and a timestamp
(I haven't yet thought fully about authentication to keep messages private so maybe I can use the ConversationType to dictate which users can see which messages)
The two db templates are shown above
7 Replies
If you're new to auth and databases in general, I'd probably stick with letting efcore or something similar manage the db schema rather than trying to use a supabase template. https://learn.microsoft.com/en-us/aspnet/core/security/authentication/identity?view=aspnetcore-7.0&tabs=visual-studio (This gets better in a few months with dotnet 8)
As for the other stuff, it seems fine for what you're doing. If you wanted it could help to look into relational database normalized forms and the trade-offs between them.
I kind of need to use supabase so that I don’t need to connect my network to the internet and can use a server instead. Any chance I can get them to work with supabase
I'm not 100% sure how supabase works, but if its a postrgres compatible db then you should be able to use efcore with identity and point it at supabase. With sufficient permissions it should be able to do schema migrations too.
Ok, I’ll take a look online and see what I can find
Was this issue resolved? If so, run
/close - otherwise I will mark this as stale and this post will be archived until there is new activity.I think your suggestions seems is the most straightforward approach
Was this issue resolved? If so, run
/close - otherwise I will mark this as stale and this post will be archived until there is new activity.