Development database - Personal Plan

[breinbaasnl]

Hi there,

First of all, thanks so much for developing Anvil… it’s such a pleasure to only be using Python for web development. It took me some time to find Anvil but I think this is the best that happened to my plans for a commercial app that I was thinking about all the time.

I do have one recommendation. I would definitely switch to the professional plan once I get a customer or two but before I reach that stage I am working on the personal plan. This is a great plan and I love the options. The only thing I really miss is a development database which I think would be part of the professional plan. The reason I say this is that I have some app testers (I am the only dev) who are working on the master branch deployment and I am working on other branches and sometimes that involves database changes that mess up the current ‘master’ app.

So maybe I have not seen an option to solve this but it would be nice to have a dev and master database so people can build their app on the personal level and switch to professional once they start making money.

Off course, there should be a reason to switch to professional so I get it if this is asking too much You guys / girls definitely deserve the money for this platform!

Cheers,
Rob

[ianb]

I came up with this trick to duplicate a table easier, perhaps your team can make a development copy of the DB, then replace the relevant bits of code with some sort of development names switch?

Duplicate Databases

Never tried this but… Run the clone link of your project, creating a clone copy which will include the old table. Rename the cloned table for clarity. In your original project “create a new table” with the + symbol but choose to use the database linked from the “clone” instead of creating a new one. (I don’t use the beta editor, so I’m not sure if this is available in it yet?) Delete your cloned project and it should leave your linked clone table with the original project as the only “owner” D…

[jshaffstall]

Before the Beta editor and separate environments were available, a lot of people used separate apps for Development and Production versions. Generally speaking, it involved:

1. Using your current app for the Development version
2. Using git clone to download the Development app to your computer
3. Creating an empty app to be the Production version
4. Pushing your git repo up to the Production version

Once it’s setup, you can make changes to your Development app, pull those changes to your computer and push them to the Production version.

Data table schema changes are not handled through this, so that requires some more tracking on your part and manually making those changes.

The entire process is not as simple as the Beta editor’s environments makes it now, but it was workable.

The docs for the Classic editor still have the instructions for setting all that up: Anvil Docs | Apps in development and production