A project team adopting DDD asked me if an immutable data model is possible with AppSheet.
I agree with the high ideals of the immutable data model, but I think it is very difficult to proceed with actual application development based on the immutable data model.
In addition, I responded that it is not realistic to try to achieve this in AppSheet because it would require application development based on the following restrictions.
* Need to prohibit all Update and Delete at the table level
* It would naturally also prohibit App formula, Reset on edit and more.
* Slice needed for all tables to represent the most recent table statement
* Conditioning to achieve the above would be a complex Expression.
However, I am also thinking that perhaps an AppSheet app could be created that employs an immutable data model.
If such an app exists, I would be very interested to know the implementation policy and would be glad to hear about it.๐ค
Reference links for immutable data model
https://vertabelo.com/blog/immutable-data-in-database-tip/
https://terminusdb.com/blog/9-reasons-why-you-need-an-immutable-database/
https://www.tibco.com/reference-center/what-is-immutable-data
LinkedIn
Twitter
