How to efficiently store a two-dimensional array with different File types in a Django Model (PostgresSQL)
|Added at||2017-01-02 18:01|
I will like to store in a Django model the variations on the price of some houses for a date. For example:
Because I'm using PostgreSQL I can use a two-dimensional array with ArrayField. But I think it can't contain different type of Fields (for example date and int).
I will also like to be efficient when doing queries to get the prices for all the houses between 2 dates.
So my question: which is the best approach for this problem?