Answer the question
In order to leave comments, you need to log in
Which scheme is better to choose for storing arbitrary data?
Hello.
I am making a web application in which users can upload csv files of any format and work with them. I thought about how to store such data and what would be better in this case, Postgres or MongoDB?
So far, there are 2 options in my head: store each such document as a separate table / collection and keep the link user-> collections
or create one common storage for everything (MongoDB will be more convenient here).
I didn’t do anything like that, and then I don’t really want to redo the schema and migrate a bunch of data;
Answer the question
In order to leave comments, you need to log in
from the text of the question we can see that:
csv: this is a table with an arbitrary number of fields and untyped data.
It is better to store as a collection unambiguously.
I am not a master in this matter, but I think it will be OK to use "key" and "value" here.
ключ = id
значение = данные в JSON формате
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question