I have a web application in which we show a tree content to the user, like a JSON structured file. The user, through the web application can add comments for any key of the JSON. And the main functionality is to be able to chance the value for that key and to keep an history of changes.
我有一个Web应用程序，我们向用户显示树内容，如JSON结构化文件。用户可以通过Web应用程序为JSON的任何键添加注释。主要功能是能够获得该密钥的价值并保留变更历史记录。
When the user is done modifying the structure, he can publish its changes. The output then is the same JSON file but with the latest modifications for the values.
当用户完成修改结构时，他可以发布其更改。然后输出是相同的JSON文件，但具有对值的最新修改。
Which database engine fits better this application? We are currently using MySQL but have heard from other devs that NoSQL databases can be the solution here. Should we use MongoDB, CouchDB or any of those? How would you approach the database model?
哪个数据库引擎适合这个应用程序？我们目前正在使用MySQL，但是从其他开发者那里听说NoSQL数据库可以作为解决方案。我们应该使用MongoDB，CouchDB还是其中任何一个？你会如何处理数据库模型？
Thanks!
谢谢！
1 个解决方案
#1
0
I think that choosing the database depending on your model is not the right approach. Choose your database on your availability/scalability/simplicity requirements and then figure out how to fit your model in the database you choose.
我认为根据您的模型选择数据库不是正确的方法。根据可用性/可伸缩性/简单性要求选择数据库，然后找出如何使您的模型适合您选择的数据库。
#1
0
I think that choosing the database depending on your model is not the right approach. Choose your database on your availability/scalability/simplicity requirements and then figure out how to fit your model in the database you choose.
我认为根据您的模型选择数据库不是正确的方法。根据可用性/可伸缩性/简单性要求选择数据库，然后找出如何使您的模型适合您选择的数据库。