How to generate a database-setup script out of a appwrite-cloud-instance?
I've written a vue.js webapp with appwrite-cloud-db (including relations) and everything works just perfectly! Now I want to release this webapp as an open source project that anyone can checkout and run locally with as much automation as possible.
Therefore I have to find a way to automate the following steps:
- install self-hosted appwrite locally with docker
- import a predefined database schema with sample data into appwrite
- start webserver
How to achieve step 2? If it would be just a sql-db, I would just generate an sql-import-script (create database, create table etc., insert into table ) and run this against the local database in a start script.
But how to do the automated db-import with appwrite? How can I create a local importable database export file from a appwrite cloud database? Can this be achieved only with an external lib like appwrite-utils-cli? Or is the only option to code the import manually by my own using server SDK with commands like databases.createCollection ...?
Any kind of help is greatly appreciated. Tom
The Appwrite CLI is the easiest way to deploy a collection. updating it is a different matter, though
