Re: What is the recommended schema design for dynamic dates in Django for PostgreSQL?

2015-10-21 Thread Erik Cederstrand
> Den 20. okt. 2015 kl. 18.09 skrev Radek Svarz : > > Hi Erik, > > thanks for m2m suggestion. > > What do you think about using suggested view in DB? (@SO) (i.e. the DB would > do the conversion on the fly) In general, I think of DB views as either a performance optimization or a way to stor

Re: What is the recommended schema design for dynamic dates in Django for PostgreSQL?

2015-10-20 Thread Radek Svarz
Radek Svarz >: > > > > [...] > > Django code and further long details are @ SO: > http://stackoverflow.com/questions/33167079/what-is-the-recommended-schema-design-for-dynamic-dates-in-django-for-postgresql > > > Regarding your need for a way to denote "natural

Re: What is the recommended schema design for dynamic dates in Django for PostgreSQL?

2015-10-20 Thread Erik Cederstrand
> Den 20. okt. 2015 kl. 14.09 skrev Radek Svarz : > > [...] > Django code and further long details are @ SO: > http://stackoverflow.com/questions/33167079/what-is-the-recommended-schema-design-for-dynamic-dates-in-django-for-postgresql > Regarding your need for a way

Re: What is the recommended schema design for dynamic dates in Django for PostgreSQL?

2015-10-20 Thread Erik Cederstrand
> Den 20. okt. 2015 kl. 14.09 skrev Radek Svarz : > > [...] > 1 Milestone is a date stored as a string in form -MM-DD or a special tag > "today", which means daily changing date (dynamic - the date was not stated, > but until today is some state valid - if today is smaller then the next >

What is the recommended schema design for dynamic dates in Django for PostgreSQL?

2015-10-20 Thread Radek Svarz
ns such as: Which items will hit milestones of certain characteristics in December 2015? What is the best practise? Django code and further long details are @ SO: http://stackoverflow.com/questions/33167079/what-is-the-recommended-schema-design-for-dynamic-dates-in-django-for-postgresql Tha