Support for multi-root projects

[hnykda]

Hey.

We have a monorepo with e.g. 8 different supabase projects. Would be awesome if we could scope the settings to the given subdirectory instead of having one megaroot. Currently, when I start the project, I get:

PostgresTools does not support Multi-Root workspace mode for now.

[psteinroe]

Thanks for the suggestion! Out of curiosity - what kind if project requires eight individual supabase projects?

Would you expect a single config or one per project?

[hnykda]

Eh, it's just a monorepo for our whole company. Given that you can only have one database per project and also because our projects vary wildely in size (and benefit from separation), we need more supabase projects 🤷 .

And yes, I would expect single config per one project (some subdirectory here), or how VSCode code-workspace file works (so it's one config with specific setting for the given subfolder)

[psteinroe]

Thanks for sharing!

and okay, I will create an issue for this. But it's a larger effort so can't tell when this will happen 🙏🏼

[hnykda]

sure, no worries, this was just to show an interest, I understand