Databases for dev, staging and production environments

Hey there community!

Is there an option to clone a database in Appwrite console? I already have a database created, and that's the one I'm working with for a front end I'm developing for a client, but then I'd like to have a replica of this database only for dev purposes.

It'll be amazing if after making changes to this dev database I could merge it with the staging database, or just clone it and make this cloned database the new staging database.

Is there anything like this? Thank you!

You can copy over the db structure with the CLI

$ appwrite init collections

v1.4 has backup and restore functionality, which could also be used for this

Wow, didn’t know there was a client 😅. I have the appwrite console in a digital ocean droplet, so I guess that CLI should be installed there

Thank you my friend 🫶🏼

CLI would be installed on your local machine

https://appwrite.io/docs/command-line

I used the digital ocean prepared image of appwrite. It's running on docker, so I guess all stuff should be installed. But thank you for the info, I will check it today

The CLI is totally separate from an Appwrite installation so you'll need to install it wherever you want to use it

Awesome! Thank you ❤️