Ruby on Rails Tuesday, August 13, 2013

On 13 August 2013 18:47, Jason Hsu, Android developer
<jhsu802701@gmail.com> wrote:
> My Doppler Value Investing site (http://www.dopplervalueinvesting.com) uses
> Ruby on Rails and a Postgres database.
>
> There are two important parts: the superficial analysis and an in-depth
> analysis.
>
> An example of the superficial analysis is at:
> http://www.dopplervalueinvesting.com/stocks/FAST
>
> An example of the in-depth analysis is at:
> http://old.doppler.webfactional.com/sites/default/files/stock-results/FAST.html
>
> Note that the results of the superficial analysis are 1-dimensional - just
> parameters. This easily fits into one row in one table of a database.
>
> Note that the results of the in-depth analysis are 2-dimensional -
> parameters AND year. How would this fit into a Postgres database? What are
> your suggestions? Is it possible to have a table within a table?

Split it into multiple tables with associations between them
(has_many, belongs to). Conceptually that can be likened to tables
within tables. Have one table for each type of data.

Colin

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/CAL%3D0gLvp%2BSOVOiFwemHEHV2Js7ky4rRyDszduk8VzsaATiFOFw%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.

No comments:

Post a Comment