Clarification regarding live database

Need help
1

Hi friends,

I’m preparing to deploy my first Bubble app and had a question about the “Switch to live database” option.

My app is fully working in Development mode. I understand that Bubble has separate Development and Live databases, but I’m confused about what I actually need to do before launch. Do I need to click ‘Switch to Live Database’ before I click ‘Deploy’.? If I need to do both, which is order I should do it in?

If I simply click “Deploy to Live”,

  • Will pages, workflows, backend workflows, privacy rules, and Option Sets automatically go live?

  • Do I also need to manually switch to the Live database and copy/create records there?

  • What kinds of data typically need to exist in Live DB before users start using the app?

Would appreciate your response

2

Congrats on your first Bubble app! All you need to do is click Deploy unless you have things in your test database that need to be there in live for the app to work. Option Sets/Pages/Workflows/Backend Workflows/Privacy Rules get deployed automatically as part of the app code. However, if you have, for example, a data type called “US States” that has 50 records in the test db and a dropdown that does a search for that data type, then you need to push those records to the live db.

You can push data back and forth (with caution) using the “Copy and restore database” function from the Data > App Data tab in the editor.

3

Thanks a lot Josh for your valuable input.

Yes, I have data set with drop down values which become part of app ui dropdown . So do I need to use ‘switch to live db’ to transfer those over?

When do I use ‘copy and restore database’. Trying to understand the difference between two

Also do I click deploy first or do I switch to live db and then deploy?

4

Hi @subrata.joy !

You can learn more about the two topics here below

In short, you need to deploy your app to live first so the data tables will be there to receive data. Then you have 2 options. You can create fresh data in the live app or copy over your development data into live.

If its a list of dropdown options, you will probably want to copy them into live. However it might make the most sense to turn them into an option set instead. Which is a set of items shared between dev and live environments!