The best way to write the migration script for database schema for long term maintenacy
- 0
- Self Hosted
- Tools
- Databases

I want to keep track of what have changed in the database schema, collection schema. everytime, there is changes, we create new migration script for example. just like asp.net migration script. how to archeive this. any plan appwrite creating migration script like this in the future.

You can do the same thing as those migration scripts but using the server SDK

any good pratical sample to share

This asp.net example 😜

🤣 anyone done in appwrite yet

Haven't heard of any

usually, and pratically, we use console to manage right

Ya but that's not scripting the migrations...the equivalent thing in asp.net would be to use SQL management studio

would you mind suggesting me, what if we have few devs, we have different local dev instance of appwrite, how can we keep everyone sync in the same page, of database schema.

backup/restore is option, but won't be easy to keep it synced

if appwrite has ability to keep track of what has been changed ( such as collection schema, or even data). then able to generate the chaanges into script and able to share to other to just run it . this would be life saver.

The appwrite CLI has a json file, but it's only for clean deployments since it deletes attributes and recreates them.


yes. right.
Recommended threads
- 404 errors after 7 Days
Local hosted Appwrite via docker. Last version and current version. After exactly 7 days Appwrite stops working. I get 404 route not found, cannot access anyth...
- unable to modify attribute
please help: when I try to modify attribute size or key or anything, I am getting this errors: ``` Deprecated: strtolower(): Passing null to parameter #1 ($str...
- my database attribute stuck in processin...
when i created attributes in collection 3 of those attributes become "processing", and they are not updating, the worst thing is that i cant even delete them s...
