Wednesday, 5 April 2017

Is it ever a good idea to use more than one database system for one app? Like a SQL database alongside a NoSQL database?

I am working on a little project, where I've got two kinds of data to save: there's classical relational data in the form of a user system, but also some (possibly big) JSON objects containing several types of data.I'd prefer to use a SQL database for the user system, but breaking down the JSON objects into data I can save there (and then retrieve) seems complicated... would it make sense to run a second database like Mongo where I can just save and retrieve the JSON objects directly as documents?To give you a bit of an idea... the users draw stuff on a SVG element. Think diagrams. When saving their work, the drawn stuff is exported as a JSON object containing stuff like labels, coordinates, color schemes, a few text fields for descirptions, etc.

Submitted April 05, 2017 at 02:18PM by DJLaMeche

No comments:

Post a Comment