Hello All, I'm building an app that will enable users to create documents using ckeditor or TinyMCE editor. The data is then stored in a database and retrieved to display to the user, these docs can contain image data also. The number of pages generated for a single document can go up to 1000. Therefore by design, each page is stored in a separate JSON. I'm wondering which database is the right one to choose between ArangoDB and PostgreSQL. Your thoughts, advice please. Thanks, Kashyap
It depends on the rest of your application/infrastructure. First would you use the features provided by the graph storage?
If not in terms of performance PostgreSQL is very good (even better than most no-sql db) for storing static JSON. If your JSON documents have to be updated frequently MongoDB could be an option as well.
Hello Jean, The application's main utility is to create and update documents therefore the choice for a database that supports json. I wouldn't go the MongoDB route due to past bad experience and licensing restrictions compared to an open source db.