Supabase
Creating multiple organizations and/or projects for self-hosted deployments #4907
Replies: 31 comments 56 replies
-
|
Is there a solution for this yet or like other open source software, users are on their own to figure out the solution, which might not even there? |
Beta Was this translation helpful? Give feedback.
-
|
Also looking for a solution on this, what is the reason supabase has chosen to only allow 1 project for the self-hosted version? |
Beta Was this translation helpful? Give feedback.
-
|
They don't want to integrate promised features, that already are on the paid version.
|
Beta Was this translation helpful? Give feedback.
-
|
I can't speak to the reasons (no inside information) but as far as Studio the readme is pretty clear: "Studio is designed to work with existing deployments - either the local hosted, docker setup, or our CLI. It is not intended for managing the deployment and administration of projects - that's out of scope. As such, the features exposed on Studio for existing deployments are limited to those which manage your database:....." And: Just wanted to tie this in with several other threads asking same thing, and not leave hanging open, at least for Studio. |
Beta Was this translation helpful? Give feedback.
-
|
It also says, in the "Managing Project Settings" section: "Project settings are managed outside of the Dashboard. If you use docker-compose, you should manage the settings in your docker-compose file." Any idea what is that about? Does that mean projects can be created in the database and set up in the docker-compose file? Or is it just talking about secrets stuff? |
Beta Was this translation helpful? Give feedback.
-
|
Not sure what you mean by projects can be created in the database... Projects are separate server instances. Each project runs on a server with its own database, PostgREST, gotrue, storage, etc. I assume settings is referring to secrets and all environment variables to provide to all the various components. |
Beta Was this translation helpful? Give feedback.
-
|
I understood from the begining that each project is a separate instance of supabase, but, maybe i didn't make it clear enough, i'd like to find a way to connect several instances of supabase to be viewable from a single studio :) |
Beta Was this translation helpful? Give feedback.
-
|
That is not possible currently with studio code in supabase/supabase github. Supabase has some extra shell in their dashboard that handles the projects and then uses the studio code once you are in the project. |
Beta Was this translation helpful? Give feedback.
-
|
Well... I have a compromise... this PR provides the ability to change the default organization and project name: #6417 |
Beta Was this translation helpful? Give feedback.
-
|
Any update on this? |
Beta Was this translation helpful? Give feedback.
-
Beta Was this translation helpful? Give feedback.
-
At this moment I lost my trust in openware. What is this practice called?The situation described is often referred to as "open-washing" or "fauxpen source". These terms apply when a company presents itself as fully open source but imposes practical or strategic limitations that make true independence difficult or infeasible. Here's a breakdown:
If a company promises "self-host everything" but creates significant hurdles, this might not be true hypocrisy but rather a business strategy leveraging open source as a lead-generation or trust-building tool. Still, the ethical tension here is real and can erode trust in the open-source community. Courtesy of ChatGPT. |
Beta Was this translation helpful? Give feedback.
-
|
Am I the only one who is getting evil vibes from Supabase where they are trying to show that their project is really open but are locking you down to the point where you might as well use their service? |
Beta Was this translation helpful? Give feedback.
-
|
I'm trying to decide whether to go for Supabase or Appwrite, so far I liked Supabase more, but seeing these limitations - I think I'm going to head over to Appwrite. I haven't looked in-depth yet but when I tried to install Supabase locally, there wasn't even an option to log in. As soon as you open localhost:3000 you're on the dashboard. Maybe someday when this product grows more, at least on the self-hosted side (because the cloud seems to be good for me) then I'll try them again because I like RDBMS than NoSQL. |
Beta Was this translation helpful? Give feedback.
-
|
@dokgu if you deployed the self-hosting version using the |
Beta Was this translation helpful? Give feedback.
-
|
Yup, and besides, self hosting docs and material are quite bad. |
Beta Was this translation helpful? Give feedback.
-
|
You can try using pocketbase |
Beta Was this translation helpful? Give feedback.
-
reports are useless u can see the traffic consumption of the vps provider you have chosen |
Beta Was this translation helpful? Give feedback.
-
|
I think it's possible .
Just an idea. |
Beta Was this translation helpful? Give feedback.
-
|
Thanks for your ans, noted |
Beta Was this translation helpful? Give feedback.
-
|
This not working anymore. I am deploy Supabase with Coolify. |
Beta Was this translation helpful? Give feedback.
-
|
This project looks interesting: https://github.com/HarryET/supa-manager |
Beta Was this translation helpful? Give feedback.
-
This would be amazing if you could get a PR for your work. For me I have 2 main pain points for the self-hosted Supabase:
|
Beta Was this translation helpful? Give feedback.
-
|
Been a long time but here's a quick update! Have a look at the Patched studio... 
|
Beta Was this translation helpful? Give feedback.
-
|
This looks amazing @HarryET, just what I'm looking for! Will follow the development and keep an eye out for open issues. |
Beta Was this translation helpful? Give feedback.
-
|
@HarryET any update ? |
Beta Was this translation helpful? Give feedback.
-
|
The repo is still there, I just havent had the time to work on it. |
Beta Was this translation helpful? Give feedback.
-
|
Is there any official solution for this? If there is not, how about to have a command line interface to allow user to create mutliple projects (create a new db instance in pgsql, create new configuration for new project, etc), and just add an entry in UI dashobard to allow users switch to different projects. |
Beta Was this translation helpful? Give feedback.
-
|
If you cannot create other projects, or add a default login panel, this is an incomplete non opensource restrictive software |
Beta Was this translation helpful? Give feedback.
-
|
If you're on Kube, it is quite easy to just spin up another helm installation for Supabase. I recently come across the Bitnami distribution of Supbase, it works pretty well: https://github.com/bitnami/charts/tree/main/bitnami/supabase, and having multitenant support is just one ingress away. |
Beta Was this translation helpful? Give feedback.
-
|
we need a solid integration with what it means open source |
Beta Was this translation helpful? Give feedback.
-
|
I see a lot of ungrateful people in this thread. However, it would be great to be able to create new projects. |
Beta Was this translation helpful? Give feedback.
-
|
I just noticed this limitation on the part of supabase, what a shame I was interested in their native auth, but for the moment I will continue with Appwrite even if it does not have this feature, at least they do release their panel completely for self hosting |
Beta Was this translation helpful? Give feedback.
-
|
Not only that, there is no login for basic install, at least pocketbase have this |
Beta Was this translation helpful? Give feedback.
-
|
Correct, pocketbase is very easy to install but if you already understand a little about docker, supabase and appwrite are similar in their installation. The bad thing about pocketbase is that it doesn't have many functionalities, it's still very green; Appwrite is the best competition before supabase, it is even more complete. But as I mentioned before, what interested me about supabase is the native auth, too bad. |
Beta Was this translation helpful? Give feedback.
-
|
Yeah, native auth is interesting |
Beta Was this translation helpful? Give feedback.
-
|
[like] Kevin Cantrell reacted to your message:
…________________________________
From: Robin Bühler ***@***.***>
Sent: Wednesday, December 6, 2023 10:03:53 AM
To: supabase/supabase ***@***.***>
Cc: Kevin Cantrell ***@***.***>; Comment ***@***.***>
Subject: Re: [supabase/supabase] Creating multiple organizations and/or projects for self-hosted deployments (Discussion #4907)
Honestly I understand Supabase, why project management isn't part of the self-hosted instances. Likely it's not an easy thing, to add to the opensource part of Supabase, because it's very cloud specific. This part of Supabase is probably tailored to their SaaS offers. I imagine, than they spin up a Supabase instance per project in their clusters, like we do, when we use the self-hosted version.
As constructive criticism I want to leave here, that the communication with the community could be better about this. I table of features and a comparison between self-hosted and SaaS would be great!
—
Reply to this email directly, view it on GitHub<#4907 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/A2T56U4A7XRG67NFC3MAX5LYIA7ITAVCNFSM5LTOGOOKU5DIOJSWCZC7NNSXTOKENFZWG5LTONUW63SDN5WW2ZLOOQ5TONZXGQ2TEMA>.
You are receiving this because you commented.Message ID: ***@***.***>
|
Beta Was this translation helpful? Give feedback.
-
|
This is super hard to simply deploy all the features on a container with ui, look at https://pocketbase.io/ and make things simpler. Supabase is blazing fast and its super amazing project come on! |
Beta Was this translation helpful? Give feedback.
-
|
Feel free to contribute, tbh. However, I'd love some communication from them on this feature request. |
Beta Was this translation helpful? Give feedback.
-
|
I wish they change the mentality on 2024, and put things easier, cause from now on, this is not opensource, they don't want to add features they promised, they had already on commercial. |
Beta Was this translation helpful? Give feedback.
-
|
How is it not open-source? Sure their commercial version has more features but this is 98% of the codebase right here. Anyway, what I've opted for doing now is just launch multiple instances on docker. Not ideal at all but a potential work around for you. |
Beta Was this translation helpful? Give feedback.
-
|
@y4my4my4m : could elaborate on that please ? I'm facing the same issue here (multi projects using supabase). Did you create a folder per project and them apply the supabase doc per folder/project ? If so, how do you handle the domain part ? Do you use sub-domains such as Thank you :) |
Beta Was this translation helpful? Give feedback.
-
|
Lines 26 to 27 in cd55df3 change these ports (and more) Essentially, docker can map ports from the container to something else on your machine. Assign all of those appropriately. But personally on my local machine, i just run 1 supabase per project, so i just shut down whichever im not using and starting the one im using. If somehow you need both running at the same time, you need to remap the ports to available ports |
Beta Was this translation helpful? Give feedback.
-
I thought Supabase added login for selfhosted recently. https://supabase.com/docs/guides/self-hosting/docker#dashboard-authentication Also you comment about only one table not sure the context of that as you surly can have multiple postgres tables. I don't use self-hosting and am not an employee so can't answer on if they will ever consider multiple instances. My understanding is that is not easy based on the way the infrastructure is setup and 3rd party tools they use behind the scenes. But I don't want to speak for them on that. I do know I have been in discussions as a moderator/issuer resolver, that self-hosted issues should get attention, from the top layers of Supabase. |
Beta Was this translation helpful? Give feedback.
-
|
I just deployed the latest self hosted and it comes with simple http auth, as in the native little per-browser popup |
Beta Was this translation helpful? Give feedback.
-
|
I will take my Github star back and move to Django🫡 |
Beta Was this translation helpful? Give feedback.
-
If this is true, I am back. |
Beta Was this translation helpful? Give feedback.
-
|
I'm going to use Appwrite now |
Beta Was this translation helpful? Give feedback.
-
|
my main issue with appwrite is that it uses mariadb |
Beta Was this translation helpful? Give feedback.
-
|
@Heargo In appwrite you can create your own backup with cron. I use it in a project with 20k users and work well |
Beta Was this translation helpful? Give feedback.
-
|
@hortigado Yes you're right ! I also made some script for backup, but I think it's a shame it's not implemented in appwrite as a easy to use feature. You can do everything in the dashboard so why not generating/downloading backup and restore/load a project from a existing backup |
Beta Was this translation helpful? Give feedback.
-
|
@Heargo I think that in the future they will add it and even so it is still more complete than supabase, the worst thing about supabase I think they will never pay attention to their users who use vps |
Beta Was this translation helpful? Give feedback.
-
|
@hortigado you might be right, but at least for my needs, the performances and possibilities offered by appwrite on table relations just don't meet my standards. A maximum depth level of 3 for a table relation is just way to low. Also the fact that the database is a custom api on top of mariadb makes it harder to migrate away from. |
Beta Was this translation helpful? Give feedback.
-
|
Hey guys, interesting discussion here. I also wondered why it is not possible to create multiple projects on the self-hosted version and I ended up not using Supabase. But why would we even need multiple projects on the same server? Genuinely asking because when one uses the Supabase commercial service and creates multiple projects, each one of these gets deployed on a separate server instance. I'm curious to know how would multiple projects be actually useful in the setting of one application on the same server and back-end dashboard. |
Beta Was this translation helpful? Give feedback.
-
|
The reason why I would want to manage multiple supabase projet on a same self hosted server is to easily manage all my side projets on the same server and easily deploy and upgrade the version of my projets. If you only consider one project it's simple to maintain it but the more side projet you have the more complicated it is to upgrade and manage all your supabase instance (even with docker). So in the setting of one application on the same server I don't see the utility either 🤔 |
Beta Was this translation helpful? Give feedback.
-
|
I won't speak for everyone else but for my use case, I have a mini PC at home where I host a bunch of open source tools/apps and also host some custom apps that I developed myself. These custom apps are either deployed through Vercel or as a Docker container on that mini PC where I wanted to host my own instance of Supabase. I don't really want to spin up multiple instances of Supabase in the same mini PC for multiple projects that I am working on. This is why Appwrite became my option since it allows me to set up Appwrite once and I can work on all the projects that I want without having to spin up so many instances. These projects aren't for a SaaS but more for personal use so traffic isn't a huge deal. Anyway, I'm sure others have good reasons for wanting to have the ability to create multiple projects in one selfhosted instance just like on the cloud version. |
Beta Was this translation helpful? Give feedback.
-
|
Love these insights, I get it now. I naively was only considering heavy applications that would be better off running alone. Thanks mates! |
Beta Was this translation helpful? Give feedback.
-
|
I was working on https://github.com/harryet/supa-manager but there isn't always much interest so it died off, if people are still interested in it then I can probably finish it off |
Beta Was this translation helpful? Give feedback.
-
|
Hi Harry: Judging by the amount of stars you've garnered I think there might be a bit of build-it-and-they-will-come sort of thing. I just talked to the folks at Convex. They're doing a similar Supabase thing with Rust / Typescript. Their local version also doesn't have project / teams and they told me it's the most requested feature. So much so, they're re-writing the local version to tie into the online projects / teams in dev mode. They can't do a complete local project / teams just because they didn't think of it to begin with. I think you'll generate a lot of interest if you finish this puppy. (or kitty in your case). |
Beta Was this translation helpful? Give feedback.
-
|
Yeah, I'm going to try get a working version over the weekend because I have a bit of spare time! So I guess it's a watch this space sort of thing |
Beta Was this translation helpful? Give feedback.
-
|
That's great to hear. We're always around to lend a hand. Testing, atta'boys, etc. |
Beta Was this translation helpful? Give feedback.
-
|
What I think people are missing is that every supabase project IS an entire stack, in other words, an entire realtime gotrue analytics etc... So having a dashboard to manage projects would have to quite literally be custom made for that, to run on docker, and then you have swarm and kubernetes... It would basically have to connect to docker do do it, and is not par of the codebase since they probably have their own deployment solution for it. So you need a custom thing for it and I don't think they have the time to spend on doing it, what they did is already quite amazing. |
Beta Was this translation helpful? Give feedback.
-
|
Stay tuned, I'm working on the very thing with Kubeworkz.... |
Beta Was this translation helpful? Give feedback.
-
|
Sounds really Interesting :) Do you have some more information about it? |
Beta Was this translation helpful? Give feedback.
-
|
I hope Supabase allow multi databases, if only one database is not enough for huge resource Supabase use on VPS :\ Can I use multi schemas ? |
Beta Was this translation helpful? Give feedback.
-
|
Still no comment from them on this? I guess supabase is not as ooen as they claim to be. I'm gonna be migrating to Pocketbase. |
Beta Was this translation helpful? Give feedback.
-
|
Yes, i think so. |
Beta Was this translation helpful? Give feedback.
-
|
I can't fault them at all, it would be really complicated to support and beyond the goals of offering a self-hosting path. The Docker-based self-hosting deploy leverages environment variables for most project-level configuration, which is a best practice for enabling self-hosting. Enabling multi-project/org support in self hosting would require moving all that to a configuration management system that probably looks nothing like the one they use for their SaaS offering, and would make self-hosting more complex and diverge from best practices for self-hosting in many cases |
Beta Was this translation helpful? Give feedback.
-
|
I agree 100% with @themightychris. I self-host as much as I can and continue to expand my self-hosting efforts. That said, I also recognize that preparing, documenting, and supporting the infrastructure is a project in itself. This stuff can be temperamental and requires a lot of deliberate planning. If you've worked at a big tech company, you'd understand just how much "cowboy DevOps" happens—which is why I laugh at the notion that the source code is the ultimate prize, since it's often underwhelming (but I digress). This could be deliberate, and if we were talking about a large company, the argument might hold more weight. However, Supabase is not large, so it's far more likely that they simply haven't yet invested the resources needed to fully flesh out the DevOps side of things. That said, they’ve open-sourced most of the project, which is commendable. Hopefully, as their product and company mature, they’ll put more effort into improving the infrastructure side—but that's icing on the cake. For now, their infrastructure does require some DevOps expertise, but that shouldn't be used as an excuse to slam them or assume their intentions are nefarious. |
Beta Was this translation helpful? Give feedback.
and others
-
Hello all!
Just started using Supabase last week and I was wondering if the following will be possible for self-hosted deployments THROUGH the Supabase Studio:
Atm the corresponding buttons for these actions do not appear when running a self-hosted deployment.
Thanks in advance!
Beta Was this translation helpful? Give feedback.
All reactions