Supabase Crash Course For .NET Developers: Building an API From Scratch

Supabase is an open-source Firebase alternative. The cloud platform offers fantastic features such as a PostgreSQL database, Authentication, Storage, Edge Functions (serverless), and Realtime subscriptions. You can get a complete backend with Supabase in just a few minutes by creating a project. Supabase has a generous free tier for you to try, and I recommend you check it out.

Join my weekly .NET newsletter:

Read my Blog here:

Chapters
0:00 Supabase crash course
0:35 What is Supabase?
1:07 Database
1:16 Authentication
1:23 Storage
1:31 Realtime
1:43 Edge Functions
1:54 Supabase pricing plans (awesome FREE tier)
2:25 Creating a Supabase project
3:25 Supabase Table Editor in the Web client
5:44 Supabase C# client
6:22 Building an API with Supabase
7:05 Configuring the Supabase.Client
8:12 Creating a Model for interacting with the DB
11:13 PostgREST introduction
11:55 Creating a POST endpoint
13:59 Creating a GET endpoint
16:01 Creating a DELETE endpoint
16:57 Giving our Supabase API a try

[schultzjosephj]

Hey @Milaan, maintainer for the C# libraries here, thanks so much for making a video featuring the C# client! Super cool to see a whole video on how to interact with it. I've included a link to the video on the readme to the supabase-csharp repo!

Appreciate you!

[alexandresobralmartins]

Excellent video Milan ! It would be interesting if you show us a little tutorial on how we use the authentication/authorization module with supabase 😃
Thank you !

[briananeurysm]

Nice tutorial, please add more topic like authentication and RLS love watching your vids :D

[vekzdran]

Excellent work Milan! I needed just this kind of video, right to this extent. I love it how this can be used to spin a MVP fairly quick without hustling with plumbing. It so funny to see that you need the api key only, no DB connection etc. Id still hide it behind interfaces to be able to eject later if required to real DB conn eg.

I'd like VERY MUCH to see auth impl. and edge function usage also mixed into this.

Also, would love to hear a comparison with pocketbase eg. :)

Great video, as always, thank you.

[caseyspaulding]

Supabase is so convenient and powerful. Just discovered it! Wow

[peterkulik]

What are the advantages of developing a Web API with Supabase compared to a plain Web API + EF/Dapper?

[adiazwise]

Great video Milan ! I didn't know Supabase, could be useful in some scenarios.

[casmatos]

Hello Milan. Can you tell me what addon you using in Visual Studio to show colors on code?

[erickmoura]

Nice video, Supabase is very straightforward!

[itsmebunk]

Hey, great video! Would you recommend using Supabase for authentication in a client & web api scenario?

[flaviocejas]

Increíble milan! Una pregunta, se puede modificar el back por ejemplo para hacer un sustema de ventas?
Por que supa base tiene muy pocos endpoints, solamente para un CRUD basico

[necatorem]

Thanks Milan for the effort to convey the knowledge.
I am trying to retrieve information from a relationship and it works when the entity has a list of subentities, but not when the entity needs a description of a higher entity. Can you help me?

[manofqwerty]

When doing the where LINQ statement are we filtering after all the data has been fetched from the database or are we filtering on the database itself?

[mohammedbenlaiter]

I have encountered some difficulties, can i create a data access layer file and deal only with stored procedure only ? without mapping etc ? because my project is simple and thank u so much for this course

[syfdknw]

So, supabase is actually Postgres database, hosted in the cloud and the client allows connecting and using their cloud based database? Is that the idea in a nutshell?

[davidhoong]

Hi, Milan. When I run you project, I got a error: new row violates row-level security policy for table "newsletters". What's wrong with me?

[TheKalirk]

can I know, why need write in program.cs all checking point?
possible create interface ?

[tiagobn]

Hi Milan! Thank you for sharing your time and knowledge. Is it possible to do CRUED in Supabase directly in a Windows Forms App (.Net Framework)? I tried to do it, but without success. Kind regards Tiago.

[hervinsonsamson]

please do video for authentication mainly for JWT

[tiagobn]

Hello Milan! I'm trying to run my application, this is an addin for SolidWorks and I'm getting this error, could you tell me what to adjust in the code?

WebsocketException: Failed to start Websocket client, error: 'Unable to connect to remote server'

WebSocketException: Unable to connect to remote server

WebException: The request was aborted: Unable to create a secure channel for SSL/TLS.