Hi, I am totally new to programming, but in a bid to improve, I am trying to answer any question I reckon I can add value on......so...!..
I would probably define two tables: *Sources data* This table details each of your 38 sources and gives them an ID, you can give them a name, detail the URL you are using, description, etc. *Time Series data* This tables would have 4 columns, ID (unique ref) reference ID - this links to the previous table Date Amount This way you can put all the data in this table, and minimise any duplicate info. Maybe put an index in place - not too sure how these work - but I think they help speed searching, this might be needed if you have lots of values. Your dashboard can then pull info from the time series data to build the graphs yet pull names, source info from the sources data table. Let me know what you think! On Tuesday, 8 April 2014 00:53:20 UTC+2, Trent Telfer wrote: > > I am attempting to build a small webpage that takes some pricing data from > a few external sources and displays it on one concise page (a dashboard of > sorts). My problem is I have 38 timeseries to input in the database and I > am hoping someone here can suggest a way around writing multiple > define_tables? All data is in the form of dates with one data point, but > they don't necessarily all start at the same time. > > Thanks, > > Trent > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
