[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