Migrating from Supabase

Re:Migrating from Supabase by jackconsidine on Friday May 19, 2023 @04:11PM (#36006308)

Nice read. I run 5-6 projects on Supabase currently. I have also run into the local development / migration obstacles. It's otherwise been pretty great for our needs

[ Parent | on HN ]

Re:Migrating from Supabase by SOLAR_FIELDS on Friday May 19, 2023 @08:04PM (#36008167)

The CLI could use some love for sure. I think the migrations experience is also where I’ve felt the most pain. I will say, the CLI very heavily assumes that you are using the cloud product as the remote, which I guess is absolutely intentional (it’s a path to get users onto the product) but it was kind of annoying to figure that out halfway into a POC like I did. Don’t go in expecting you can point the CLI at some self hosted remote. It’s not possible without forking, making significant changes and rebuilding the CLI, at least at the time I was doing this a few months ago.

[ Parent | on HN ]

Re:Migrating from Supabase by sweatybridge on Friday May 19, 2023 @11:50PM (#36009220)

Hello, I'm working on CLI full time. Things have certainly improved over the last few months on using the tool for migrating self-hosted databases.

Currently all supabase db and migration commands support --db-url flag [1] which allows you to point the CLI to any Postgres database by a connection string.

If you need other commands to support self hosted, feel free to open a GitHub issue with us and we will prioritise accordingly.

[1] https://supabase.com/docs/reference/cli/supabase-db

[ Parent | on HN ]