Forum | Appery.io

Currently we are facing a problem that using the same app how can we separate Development database(Sandbox) and Production database.

Let say we have an App which is live in production and simultaneously we need to do development activity on the app , but since the database is same it will make the changes on the live app.

So on the similar lines of Production and Sandbox databases how can we achieve this in appery?

You can create a backup of your database and restore a clone.

In your code, implement a version number global variable and on your database implement a control table that reads the control table by version number ... The controltable can then tell you whether or not that version is a test or prod version as you promote it....

On your app settings service you can then control which database you are looking at ... By keeping the keys to each database there as variables and moving them to the variable that the apppery services looking at during runtime.

That's a lot to digest in a short paragraph but I'm using that scheme right now for a couple of apps and can share some code samples as well.

I'm sure there are other ways ... And someone from apppery may have a tutorial...

Best
Bruce

Bruce thanks for the answer.

For more better understanding can you please share some code samples @ a href="mailto:rahulmajumdar0806@gmail.com" rel="nofollow"rahulmajumdar0806@gmail.com/a

Thanks in advance.

Bruce I didn't hear from you , can you please share some sample codes.

Dear Rahul,

We can suggest that you use different databases, as Bruce mentioned, you can create a backup of your database and restore a clone.

We do not have code samples to share, hope that Bruce will be able to provide you with them.

Rahul,

Sorry for being absent here ... A bit of a family emergency .

I'm contacting you now at your email address to close the loop here.

Best,
Bruce

Bruce sorry i didn't received the mail can you please re-share?