Ultimate Self-Hosting Guide for NextJS + Supabase (2024)

[@pushkarkathayat7893]

I installed supabase on vps, But it doesnt have the supabase auth. How to install it?

[@theointechs]

If you use the Coolify interface to deploy it should be there...

[@pushkarkathayat7893]

@@theointechs It is not unfortunately :(

[@theointechs]

@@pushkarkathayat7893 for personnalized help, i offer 1-1 consultation at calendly.com/expoweb if you dont find the answer

[@AsyncDpp]

Thank you for this. Some Astro stuff would be great too!

[@theointechs]

Thank you! never used Astro in the past ngl but I might check it out!

[@taoufiqlotfi4893]

Hey Theo making database public part is not working with coolify anymore i keep getting the error "Connection to ServerIP:5434 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. Connection refused" when i try to connect to the database

[@theointechs]

Make sure the port is opened on the network and that firewall has a passthrough

[@yadon9884]

Theo, the minio fix was awesome! Will you make a very detail step by step video on implementing the OAuth and SMTP into supabase on coolify? also your schedule a call link isn't working.

[@theointechs]

I could surely do that! My new scheduling link is cal.com/team/dev-sunmoon i will make sure to change it!

[@LECLERNathan]

Hey Theo ! Amazing content ! I have a next-js with supabase project running on vercel at the moment but would like to move to self hosted alternative. I am quite new to dev and many of this coolify setup options are still blur for me. Would you take some freelance work to deploy next js and supabase on a private VPS (that I already have, on digital ocean) ?

[@theointechs]

Hi Nathan, you can contact me at my email and also checkout my agency at sunmoon.co

[@psuedocode5592]

hey Theo, did you open the port for supabase-studio: and not for supabase-db: ?

[@theointechs]

I opened only the Postgres db port to be able to remote access, otherwise my domains are using a reverse proxy so its more secure.

[@amogelangmoatswi1918]

newbie here, how many simple next.js landing pages can i host on that VPS.. if i where to start a small web dev business?

[@theointechs]

A LOT, I mean im on a VPS with 6 GB of ram and pinging the api non stop doesnt even overload, what takes juice more are databases.

[@josipX]

Thanks for the awesome video. For me the buckets never load in the supabase storage UI and there's also nothing helpful in the supabase storage or minio logs. Very strange.

[@theointechs]

@@josipX hey man thanks for the kind words! You are actually the 3rd person who told me this problem, i will look into it more deeply and make a video about it, stay tuned.

[@josipX]

@@theointechs there's a github issue in the coolify repo number 2360, apparently there's a https connection missing somewhere between the minio createbucket container and supabase

[@theointechs]

​@@josipXill make sure to take a look

[@theointechs]

Just to make sure, have you tried changing the tags for minio/minio and minio/mc?

[@rizzao_br]

For me, the following worked: - install minio - create a bucket in minio - generate the keys - only after that install supabase if I install supabase without having any bucket in minio, it simply doesn't work!

[@lev1ato]

Really like your content, keep it up. I would love to see a whole project done with Next.js, self-hosted and with Supabase db/auth self-hosted. Step by step instructions. Have like a protected page with, credentials signup/login, github auth, google auth and maybe storage with R2. Just to see the whole process, I might try it on my own, but I was not able to find something similar anywhere. Maybe even for auth not use Supabase auth even if it is not possible or hard to do, and go for Lucia v4 or betterauth. Just thinking out loud.

[@theointechs]

Hey man! Thank you for the feedback :) Right now I am very busy with my startup MyBookQuest but what I could do is make a live at the end of the month where we go deep on EVRYTHING of the project, how does that sound?

[@lev1ato]

@@theointechs That sounds awesome! would love that. Wish you all the luck with your startup.

[@theointechs]

@@lev1ato All right, stay tuned as in the next videos ill mention the date and time but it should be at the end of the month!

[@nicomasset]

hi, i have trouble with my next js env concerning supabase. I dont know what are supposed to be the supabase public url and DATABASE_URL, i'm kinda lost in there

[@theointechs]

If you are using the same Supabase deployment as me then you need the keys that are auto generated in the "Environment" tab at the left of the Coolify UI on your project. See at 17:40 when I didn't enter the keys I had the same error as you do probably.

[@nicomasset]

@@theointechs i don't get it. when i use to do it without coolify and i needed some env variable in my next app, related to supabase. (such as NEXT_PUBLIC_SUPABASE_ANON_KEY, SUPABASE_SERVICE_KEY etc..) And i have trouble finding what to use for DATABASE_URL and NEXT_PUBLIC_SUPABASE_URL. I think i missed the auto generated part oO

[@mjoong-ki4487]

Can’t believe it’s been a year since I’ve been waiting for Supabase to come out with a beautiful login page UI, not just that basic popup. And there’s still no sign of it. 😅 (maybe I have, but i still can't find it.)

[@theointechs]

And its also so simple... 😂

[@andru5054]

nice

[@flowmv]

Wow, appreciate this Theo! I just have two concerns stopping me from going all in on VPS 1. storage Currently while using supabase cloud, in my next.js code I'm using supabase's sdk storage procedures for uploading and storing files. Is it a straightforward setup to create our own s3 buckets and link them to the coolify's supabase instance? Would love a tutorial on that if possible, on making storage work while still using supabase's procedures for it 2. managing development & prod envs for supabase I'm sure for next.js we can just use branching for dev and prod, but how easy or difficult would it be to manage a development and prod environment for supabase, in this kind of a setup? how would the architecture work? would love a tutorial covering this if possible

[@theointechs]

Hey thank you for the kind words! For Storage, you still have the ability to create storage buckets on the supabase admin dashboard on your self hosted instance, you can also link S3 buckets as backup directly on the Coolify UI of your project. For different envs topic, when creating projects, you can choose the environment at the top of the screen, you can then use different branches in your git to handle your NextJS deployments differently as well as different DB schemas.