[omaha] Database for two-dimensional array
Jason Hsu
jhsu802701 at jasonhsu.com
Tue Aug 13 19:53:26 CEST 2013
My Doppler Value Investing site (http://www.dopplervalueinvesting.com) uses Ruby on Rails and a Postgres database. (Yes, I know this is a Python group, but Python scripts can use Postgres databases.)
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?
--
Jason Hsu <jhsu802701 at jasonhsu.com>
More information about the Omaha
mailing list