How does one go about seeding the DB with supabase? I figure adding a 'dev' project and 'prod' project to separate data entities and such is a good idea, but if I wanted to seed the 'dev' instance easily with some JSON or something what would be the fastest route?
s
silentworks
08/30/2021, 3:56 PM
You can use any database seeding tool or and database migration tool as you have direct access to the underlying Postgres database.
silentworks
08/30/2021, 3:58 PM
If inside the dashboard you go to Settings/Database and scroll down to Connection Info, you will get all the details to connect to your database directly.
s
Scott Prins
08/30/2021, 3:58 PM
oh nice thank you!!
Scott Prins
08/30/2021, 3:58 PM
side note, LOVING the threading features with Discord now
Scott Prins
08/30/2021, 4:00 PM
@User is there a way to duplicate a DB so I don't have to recreate tables in the dashboard for the new 'prod' instance I wanna create?
s
silentworks
08/30/2021, 4:02 PM
I tend to use a migration tool to make sure I can repeat this process easily. Otherwise you can connect to the database with a Postgres app like TablePlus and export the database then import it into your next environment