[Feature Request] Use existing Project to deploy

[Siddhesh-Agarwal]

trafficstars

Feature request

Is your feature request related to a problem? Please describe.

The ability to connect existing projects (while deploying) instead of creating new projects

Describe the solution you'd like

While deploying via Supabase, we should be able to create a new project or use an existing project

Additional context

[gregnr]

Hey @Siddhesh-Agarwal thanks for the request. Using existing projects can be tricky because of potential conflicts between your database.build migrations and existing schema. One way to deal with this could be to have database.build first import the schema from your existing Supabase project prior to beginning the conversation.

Any other ideas? Let's keep brainstorming how this could work.

[Siddhesh-Agarwal]

Hey @gregnr, I guess this can work with a simple check: check whether any table exists in the project's DB. A Supbase Project has various aspects, such as auth and storage. If the DB contains no table, we should be able to connect to an existing project