Migration from postgres
Hello! Wondering if there is any docs or support availble to migrate from supabase -> convex +clerk. We are debating the switch due to simplified realtime + seamless realtime+RSC but fear the migration!
3 Replies
Hey @JJ, I don't think we have a specific doc for this yet. Do you have production data in Supabase?
I'd suggest you try out Convex, perhaps try to build a small portion of your existing app. That'll give you a sense of what you'll need to do to migrate over.
If you do have existing data, you can bring it in via import: https://docs.convex.dev/database/import-export/import#single-table-import
Importing Data Snapshots | Convex Developer Hub
Import data into Convex
Hey @Michal Srb !
Yes currently running production auth, storage, and data with supabase! I found some docs on the supabase side about the airbyte extenstion and got some dev data moving into convex! The only thing i dont quite understand is that the docs recommend keeping this data Readonly which would be problematic if i do a roll out or slower migration, any ideas here?
So if you're migrating a live app, you probably want to:
1. Starting with Supabase
2. Add streaming import into Convex
3. Migrate reads onto Convex
4. Migrate writes onto Convex (you can do this one at a time)
Does that make sense?
Alternatively you could build a version of your app on Convex, and then switch in one go, perhaps with some downtime.