N
N
Nodar2015-06-04 20:19:44
Database
Nodar, 2015-06-04 20:19:44

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

2 answer(s)
X
xmoonlight, 2015-06-04
@Nodar

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.

M
Mokhirjon Naimov, 2015-06-04
@zvermafia

I am not a master in this matter, but I think it will be OK to use "key" and "value" here.

ключ = id
значение = данные в JSON формате

It's kind of a one-size-fits-all solution :)

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question